How To Use ProxySQL as a Load Balancer for MySQL on Ubuntu 16.04
ProxySQL is an open-source MySQL proxy server which can improve performance by distributing traffic among a pool of multiple database servers and also improve availability by automatically failing over to a standby if a database server fails. In this guide, you will set up ProxySQL as a load balancer for multiple MySQL servers with automatic failover.