Crypto Discover
cloud Technical

Managing High Availability in PostgreSQL – Part III: Patroni

In our previous blog posts, we discussed the capabilities and functioning of PostgreSQL Automatic Failover (PAF) by Cluster Labs and Replication Manager (repmgr) by 2ndQuadrant. In the final post of this series, we will review the last solution, Patroni by Zalando, and compare all three at the end so you can determine which high availability framework is best for your PostgreSQL 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 project from Compose. It is an open-source tool suite, written in Python, for managing high availability of PostgreSQL clusters. Instead of building its own consistency protocol, Patroni smartly leverages the consistency model provided by a Distributed Configuration Store (DCS). It also supports other DCS solutions like Zookeeper, etcd, Consul and Kubernetes.

Patroni ensures the end-to-end setup of PostgreSQL HA clusters, including streaming replication. It supports various ways for creating a standby node, and works like a template that can be customized to your needs.

This feature-rich tool exposes its functionality via REST APIs and also via a command-line utility called patronictl. It supports integration with …

Read More on Datafloq

Source link

Related posts

Ethereum Price Analysis: ETH Could Make Sustained Move Higher


Bitcoin (BTC) Bears Need To Be Cautious, Bulls Won’t Give Up Easily


Ethereum (ETH) Eyes Fresh Rally To $200, Bitcoin Up 3%


Leave a Comment