Hi Team,
I have setup 3 node XtraDB 8.0.28 cluster (default ports are changed) and want to setup 2 node proxySQL setup which should be having a virtual IP/load balancer to which application can connect and if even one proxysql node is down application can connect route through another proxysql node using same virtual IP/load balance.
Request to please guide or point to correct documentation for this scenario.
Thanks
Adi
Hello, this topology is often implemented with keepalived. Check out Setup ProxySQL for High Availability (not a Single Point of Failure) - Percona Database Performance Blog
Hi @Ivan_Groenewold,
Thanks for pointing out to doc will these steps also work for XtraDB 8.0.28 cluster with proxysqlV2 installed using proxysql-admin.
Thanks
Aditya
Yes, it should work for those versions as well