From: cen <cen.is.imba@gmail.com>
To: Inzamam Shafiq <inzamam.shafiq@hotmail.com>
Cc: pgsql-general@lists.postgresql.org <pgsql-general@lists.postgresql.org>
Subject: Re: Patroni vs pgpool II
Date: Tue, 4 Apr 2023 15:40:44 +0200
Message-ID: <3a4d8c1c-c703-4eb3-a442-cb9f40796b2d@gmail.com> (raw)
In-Reply-To: <AM9P251MB033074BFEBB9AA40955B5B7598929@AM9P251MB0330.EURP251.PROD.OUTLOOK.COM>
References: <AM9P251MB033074BFEBB9AA40955B5B7598929@AM9P251MB0330.EURP251.PROD.OUTLOOK.COM>
> 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?
Having used pgpool in multiple production deployments I swore to never
use it again, ever.
The first reason is that you need a doctorate degree to try to
understand how it actually works, what the pcp commands do in each
scenario and how to correctly write the failover scripts.
It is basically a daemon glued together with scripts for which you are
entirely responsible for. Any small mistake in failover scripts and
cluster entersĀ a broken state.
Even once you have it set up as it should, yes, it will fail over
correctly but it won't autoheal without manual intervention.
You also often end up in weird situation when backends are up, pgpool
reports down and similar scenarios and then you need to run the precise
sequence of pcp commands to recover
or destroy your whole cluster in the process if you mistype.
I haven't used patroni yet but it surely can't be worse.
Best regards, cen
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients from your mail client; the link fills in
the headers below: reply via email
Some clients, webmail especially, drop In-Reply-To and References from
a link, and the reply then starts a new thread: use the mbox below.
To: pgsql-general@postgresql.org
Cc: cen.is.imba@gmail.com, inzamam.shafiq@hotmail.com
Subject: Re: Patroni vs pgpool II
In-Reply-To: <3a4d8c1c-c703-4eb3-a442-cb9f40796b2d@gmail.com>
References: <AM9P251MB033074BFEBB9AA40955B5B7598929@AM9P251MB0330.EURP251.PROD.OUTLOOK.COM> <3a4d8c1c-c703-4eb3-a442-cb9f40796b2d@gmail.com>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox