Re: load balancer and connection pooling combined

From: Victor Sudakov <vas(at)sibptus(dot)ru>
To: pgsql-admin(at)lists(dot)postgresql(dot)org
Subject: Re: load balancer and connection pooling combined
Date: 2021-03-08 05:41:14
Message-ID: YEW4+vjBJNl2FDPa@admin.sibptus.ru
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-admin

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(at)fidonet
>
>

--
Victor Sudakov VAS4-RIPE
http://vas.tomsk.ru/
2:5005/49(at)fidonet

In response to

Browse pgsql-admin by date

  From Date Subject
Next Message Peter Wainaina 2021-03-08 11:23:43 RESTRICT TABLE OWNER NOT TO DELETE IT
Previous Message Tom Lane 2021-03-07 16:20:09 Re: could not load library "$libdir/plpython2" while upgrading from postgresql-10 to 12