public inbox for [email protected]  

help / color / mirror / Atom feed

From: Ravi Varma Addala <[email protected]>
To: [email protected] <[email protected]>
Subject: PGBouncer - Load balancing options
Date: Thu, 10 Oct 2024 10:02:15 +0000
Message-ID: <DU4PR83MB067824D472F35F55C12F8444AD782@DU4PR83MB0678.EURPRD83.prod.outlook.com> (raw)

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

view thread (2+ messages)  latest in thread

reply

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: [email protected]
  Cc: [email protected]
  Subject: Re: PGBouncer - Load balancing options
  In-Reply-To: <DU4PR83MB067824D472F35F55C12F8444AD782@DU4PR83MB0678.EURPRD83.prod.outlook.com>

* Save the following mbox file, import it into your mail client,
  and reply-to-all from there: mbox

This inbox is served by agora; see mirroring instructions
for how to clone and mirror all data and code used for this inbox