Percona

JULY 7, 2023

Unfortunately, using certain open source database software as part of an HA architecture can present significant challenges. Despite all its upside, PostgreSQL software presents such challenges. PostgreSQL software supports synchronous streaming replication, asynchronous streaming replication, and logical replication.

Availability 87

Availability Open Source Architecture Database 87

SQL Server According to Bob

JANUARY 11, 2020

Microsoft SQL Server I/O Basics Author: ​​ Bob Dorr, Microsoft SQL Server Escalation Published: ​​ December, 2004 SUMMARY: ​​ Learn the I/O requirements for Microsoft SQL Server database file operations. This White Paper is for informational purposes only.

Servers 40

Servers Cache Media Hardware 40

All Things Distributed

AUGUST 16, 2012

An apples to apples comparison of the costs associated with running various usage patterns on-premises and with AWS requires more than a simple comparison of hardware expense versus always-on utility pricing for compute and storage. Total Cost of Ownership. This option offers 68% savings over the on-premises option.

AWS 118

AWS Hardware Traffic Best Practices 118

Percona

AUGUST 30, 2018

Because recognizing if the workload is read intensive or write intensive will impact your hardware choices, database configuration as well as what techniques you can apply for performance optimization and scalability. While our white paper Performance at Scale could provide useful insight if you are at the planning or review stage.

Benchmarking 48

Benchmarking Database Operating System Architecture 48

SQL Server According to Bob

JANUARY 11, 2020

This White Paper is for informational purposes only. Copyright The information ​​ that is contained ​​ in this document represents the current view of Microsoft Corporation on the issues discussed as of the date of publication.

Servers 40

Servers Cache Database Media 40

Adrian Cockcroft

NOVEMBER 13, 2023

The carbon footprint of a large rack mounted server is order-of-magnitude a ton of carbon a year. The GSF Software Carbon Intensity specification has published a case study that shows how to do this for application workloads, where SCI produces a marginal carbon per transaction figure for a specific workload.

Energy 52

Energy Cloud Traffic Transportation 52

Percona

APRIL 17, 2023

It is common to see a value of “ 0″ ( or sometimes “10” ) on database servers, telling the kernel to prefer to swap to memory for better response times. 20-30% is a good general default for “dirty_ratio,” but on large-memory database servers, this can be a lot of memory.

Best Practices 52

Best Practices Design Tuning Database 52