Commonly used PostgreSQL HA (High Available) Tools Collection - available, collection, common, HA, high, PostgreSQL, tools

PostgreSQL HA Collect:

1.pgpool

2.Pacemaker + Corosync

3.ecox

4 .Patroni: A Template for PostgreSQL HA with ZooKeeper, etcd or Consul

Patroni originated as a fork of Governor, the project from Compose. It includes plenty of new features.

5. Governor: A Template for PostgreSQL HA with etcd, has been deprecated, they recommend patroni

Advantages of Consul

· Use Raft algorithm to ensure consistency, which is more direct than complex Paxos algorithm In comparison, zookeeper uses Paxos, while etcd uses Raft.

· Supports multiple data centers, and services on the internal and external networks use different ports for monitoring. Multi-data center clusters can avoid a single point of failure of a single data center, and its deployment needs to consider network delays, fragmentation, etc., etc. Zookeeper and etcd do not provide support for multi-data center functions.

· Support health check. etcd does not provide this function.

· Supports http and dns protocol interfaces. The integration of zookeeper is more complicated, etcd only supports http protocol.

· The official web management interface is provided , etcd does not have this function.

6. pglookout-PostgreSQL replication monitoring and failover daemon

7. repmgr-replication manager for PostgreSQL clusters

8. pg_keeper- Background worker based simple failover daemon.

In addition:

joyent / moray a key/value database

joyent / manatee high availability cluster

https://momjian.us/main/blogs/pgblog/2019.html Blog bruce momjian

MonetDB column storage

PostgreSQL HA Collect:

1.pgpool

2.Pacemaker + Corosync

3.ecox

4.Patroni: A Template for PostgreSQL HA with ZooKeeper, etcd or Consul

Patroni originated as a fork of Governor, the project from Compose. It includes plenty of new features.

5.Governor: A Template for PostgreSQL HA with etc d. It has been deprecated. They recommend patroni

Advantages of Consul

· Use the Raft algorithm to ensure consistency, which is more direct than the complex Paxos algorithm. In comparison, zookeeper uses It is Paxos, and etcd uses Raft.

· Supports multiple data centers, and services on the internal and external networks use different ports for monitoring. Multi-data center clusters can avoid single points of failure in a single data center, and its deployment needs to consider network delays, fragmentation, etc., etc.Neither zookeeper nor etcd provide support for multi-data center functions.