MySQL-Replication could be a kind of load balancing for querieng applications or active failover/backup node which has the same data.

Also for common heavy loaded scenarios, where the primary write-queries are going to the master node and all read-queries are running against the slave node.

[Read more…]