Patroni: A Template for PostgreSQL HA with ZooKeeper, Etcd, or Consul

Re:Patroni: A Template for PostgreSQL HA with ZooKeeper, Etc... by CyberDem0n on Friday April 14, 2017 @03:19PM (#14116500)

Patroni has REST API providing a health-checks for load-balancers. patroni:8008/replica will respond with http status code 200 only if node is running as replica.

In the HAProxy config file you just need to list all Patroni nodes, specify a health-check and it will do a load-balancing for you.

The same approach works for example with AWS ELB.

[ Parent | on HN ]

Re:Patroni: A Template for PostgreSQL HA with ZooKeeper, Etc... by geoka9 on Friday April 14, 2017 @03:50PM (#14116742)

But writes need to be directed to the master, right? Or Patroni is smart enough to do it by itself?

[ Parent | on HN ]

Re:Patroni: A Template for PostgreSQL HA with ZooKeeper, Etc... by CyberDem0n on Friday April 14, 2017 @04:06PM (#14116859)

Correct. Writes need to be directed to master. May be not only writes but some reads as well. Only application can know which statement can be executed on replicas and which must be executed on master.

[ Parent | on HN ]