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