Managing High Availability in PostgreSQL – Part III: Patroni
In our earlier weblog posts, we talked about the capabilities and functioning of PostgreSQL Automatic Failover (PAF) by Cluster Labs and Replication Manager (repmgr) by 2ndQuadrant. In the final word put up of this assortment, we’re going to consider the ultimate decision, Patroni by Zalando, and look at all three on the end so you can determine which extreme availability framework is best to your PostgreSQL web internet hosting deployment.
Managing High Availability in PostgreSQL – Part I: PostgreSQL Automatic Failover
Managing High Availability in PostgreSQL – Part II: Replication Manager
Managing High Availability in PostgreSQL – Part III: Patroni
Patroni for PostgreSQL
Patroni originated as a fork of Governor, a problem from Compose. It is an open-source gadget suite, written in Python, for managing extreme availability of PostgreSQL clusters. Instead of establishing its private consistency protocol, Patroni effectively leverages the consistency model supplied by a Distributed Configuration Store (DCS). It moreover helps totally different DCS choices like Zookeeper, etcd, Consul and Kubernetes.
Patroni ensures the end-to-end setup of PostgreSQL HA clusters, along with streaming replication. It helps quite a few strategies for making a standby node, and works like a template which may be custom-made to your desires.
This feature-rich gadget exposes its efficiency by means of REST APIs and likewise by means of a command-line utility known as patronictl. It helps integration with …
