MySQL High Availability: Tools for Building Robust Data Centers at Dominant Systems Book Store

Server bottlenecks and failures are a fact of life in any database deployment, but they don't have to bring everything to a halt. MySQL has several features that can help you protect your system from outages, whether it's running on hardware, virtual machines, or in the cloud. MySQL High Availability explains how to use these replication, cluster, and monitoring features in a wide range of real-life situations.

Written by engineers who designed many of the tools covered inside, 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.

Explore the binary log, a file for replication that helps in disaster recovery and troubleshooting
Get techniques for improving response time and handling large data sets
Monitor database activity and performance, as well as major operating system parameters
Keep track of what masters and slaves are doing, and deal with failures and restarts, corruption, and other incidents
Automate key tasks with code from an open source library written by the authors
Learn techniques for using MySQL in virtualized environments, such as Amazon Web Services
Use MySQL Cluster to achieve high availability

"MySQL replication is widely deployed but has never been adequately explained. This book changes that." -- Mark Callaghan, MySQL contributor and leader of MySQL engineering efforts at a few of the world's largest Internet companies

Customer Reviews & Comments
I'm not a DBA, just a lowly web applications developer who happens to use MySQL as a backend most of the time. I've been developing with a lot of nagging questions in my brain: "How do you set up a master-slave replication?" "How do you roll back the database to a past point in time?" (The kinds of nagging questions that, as a Django or Rails developer, tend to be "someone else's problem.") This is a brilliant and powerful book. I picked this up in the bookstore and couldn't stop reading it. It's not the only resource available on MySQL replication, monitoring, and clustering, and another title, High Performance MySQL: Optimization, Backups, Replication, and More, has a few chapters that overlap with the topics in this book. That being said, I liked the tone and pace of this book, and it goes more in-depth than many other similar titles that cover the same material. It made concepts stick to my brain like no other MySQL book I've read so far. The authors make the material very accessible, even though it's not easy subject matter. For me, it shed a lot of light on some mysterious MySQL topics. It's not a beginner's book, but if you've been working comfortably with a MySQL shell at a startup for a while, are interested in digging deeper, and you're looking for an excuse to buy another computer book, this one is definitely worth it.

Back To Top