article thumbnail

The Ultimate Guide to Database High Availability

Percona

High availability works through a combination of the following: No single point of failure (SPOF) : You must eliminate any single point of failure in the database environment, including physical or virtual hardware the database system relies on that would cause it to fail. Please note that these are presented as general best practices.

article thumbnail

Setting Up and Deploying PostgreSQL for High Availability

Percona

The tolerable downtime depends on business size, operations, and objectives, but that downtime must be minimal to minuscule (see the “Measuring high availability” chart below). HA in PostgreSQL databases delivers virtually continuous availability, fault tolerance, and disaster recovery. there cannot be high availability.