October 31, 2014 By Severalnines
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
- mysqlproxy by Oracle (alpha)
Note that there are other options out there, e.g. MaxScale from the MariaDB team, that we plan to cover in a future post.