How we achieved MySQL HA using ProxySQL

ProxySQL is an open source MySQL load balancer and proxy solution which can run on almost any Linux distributions. It can be used to improve performance and availability of MySQL server. In this post, we���ll discuss a general overview of what ProxySQL is and examples of how it can be used to improve the performance and availability of your MySQL servers.

First, let���s see how ProxySQL can be useful. Let us assume you have an application which uses a single MySQL host with a database of five...