Load-Balancing

Load balancing is one of the essential concepts for building architectures that can handle heavy traffic and are resilient to failures. It is a set of techniques for distributing workload across different computers in a group. The use cases for load balancing are increasingly numerous, especially with the advent of cloud computing and decentralized data architectures. These techniques are used in: supercomputers, high-traffic HTTP services, databases requiring permanent access, big data, neural network training, etc. ...

This article covers the procedure for setting up a MySQL Master-Master (and Master-Slave) server with a load balancing system using the round robin algorithm (via HAProxy). In our example, we will have three servers: one managing load balancing (named SRV-LBSQL with IP address 10.0.0.100) and two MySQL servers connected to each other (named SRV-MYSQL01 and SRV-MYSQL02 with IP addresses 10.0.0.1 and 10.0.0.2 respectively). Each MySQL server will process SQL queries in turn. The database servers will replicate data between each other using a dual Master-Slave relationship. ...