Обсуждение: FAIL-OVER AND LOAD BALANCING

Поиск
Список
Период
Сортировка

FAIL-OVER AND LOAD BALANCING

От
Peter Wainaina
Дата:
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

Re: FAIL-OVER AND LOAD BALANCING

От
Prince Pathria
Дата:
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.

Happy to help :)
Prince Pathria Systems Engineer Evive +91 9478670472 goevive.com


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 programmer

system analyst-crm

blogger

Re: FAIL-OVER AND LOAD BALANCING

От
Nikolay Samokhvalov
Дата:
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


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.