Thread: FAIL-OVER AND LOAD BALANCING
Hello i need an advice on an OPEN SOURCE TOOL to handle failover for replication.Currently am trying pg_auto_failover but stacked in the configuration.
WEB developer and programmer
system analyst-crm
blogger
repmgr for automated failovers.
pgpool2 for connection pooling, read and write query load balancing.
Although you can use pgpool2 for failovers as well but repmgr is more reliable for the same job.
On Wed, Sep 25, 2019 at 9:17 PM Peter Wainaina <petwah17@gmail.com> wrote:
Hello i need an advice on an OPEN SOURCE TOOL to handle failover for replication.Currently am trying pg_auto_failover but stacked in the configuration.WEB developer and programmersystem analyst-crmblogger
Look at Patroni first https://patroni.readthedocs.io/en/latest/. It's the most popular choice nowadays, at least among my Twitter followers :) https://twitter.com/postgresmen/status/1019702905593446400
More choices you can find in this list: https://github.com/dhamaniasad/awesome-postgres#high-availability
On Wed, Sep 25, 2019 at 11:46 AM Peter Wainaina <petwah17@gmail.com> wrote:
Hello i need an advice on an OPEN SOURCE TOOL to handle failover for replication.Currently am trying pg_auto_failover but stacked in the configuration.