From: | Scott Ribe <scott_ribe(at)elevated-dev(dot)com> |
---|---|
To: | Achilleas Mantzios <a(dot)mantzios(at)cloud(dot)gatewaynet(dot)com> |
Cc: | pgsql-admin(at)lists(dot)postgresql(dot)org |
Subject: | Re: Connection pooler / LDAP auth / Load Balancing on read-only queries |
Date: | 2024-07-03 20:32:29 |
Message-ID: | D20C9519-9AEB-411E-A49A-584CFB4678D5@elevated-dev.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-admin |
the read only detection is tricky--consider transaction level pooling, and the first query is read only
--
Scott Ribe
scott_ribe(at)elevated-dev(dot)com
https://www.linkedin.com/in/scottribe/
> On Jul 3, 2024, at 2:25 PM, Achilleas Mantzios <a(dot)mantzios(at)cloud(dot)gatewaynet(dot)com> wrote:
>
> Dear Members
>
> I am searching (like many others) of the holy grail of PostgreSQL pooling + Load Balancing . Ideally I would like :
>
> - A pgbouncer with better/native LDAP (not PAM) / and eventually Kerberos support
>
> - A pgbouncer enhanced with load balancing read-only queries (like pgpool)
>
> or
>
> - A pgpool-II with better resources utilization / more efficient pooling (like pgbouncer)
>
>
> There are other solutions available pgcat (no LDAP), odyssey (no load balancing) , pgagroal, supavisor, none of which seem to cover the above.
>
> Some ppl advice , keeping pgbouncer close to the app(s) and pgpool close to the DB. But kinda had mixed feelings putting the two work together.
>
> I'd like to ask if there any thoughts or even hopes that some of the above will be available in a single software, or otherwise how do people tackle this.
>
> Thank you
>
> --
> Achilleas Mantzios
> IT DEV - HEAD
> IT DEPT
> Dynacom Tankers Mgmt (as agents only)
>
>
>
From | Date | Subject | |
---|---|---|---|
Next Message | Holger Jakobs | 2024-07-03 20:32:49 | Re: Connection pooler / LDAP auth / Load Balancing on read-only queries |
Previous Message | Achilleas Mantzios | 2024-07-03 20:25:02 | Connection pooler / LDAP auth / Load Balancing on read-only queries |