VoltDB

MAY 2, 2017

We recently received a question from a customer who was looking for a quick way to repurpose some VoltDB production servers to create a disaster recovery site. Say you have five VoltDB servers in production, with k-factor=2, and no disaster site. You want to shift some of these servers to create a disaster recovery site.

Hardware 40

Hardware Database Servers Tuning 40

Abhishek Tiwari

JULY 12, 2018

These nodes and edges require a good amount of compute and storage which is typically distributed across a large number servers either running in the cloud or your own data center. A data pipeline is a software which runs on hardware. The software is error-prone and hardware failures are inevitable.

Latency 63

Latency Analytics Scalability Engineering 63

Percona

OCTOBER 18, 2023

Our goal with this post is to equip you with a comprehensive understanding of the steps, best practices, and pros and cons to ensure a smooth — and successful — transition to an open source database environment. Evaluating your hardware requirements is another vital aspect of resource allocation.

Open Source 93

Open Source Database Hardware Strategy 93

SQL Performance

JUNE 21, 2019

I've been teaching and writing about common SQL Server mistakes for many years. This article will expand on my previous article and point out how these apply to SQL Server , Azure SQL Database , and Azure SQL Managed Instance. SQL Server Agent alerts. This situation applies to on-premises SQL Server and IaaS. Statistics.

Servers 49

Servers Azure Hardware Database 49

HammerDB

OCTOBER 12, 2018

This post complements the previous best practice guides this time with the focus on MySQL and MariaDB and achieving top levels of performance with the HammerDB MySQL TPC-C test. As is also the case this limitation is at the database level (especially the storage engine) rather than the hardware level.

Best Practices 40

Best Practices Scalability Performance C++ 40

Brendan Gregg

SEPTEMBER 25, 2021

This server is spending about a third of its CPU cycles just checking the time! As a Xen guest, this profile was gathered using perf(1) and the kernel's software cpu-clock soft interrupts, not the hardware NMI. 30.14% in the middle of the flame graph. Searching shows it was elsewhere as well for a total of 32.1%.

Speed 126

Speed Java AWS Virtualization 126

SQL Server According to Bob

JANUARY 11, 2020

Microsoft, ​​ Windows, ​​ Windows NT, ​​ and Windows Server ​​ are registered trademarks of Microsoft Corporation in the United States and/or other countries. The names of actual companies and products mentioned herein may be the trademarks of their respective owners.

Servers 40

Servers Cache Database Media 40

Percona

AUGUST 5, 2023

KEY partitioning KEY partitioning is similar to HASH partitioning, except that only one or more columns to be evaluated are specified, and the MySQL server provides its own hashing function. This helps identify potential issues and fine-tune the partitioning strategy. Documentation : Always be documenting!

Strategy 40

Strategy Storage Database Best Practices 40

Smashing Magazine

AUGUST 22, 2021

Latency can be roughly defined as the time it takes to send a packet from point A (say, the client) to point B (the server). It is physically limited by the speed of light or, practically, how fast signals can travel in wires or in the open air. As such, even low latencies of less than 50 milliseconds can add up to considerable delays.

Performance 106

Performance Network Latency Servers 106

Brendan Gregg

SEPTEMBER 25, 2021

This server is spending about a third of its CPU cycles just checking the time! As a Xen guest, this profile was gathered using perf(1) and the kernel's software cpu-clock soft interrupts, not the hardware NMI. 30.14% in the middle of the flame graph. Searching shows it was elsewhere as well for a total of 32.1%.

Speed 40

Speed Java AWS Virtualization 40

O'Reilly

OCTOBER 11, 2022

It’s possible to augment this basic process with OCR so the application can find data on paper forms, or to use natural language processing to gather information through a chat server. Andrew Ng , Christopher Ré , and others have pointed out that in the past decade, we’ve made a lot of progress with algorithms and hardware for running AI.

Games 116

Games Healthcare Processing Retail 116

Scalegrid

JULY 13, 2020

Compare ease of use across compatibility, extensions, tuning, operating systems, languages and support providers. The $47,500 licensing costs for Oracle Enterprise Edition is only for one CPU core, that ultimately has to be multiplied with the actual number of cores on the physical server. So Which Is Best? Compare Ease of Use.

Open Source 244

Open Source Tuning C++ Database 244