Speaker Deck

[php[tek] 2013] MySQL High Availability, Disaster Recovery and Load Balancing

by Davey Shafik

Published May 17, 2013 in Programming

Using Oracle MySQL Server and Percona XtraDB Cluster we will take a look at several possible replication configurations for MySQL high-availability, disaster recovery and load-balancing.

After comparing them for administration ease, scalability of reads and writes, robustness of the system for errors and time for data recovery as well as looking at how they impact your code-layer we will discuss the ins-and-outs of each setup, looking at the pros and cons, and what trade-offs you will need to make depending on your needs.

Note: This talk was co-presented with Ligaya Turmelle