When running a MariaDB Cluster or Percona XtraDB Cluster, it is common to use a load balancer to distribute client requests across multiple database nodes. Load balancing SQL requests aims to optimize the usage of the database nodes, maximize throughput, minimize response times and avoid overload of the Galera nodes.
In this blog post, we’ll take a look at four different open source load balancers, and do a quick benchmark to compare performance:
- HAproxy by HAproxy Technologies
- IPVS by Linux Virtual Server Project
- Galera Load Balancer by Codership