From: Victor Sudakov <vas@sibptus.ru>
To: pgsql-admin@lists.postgresql.org
Subject: Re: load balancer and connection pooling combined
Date: Wed, 3 Mar 2021 17:34:27 +0700
Message-ID: <YD9mM7+LGQcMR2Vj@admin.sibptus.ru> (raw)
In-Reply-To: <YD9XjqV5tNptwQVq@admin.sibptus.ru>
References: <YD9XjqV5tNptwQVq@admin.sibptus.ru>
Victor Sudakov wrote:
>
> Based on your personal experience and industry best practices, what load
> balancer combined with connection pooler can you advise?
>
> 1. I have good experience with pgpool, it's a great and robust
> connection pooler, but it cannot do load balancing and failover (or
> rather, it can do very rudimentary load balancing).
>
> 2. I have limited experience with Haproxy, it's great for load balancing
> and failover, but it's not a connection pooler, and its pgsql-check is
> not good enough, I guess you have to use an external check.
>
> Is there the "one thing to rule them all" that does all of the above and
> is well-tested and reliable?
If it could parse Patroni's REST API like Haproxy can, it would be even more perfect.
--
Victor Sudakov VAS4-RIPE
http://vas.tomsk.ru/
2:5005/49@fidonet
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 using the --to and --cc options:
reply via email
To: pgsql-admin@postgresql.org
Cc: vas@sibptus.ru, pgsql-admin@lists.postgresql.org
Subject: Re: load balancer and connection pooling combined
In-Reply-To: <YD9mM7+LGQcMR2Vj@admin.sibptus.ru>
* 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