Hi ,
We are setting up a Percona XtraDB Cluster with three nodes, each running on an AWS EC2 instance. To handle query routing, we plan to use ProxySQL, also deployed on an EC2 instance.
However, in this setup, ProxySQL becomes a single point of failure. To ensure high availability, we considered deploying Keepalived on two ProxySQL nodes. But since Keepalived relies on VRRP (multicast), which isn’t supported in AWS, we’re unsure if this is a viable solution.
Could you advise whether Keepalived can be used in this setup? If not, what would be the best approach to achieve high availability for ProxySQL in an AWS environment?
Looking forward to your recommendations.