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
1 Like
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
1 Like
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
1 Like
Yes, it should work for those versions as well
1 Like