Buy Percona ServicesBuy Now!
  September, 2013
   Jay Janssen

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.

Jay Janssen
Director of Service Operations
Jay came to Percona in 2011 after working 7 years for Yahoo working in a variety of fields including High Availability architectures, MySQL training, tool building, global server load balancing, multi-datacenter environments, operationalization, and monitoring. Jay holds a B.S. of Computer Science from Rochester Institute of Technology. He and his wife live with their four children in upstate New York.

Our MySQL white papers are free. They are released under the Creative Commons Attribution-Noncommercial-No Derivative Works 3.0 license.

Visit Percona Store

General Inquiries

For general inquiries about our open source software and database management tools, please send us your question and someone will contact you.