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 <[email protected]> wrote: > > > --On Thursday, March 11, 2021 10:56 AM +0530 chandan jain > <[email protected]> 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> >
