public inbox for [email protected]
help / color / mirror / Atom feedPGBouncer - Load balancing options
2+ messages / 2 participants
[nested] [flat]
* PGBouncer - Load balancing options
@ 2024-10-10 10:02 Ravi Varma Addala <[email protected]>
0 siblings, 1 reply; 2+ messages in thread
From: Ravi Varma Addala @ 2024-10-10 10:02 UTC (permalink / raw)
To: pgsql-general
Hello Team,
I wanted to reach out to provide some insight into a request from my customer regarding their multiple PostgreSQL Flex instances with PGbouncer. Currently, they are utilizing an Azure Load Balancer which distributes connections using the Round-robin mechanism. However, they are now seeking a solution that allows for load balancing based on the number of connections, meaning the Load Balancer should route requests to the instance with the least number of connections.
Unfortunately, Azure Standard Load Balancer does not support this capability. However, Application Gateway does offer this functionality - Microsoft.Network/applicationGateways - Bicep, ARM template & Terraform AzAPI reference | Microsoft Learn<https://learn.microsoft.com/en-us/azure/templates/microsoft.network/applicationgateways?pivots=deplo...;
ASK:
1. Has anyone implemented this kind of approach and is it possible?
2. Can we do health probe with PostgreSQL to get no of connections metric?
1.
Kind Regards,
Ravi Varma Addala
Cloud Solution Architect
[email protected]<mailto:[email protected]>
[Microsoft]
Attachments:
[image/png] image001.png (2.6K, 3-image001.png)
download | view image
^ permalink raw reply [nested|flat] 2+ messages in thread
* Re: PGBouncer - Load balancing options
@ 2024-10-11 14:35 Christophe Pettus <[email protected]>
parent: Ravi Varma Addala <[email protected]>
0 siblings, 0 replies; 2+ messages in thread
From: Christophe Pettus @ 2024-10-11 14:35 UTC (permalink / raw)
To: Ravi Varma Addala <[email protected]>; +Cc: pgsql-general
Hello,
> On Oct 10, 2024, at 03:02, Ravi Varma Addala <[email protected]> wrote:
>
> Hello Team,I wanted to reach out to provide some insight into a request from my customer regarding their multiple PostgreSQL Flex instances with PGbouncer. Currently, they are utilizing an Azure Load Balancer which distributes connections using the Round-robin mechanism. However, they are now seeking a solution that allows for load balancing based on the number of connections, meaning the Load Balancer should route requests to the instance with the least number of connections.Unfortunately, Azure Standard Load Balancer does not support this capability. However, Application Gateway does offer this functionality - Microsoft.Network/applicationGateways - Bicep, ARM template & Terraform AzAPI reference | Microsoft Learn
> ASK:
>
> • Has anyone implemented this kind of approach and is it possible?
> • Can we do health probe with PostgreSQL to get no of connections metric?
Even though you mention pgbouncer in the subject:, your questions tare about proprietary products that your employer provides and supports. It's probably best to ask internally about their functionality; the community almost certainly does not have any better insight into them.
^ permalink raw reply [nested|flat] 2+ messages in thread
end of thread, other threads:[~2024-10-11 14:35 UTC | newest]
Thread overview: 2+ messages (download: mbox mbox.gz follow: Atom feed)
-- links below jump to the message on this page --
2024-10-10 10:02 PGBouncer - Load balancing options Ravi Varma Addala <[email protected]>
2024-10-11 14:35 ` Christophe Pettus <[email protected]>
This inbox is served by agora; see mirroring instructions
for how to clone and mirror all data and code used for this inbox