How to configure MySQL master/slave replication with MHA automatic failover

This post is the first one of a package called "complete infrastructure". Following all posts of this package, you will be able to setup, from scratch, a complete "high available" web infrastructure with : 2 load balancer servers 2 web servers (Drupal in my case) with real-time files synchronization 2 database servers sharing a VIP in a master/slave replication, with MHA automatic failover To find all posts of this package, just click the tag "complete infrastructure" at the end of the page. Overview The purpose of this installation is to have two database servers, in a master/slave replication configuration. All requests from your web servers are always forwarded to the master server, which is replicated in real-time. Most of the time, the slave server will just act as a simple backup, and will not be used by the website. ...