Content-Type: text/plain;
	charset=utf-8
Mime-Version: 1.0 (Mac OS X Mail 16.0 \(3776.700.51\))
Subject: Re: PGBouncer - Load balancing options
From: Christophe Pettus <xof@thebuild.com>
In-Reply-To: <DU4PR83MB067824D472F35F55C12F8444AD782@DU4PR83MB0678.EURPRD83.prod.outlook.com>
Date: Fri, 11 Oct 2024 07:35:06 -0700
Cc: "pgsql-general@postgresql.org" <pgsql-general@postgresql.org>
Content-Transfer-Encoding: quoted-printable
Message-Id: <BEEBA495-B15B-4509-9FC4-B65003BA826A@thebuild.com>
References: <DU4PR83MB067824D472F35F55C12F8444AD782@DU4PR83MB0678.EURPRD83.prod.outlook.com>
To: Ravi Varma Addala <advarma@microsoft.com>
Archived-At: <https://www.postgresql.org/message-id/BEEBA495-B15B-4509-9FC4-B65003BA826A%40thebuild.com>
Precedence: bulk

Hello,

> On Oct 10, 2024, at 03:02, Ravi Varma Addala <advarma@microsoft.com> =
wrote:
>=20
> 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:
>=20
>     =E2=80=A2 Has anyone implemented this kind of approach and is it =
possible?
>     =E2=80=A2 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.=