There are several ways to deploy ProxySQL between your applications and the database servers. A common approach is to have a floating virtual IP (VIP) managed by keepalived as the application endpoint. The proxies have to be strategically provisioned to improve the resiliency of the solution (different hardware, network segments, etc,). When we consider cloud [&]

https://www.percona.com/blog/2021/01/28/load-balancing-proxysql-in-aws/