Re: Patroni vs pgpool II

Hi,

On Wed, 5 Apr 2023 at 01:01, Tatsuo Ishii <ishii(at)sraoss(dot)co(dot)jp> wrote:

> Hi,
>
> I am not sure if Patroni provides load balancing feature.
>

It depends on understanding of load-balancing:
- If we talk about load balancing read-only traffic across multiple
replicas - it is very easy to achieve with Patroni.
- If we talk about parsing all queries in order to figure out whether they
are read-write or read-only, then no.

BUT, even if there is a solution that parses queries to make a decision it
I would not recommend anyone to use it unless all consequences are
understood.
Specifically, not every read-only query could be salefy sent to a replica,
because they could be lagging behind the primary.
Only application (developers) could decide whether for a specific query
they could afford slightly outdated results. Most of the popular
application frameworks support configuring two connection strings for this
purpose.

Regards,
--
Alexander Kukushkin