From: Victor Sudakov <vas@sibptus.ru>
To: pgsql-admin@lists.postgresql.org
Subject: Re: load balancer and connection pooling combined
Date: Mon, 8 Mar 2021 12:41:14 +0700
Message-ID: <YEW4+vjBJNl2FDPa@admin.sibptus.ru> (raw)
In-Reply-To: <YD9XjqV5tNptwQVq@admin.sibptus.ru>
References: <YD9XjqV5tNptwQVq@admin.sibptus.ru>
Does such a thing not exist? Is Pgpool-II not good enough in your experience?
Victor Sudakov wrote:
> Dear Colleagues,
>
> 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?
>
> --
> Victor Sudakov VAS4-RIPE
> http://vas.tomsk.ru/
> 2:5005/49@fidonet
>
>
--
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: <YEW4+vjBJNl2FDPa@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