proxySql v2 setup with 2 nodes

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