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.
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
Thanks for pointing out to doc will these steps also work for XtraDB 8.0.28 cluster with proxysqlV2 installed using proxysql-admin.
Yes, it should work for those versions as well