CompTIA DataSys+ (DS0-001)Database DeploymentHard
A database administrator is tasked with deploying a new PostgreSQL database server for a critical financial application. The application requires high availability and automatic failover in case of a primary server failure. Which architectural component is typically used in conjunction with PostgreSQL streaming replication to achieve automatic failover?
- Apg_basebackup
- Bpg_rewind
- CPatroni
- Dpg_dump
Show answer & explanationAnswer & explanation
Correct answer: C. Patroni
Patroni is a robust open-source solution that provides high availability for PostgreSQL by managing clusters, handling automatic failover, and promoting replicas. It orchestrates streaming replication and provides a REST API for management.
Why the other options are wrong
- A. pg_basebackup is used to take base backups of a PostgreSQL cluster, essential for setting up replicas, but not for automatic failover.
- B. pg_rewind is a utility for quickly synchronizing a failed primary server with its new timeline after failover, not for automatic failover itself.
- D. pg_dump is used for logical backups of a database, not for managing replication or failover.
PostgreSQL High Availability
Ensuring continuous operation of a PostgreSQL database system, often involving replication, monitoring, and automatic failover mechanisms.
- Streaming replication is foundational for HA.
- Tools like Patroni or pg_auto_failover automate failover.
- Requires robust monitoring to detect primary failures.
Memory trick: HA for PostgreSQL needs a smart conductor.