Table of Contents(目录) 1. Executive Summary .............................................................................................. 3 2. Understanding the Causes and Effects of Downtime............................................ 3
2.1. Calculating the Cost & Impact of Downtime 4 3. Determining High Availability Requirements ........................................................ 5
3.1. Establishing Service Level Agreements (SLAs) 5
3.2. Mapping Application Needs to HA Architectures 6 4. Database Replication ............................................................................................ 7
4.1. Replication Modes and Data Consistency 7
4.2. Implementing Replication in MySQL. 8
4.3. MySQL 5.6 Replication Enhancements 9
4.4. Monitoring MySQL Replication ....... 10 5. Clustering & Virtualization................................................................................... 11
5.1. The Oracle VM Template for MySQL Enterprise Edition 13
5.2. Oracle Clusterware XAG Agent for MySQL 14
5.3. Oracle Linux and DRBD.................. 15
5.4. MySQL with Windows Server Failover Clustering 16
5.5. Solaris Cluster................................. 17 6. Shared-Nothing, Failover Clusters ...................................................................... 18
6.1. MySQL Cluster................................ 18
6.2. MySQL Fabric ................................. 20 7. Comparing MySQL HA Solutions .......................................................................... 22 8. Third-Party HA Technologies .............................................................................. 23 9. Operational Best Practices.................................................................................. 23 10. Conclusion ......................................................................................................... 25 11. Additional Resources......................................................................................... 25