Quanah, I am already having this setup, but business wants to horizontal scale the setup. 

As far as I understood, horizontal scaling is for reads replicas only, as writes would go to single node with sticky session. 

Your earlier solution was perfect for my use case,  its just that I am confused at how to  bifurcate read and write connections. Shall I use two separate connection string from single application for read and write traffic to same set of servers with different pools. 

Regards 
Chandan

On Thu, Mar 11, 2021, 21:30 Quanah Gibson-Mount <quanah@symas.com> wrote:


--On Thursday, March 11, 2021 10:56 AM +0530 chandan jain
<chandandevops@gmail.com> wrote:

>
>
> OK, but if I put a single connection string, how below setup suggested by
> quanah will work.
>
>
> I have a single application which read as well as write to ldap.

If you have only a single application using LDAP, just set up two nodes
with sticky failover and a single pool, since nothing else is using LDAP.
As has been said repeatedly, in general, an application that does writes
should use the same connection for reads.

--Quanah

--

Quanah Gibson-Mount
Product Architect
Symas Corporation
Packaged, certified, and supported LDAP solutions powered by OpenLDAP:
<http://www.symas.com>