Achieving High Availability with MySQL is a tricky thing; there are almost as many recipes as there are cooks out there. This talk will go through the most common solutions for achieving HA with MySQL and list the pros and cons for each of them. The solutions include standard replication, MariaDB multi-source replication, MHA, Continuent Tungsten, Galera, shared-disk based solutions and MySQL Cluster. We will also look how each of these solutions work for a cloud environment in particular and what ready-made solutions there are out there. The need for load-balancing and automatic failover along with potential tools will also be discussed.
Survey this Session