Implementing Load Balance in MySQL | SQL courses

OBS: download the application please visit www.mrbool.com/player

Title: Implementing Load Balance in MySQL

 Duration:  19:11 min.

 Summary: In an environment that has many MySQL servers it is useful to divide the load between then, i.e. the connections and the queries issued to each server. However, to configure a load balance between a set of MySQL server on Linux is a task that not many DBAs know how to perform. This video class shows how to implement a load balance system to divide the connection load between two MySQL Server on Linux. The load balance described in this video class uses the open source tool called MySQL Proxy, which allow the DBA to create many types of load balancing configurations. The example showed in this video class is based in a load balance for a read-only environment, where the users send only SELECT statements to the database. Also, the load balance used in the example employ the Round Robin algorithm, which divide the connection load equally between the two MySQL server used. From what this video class show the DBA can create more complex load balancing environments and increase not only the availability of the database but also the overall performance of the system as a whole.

 Technologies : MySQL, MySQL Proxy, Linux.

 Examples constructed: How to create a load balance that automaticaly redirect the MySQL connections for two different MySQL servers.

 Keywords: SQL, MySQL, Load balance.