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