pg.ddx.io pgsql-admin@postgresql.org mailing list archive
help / color / mirror / Atom feedload balancer and connection pooling combined
3+ messages / 1 participants
[nested] [flat]
* load balancer and connection pooling combined
@ 2021-03-03 09:31 Victor Sudakov <vas@sibptus.ru>
2021-03-03 10:34 ` Re: load balancer and connection pooling combined Victor Sudakov <vas@sibptus.ru>
2021-03-08 05:41 ` Re: load balancer and connection pooling combined Victor Sudakov <vas@sibptus.ru>
0 siblings, 2 replies; 3+ messages in thread
From: Victor Sudakov @ 2021-03-03 09:31 UTC (permalink / raw)
To: pgsql-admin@lists.postgresql.org
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
^ permalink raw reply [nested|flat] 3+ messages in thread
* Re: load balancer and connection pooling combined
2021-03-03 09:31 load balancer and connection pooling combined Victor Sudakov <vas@sibptus.ru>
@ 2021-03-03 10:34 ` Victor Sudakov <vas@sibptus.ru>
1 sibling, 0 replies; 3+ messages in thread
From: Victor Sudakov @ 2021-03-03 10:34 UTC (permalink / raw)
To: pgsql-admin@lists.postgresql.org
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
^ permalink raw reply [nested|flat] 3+ messages in thread
* Re: load balancer and connection pooling combined
2021-03-03 09:31 load balancer and connection pooling combined Victor Sudakov <vas@sibptus.ru>
@ 2021-03-08 05:41 ` Victor Sudakov <vas@sibptus.ru>
1 sibling, 0 replies; 3+ messages in thread
From: Victor Sudakov @ 2021-03-08 05:41 UTC (permalink / raw)
To: pgsql-admin@lists.postgresql.org
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
^ permalink raw reply [nested|flat] 3+ messages in thread
end of thread, other threads:[~2021-03-08 05:41 UTC | newest]
Thread overview: 3+ messages (download: mbox mbox.gz follow: Atom feed)
-- links below jump to the message on this page --
2021-03-03 09:31 load balancer and connection pooling combined Victor Sudakov <vas@sibptus.ru>
2021-03-03 10:34 ` Victor Sudakov <vas@sibptus.ru>
2021-03-08 05:41 ` Victor Sudakov <vas@sibptus.ru>
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