]]> ]]>

High Level Multi-Datacenter MySQL High Availability

You are here

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.

September, 2013


Authors

Jay Janssen

Managing Consultant

Jay comes 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.

Contact Us 24 Hours A Day
Support Contact us 24×7
Emergency? Contact us for help now!
Sales North America (888) 316-9775 or
(208) 473-2904
Sales
Europe
+44-208-133-0309 (UK)
0-800-051-8984 (UK Toll Free)
0-800-181-0665 (GER Toll Free)
More Numbers
Training (855) 55TRAIN or
(925) 271-5054

 

Share This
]]>