An administrator needs to create a custom PostgreSQL HA software profile. Which software component manages the state of the cluster and handles failover?

Question

Options

• Aetcd
• Bkeepa lived
• CHAProxy
• DPatroni

• A
  2% (1)
• B
  2% (1)
• C
  5% (2)
• D
  91% (40)

Explanation

NDB supports PostgreSQL HA software profiles for provisioning PostgreSQL databases with high availability. PostgreSQL HA software profiles consist of three components: etcd, HAProxy, and etcd is a distributed key-value store that provides a reliable way to store configuration data across a cluster of machines. etcd is used by Patroni to store and synchronize the cluster state and HAProxy is a load balancer that distributes incoming requests to the PostgreSQL nodes. HAProxy is used to expose a single endpoint for database connections even as the roles of the individual nodes change. Patroni is a template for PostgreSQL high availability. Patroni is responsible for managing the state of the cluster and handling failover. Patroni uses etcd as the distributed configuration store and relies on HAProxy for load balancing. Therefore, the software component that manages the state of the cluster and handles failover is

No community discussion yet for this question.