Percona

JULY 7, 2023

Unfortunately, using certain open source database software as part of an HA architecture can present significant challenges. Downtime due to SPOFs can also be attributed to bottlenecks from architectures designed for applications instead of databases. Despite all its upside, PostgreSQL software presents such challenges.

Availability 82

Availability Open Source Architecture Database 82

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 and the Return on Agility. By Werner Vogels on 16 August 2012 10:00 AM. Comments ().

AWS 118

AWS Hardware Traffic Best Practices 118

Percona

APRIL 17, 2023

The swap issue is explained in the excellent article by Jeremy Cole at the Swap Insanity and NUMA Architecture. For example: Read/Write tickets WiredTiger uses tickets to control the number of read / write operations simultaneously processed by the storage engine. The report focuses on MySQL, but it is valid for MongoDB as well.

Best Practices 52

Best Practices Design Tuning Database 52