High Level Multi-Datacenter MySQL High Availability
This document represents current MySQL high availability best practices. These form the core of what Percona consultants and engineers will typically discuss with customers exploring this space. This discussion tends to bleed into disaster recovery scenarios, where appropriate, since such requirements are becoming more and more common. Therefore, this document will focus on a two datacenter application scenario but much is also applicable to single datacenter discussions.
We attempt to maintain an unbiased viewpoint where possible. However, our recommendations tend to focus on standard MySQL (InnoDB) with asynchronous replication, fully open source products, and what practices we generally see working best.
Our MySQL white papers are free. They are released under the Creative Commons Attribution-Noncommercial-No Derivative Works 3.0 license.