Re: Patroni vs pgpool II - Mailing list pgsql-general

From Jehan-Guillaume de Rorthais
Subject Re: Patroni vs pgpool II
Date
Msg-id 20230404142558.0e1da98e@karst
Whole thread Raw
In response to Patroni vs pgpool II  (Inzamam Shafiq <inzamam.shafiq@hotmail.com>)
List pgsql-general
On Mon, 3 Apr 2023 06:33:46 +0000
Inzamam Shafiq <inzamam.shafiq@hotmail.com> wrote:
[...]
> Can someone please suggest what is one (Patroni vs PGPool II) is best for
> achieving HA/Auto failover, Load balancing for DB servers. Along with this,
> can you please share the company/client names using these tools for large PG
> databases?

Load balancing is best achieved from the application side.

The most popular auto failover solution is Patroni.

Other solutions are involving Pacemaker to either:

* build a shared storage cluster with a standalone instance moving from node to
  node (but this can include standbys)
* build a cluster with a promotable resource using eg. the PAF resource agent,
  that will decide where to start the standbys and which one to promote.

No matter the solution you pick, be prepared to learn and train. A lot.



pgsql-general by date:

Previous
From: Dominique Devienne
Date:
Subject: Re: DEFINER / INVOKER conundrum
Next
From: cen
Date:
Subject: Re: Patroni vs pgpool II