MySQL High Availability
Tools for Building Robust Data Centers
Publisher: O'Reilly Media
Released: June 2010
Pages: 624

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

REVIEW SNAPSHOT®

by PowerReviews
O'Reilly MediaMySQL High Availability
 
4.0

(based on 1 review)

Ratings Distribution

  • 5 Stars

     

    (0)

  • 4 Stars

     

    (1)

  • 3 Stars

     

    (0)

  • 2 Stars

     

    (0)

  • 1 Stars

     

    (0)

Reviewed by 1 customer

Displaying review 1

Back to top

(5 of 5 customers found this review helpful)

 
4.0

Good coverage of MySQL and replication

By sjmudd

from Madrid, Spain

About Me Database Administrator, Sys Admin

Verified Reviewer

Pros

  • Accurate
  • Concise
  • Easy to understand
  • Helpful examples
  • Well-written

Cons

    Best Uses

    • Expert
    • Intermediate

    Comments about O'Reilly Media MySQL High Availability:

    I work in quite a large site and found the book full of useful tips of things to do, and ways to do them in order to achieve the title's goal of MySQL High Availability.

    To be honest the book should really be called "MySQL and replication in large environments" but that does not sound so exciting.

    There's less information on performance tuning and more on working with a large replicated setup. That's fine: it fits my needs and will certainly fit others too.

    It's also interesting to note how the authors solve many problems by writing wrapper routines around MySQL and the required replication procedures. That's done in python which is fine but most of the routines I have written with shell scripts or perl. Again if you are looking at the technique the implementation language does not really matter. Oracle should really take note and come up with some standard routines to make more of these tasks doable _the same way_ by everyone. That makes all DBA or sysadmins lives easier.

    So the book was full of good tips and procedures and is certainly worth the read.

    Displaying review 1

    Back to top

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