MySQL High Availability, 2nd Edition

Server bottlenecks and failures are a fact of life in any database deployment, but they don’t have to bring everything to a halt. This practical book explains replication, cluster, and monitoring features that can help protect your MySQL system from outages, whether it’s running on hardware, virtual machines, or in the cloud.

Written by engineers who designed many of the tools covered, this book reveals undocumented or hard-to-find aspects of MySQL reliability and high availability—knowledge that’s essential for any organization using this database system. This second edition describes extensive changes to MySQL tools. Versions up to 5.5 are covered, along with several 5.6 features.

• Learn replication fundamentals, including use of the binary log and MySQL Replicant Library
• Handle failing components through redundancy
• Scale out to manage read-load increases, and use data sharding to handle large databases and write-load increases
• Store and replicate data on individual nodes with MySQL Cluster
• Monitor database activity and performance, and major operating system parameters
• Keep track of masters and slaves, and deal with failures and restarts, corruption, and other incidents
• Examine tools including MySQL Enterprise Monitor, MySQL Utilities, and GTIDs

Table of Contents

Part I. High Availability and Scalability
Chapter 1. Introduction
Chapter 2. MySQL Replicant Library
Chapter 3. MySQL Replication Fundamentals
Chapter 4. The Binary Log
Chapter 5. Replication for High Availability
Chapter 6. MySQL Replication for Scale-Out
Chapter 7. Data Sharding
Chapter 8. Replication Deep Dive
Chapter 9. MySQL Cluster

Part II. Monitoring and Managing
Chapter 10. Getting Started with Monitoring
Chapter 11. Monitoring MySQL
Chapter 12. Storage Engine Monitoring
Chapter 13. Replication Monitoring
Chapter 14. Replication Troubleshooting
Chapter 15. Protecting Your Investment
Chapter 16. MySQL Enterprise Monitor
Chapter 17. Managing MySQL Replication with MySQL Utilities

Appendix A. Replication Tips and Tricks
Appendix B. A GTID Implementation