MySQL High Availability, 2nd Edition
Tools for Building Robust Data Centers
Publisher: O'Reilly Media
Final Release Date: April 2014
Pages: 762

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
Product Details
About the Author
Colophon
Recommended for You
Customer Reviews

REVIEW SNAPSHOT®

by PowerReviews
oreillyMySQL High Availability, 2nd Edition
 
2.0

(based on 1 review)

Ratings Distribution

  • 5 Stars

     

    (0)

  • 4 Stars

     

    (0)

  • 3 Stars

     

    (0)

  • 2 Stars

     

    (1)

  • 1 Stars

     

    (0)

Reviewed by 1 customer

Displaying review 1

Back to top

(3 of 3 customers found this review helpful)

 
2.0

Nice on HA theory, but sucks at how-to

By Raul

from Queretaro, MX

About Me Sys Admin

Verified Reviewer

Pros

  • Easy to understand

Cons

  • Lacks examples
  • Not comprehensive enough

Best Uses

  • Expert
  • Python Programmer

Comments about oreilly MySQL High Availability, 2nd Edition:

The book is very complete and easy to comprehend on describing MySQL options for HA.

The problem is that it's very lacking on how to do the described theory, sometimes it mentions some Python scripts the author created so it automagically does whatever it needs instead of showing the reader step by step on how to do it.

There are times that there's not even a python script to do stuff, ie. on circular replication, when a node fails (figure 5-10), it explains that you change the topology until you bring back the server, there's no practical description (commands nor python script) on how to actually bring back the server into the ring without taking down the whole ring.

I'd recommend this book only so you learn what's available for HA on MySQL, but you have to go to google and search on how to actually implement what's explained in the book.

Displaying review 1

Back to top

 
Buy 2 Get 1 Free Free Shipping Guarantee
Buying Options
Immediate Access - Go Digital what's this?
Ebook: $42.99
Formats:  DAISY, ePub, Mobi, PDF
Print & Ebook: $54.99
Print: $49.99