MySQL High Availability: Tools for Building Robust Data Centers [NOOK Book]


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 ...

See more details below
MySQL High Availability: Tools for Building Robust Data Centers

Available on NOOK devices and apps  
  • NOOK Devices
  • Samsung Galaxy Tab 4 NOOK 7.0
  • Samsung Galaxy Tab 4 NOOK 10.1
  • NOOK HD Tablet
  • NOOK HD+ Tablet
  • NOOK eReaders
  • NOOK Color
  • NOOK Tablet
  • Tablet/Phone
  • NOOK for Windows 8 Tablet
  • NOOK for iOS
  • NOOK for Android
  • NOOK Kids for iPad
  • PC/Mac
  • NOOK for Windows 8
  • NOOK for PC
  • NOOK for Mac
  • NOOK for Web

Want a NOOK? Explore Now

NOOK Book (eBook)
$24.99 price
(Save 41%)$42.99 List Price


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
Read More Show Less

Product Details

  • ISBN-13: 9781449339562
  • Publisher: O'Reilly Media, Incorporated
  • Publication date: 4/10/2014
  • Sold by: Barnes & Noble
  • Format: eBook
  • Edition number: 2
  • Pages: 762
  • File size: 16 MB
  • Note: This product may take a few minutes to download.

Meet the Author

Dr. Charles A Bell is a Senior Software Engineer at Oracle. He iscurrently the lead developer for backup and a member of the MySQLBackup and Replication team. He lives in a small town in ruralVirginia with his loving wife. He received his Doctor of Philosophy inEngineering from Virginia Commonwealth University in 2005. Hisresearch interests include database systems, versioning systems,semantic web, and agile software development.

Dr. Mats Kindahl is a senior software developer working on the MySQLserver. He is the main architect and implementor of MySQL's row-basedreplication and is responsible for strategic development ofreplication, reengineering, and the plugin architecture. Beforestarting at MySQL, he did research in formal methods, programanalysis, and distributed systems, the area where he earned hisdoctoral degree in computer science. He has also spent many yearsdeveloping C/C++ compilers and knows more programming languages thanhe has fingers.

Dr. Lars Thalmann is the development manager for MySQL replication andbackup. He is responsible for the strategy and development of thesefeatures and leads the corresponding engineering teams. Thalmann hasworked with MySQL development since 2001, when he was a softwaredeveloper working on MySQL Cluster. More recently, he has driven thecreation and development of the MySQL backup feature, has guided theevolution of MySQL replication since 2004, and has been a key playerin the development of MySQL Cluster replication. Thalmann holds adoctorate in Computer Science from Uppsala University, Sweden.

Read More Show Less

Table of Contents

Organization of This Book;
Conventions Used in This Book;
Using Code Examples;
We’d Like to Hear from You;
Safari® Books Online;
Chapter 1: Introduction;
1.1 What’s This Replication Stuff Anyway?;
1.2 So, Backups Are Not Needed Then?;
1.3 What’s with All the Monitoring?;
1.4 Is There Anything Else I Can Read?;
1.5 Conclusion;
Chapter 2: MySQL Replication Fundamentals;
2.1 Basic Steps in Replication;
2.2 A Brief Introduction to the Binary Log;
2.3 Performing Common Tasks with Replication;
2.4 Conclusion;
Chapter 3: The Binary Log;
3.1 Structure of the Binary Log;
3.2 Logging Statements;
3.3 Logging Transactions;
3.4 Binary Log Management;
3.5 The mysqlbinlog Utility;
3.6 Binary Log Options and Variables;
3.7 Conclusion;
Chapter 4: Replication for High Availability;
4.1 Redundancy;
4.2 Planning;
4.3 Procedures;
4.4 Conclusion;
Chapter 5: MySQL Replication for Scale-Out;
5.1 Scaling Out Reads, Not Writes;
5.2 The Value of Asynchronous Replication;
5.3 Managing the Replication Topology;
5.4 Hierarchal Replication;
5.5 Specialized Slaves;
5.6 Data Sharding;
5.7 Managing Consistency of Data;
5.8 Consistency in a Hierarchal Deployment;
5.9 Conclusion;
Chapter 6: Advanced Replication;
6.1 Replication Architecture Basics;
6.2 Running Replication over the Internet;
6.3 Finer-Grained Control over Replication;
6.4 Options for Handling Broken Connections;
6.5 How the Slave Processes Events;
6.6 Slave Safety and Recovery;
6.7 Multisource Replication;
6.8 Row-Based Replication;
6.9 Conclusion;
Monitoring and Disaster Recovery;
Chapter 7: Getting Started with Monitoring;
7.1 Ways of Monitoring;
7.2 Benefits of Monitoring;
7.3 System Components to Monitor;
7.4 Monitoring Solutions;
7.5 Linux and Unix Monitoring;
7.6 Mac OS X Monitoring;
7.7 Microsoft Windows Monitoring;
7.8 Monitoring as Preventive Maintenance;
7.9 Conclusion;
Chapter 8: Monitoring MySQL;
8.1 What Is Performance?;
8.2 MySQL Server Monitoring;
8.3 Database Performance;
8.4 Best Practices for Improving Performance;
8.5 Conclusion;
Chapter 9: Storage Engine Monitoring;
9.1 MyISAM;
9.2 InnoDB;
9.3 Conclusion;
Chapter 10: Replication Monitoring;
10.1 Getting Started;
10.2 Server Setup;
10.3 Inclusive and Exclusive Replication;
10.4 Replication Threads;
10.5 Monitoring the Master;
10.6 Monitoring Slaves;
10.7 Replication Monitoring with MySQL Administrator;
10.8 Other Items to Consider;
10.9 Conclusion;
Chapter 11: Replication Troubleshooting;
11.1 What Can Go Wrong;
11.2 Tools for Troubleshooting Replication;
11.3 Best Practices;
11.4 Reporting Replication Bugs;
11.5 Conclusion;
Chapter 12: Protecting Your Investment;
12.1 What Is Information Assurance?;
12.2 Information Integrity, Disaster Recovery, and the Role of Backups;
12.3 Backup Utilities and OS-Level Solutions;
12.4 Backup and MySQL Replication;
12.5 Automating Backups;
12.6 Conclusion;
Chapter 13: MySQL Enterprise;
13.1 Getting Started with MySQL Enterprise;
13.2 MySQL Enterprise Components;
13.3 Using MySQL Enterprise;
13.4 Conclusion;
High Availability Environments;
Chapter 14: Cloud Computing Solutions;
14.1 What Is Cloud Computing?;
14.2 Cloud Computing Use Cases;
14.3 Cloud Computing Benefits;
14.4 Cloud Computing Vendors;
14.5 AWS;
14.6 MySQL in the Cloud;
14.7 Open Source Cloud Computing;
14.8 Conclusion;
Chapter 15: MySQL Cluster;
15.1 What Is MySQL Cluster?;
15.2 Architecture of MySQL Cluster;
15.3 Example Configuration;
15.4 Achieving High Availability;
15.5 Achieving High Performance;
15.6 Conclusion;
Replication Tips and Tricks;
My Slave Stopped. Now What?;
Examining the Binary Log with Verbose;
Using Replication to Repopulate a Table;
Using MySQL Proxy to Perform Multimaster Replication;
Using a Default Storage Engine;
MySQL Cluster Multisource Replication;
Multichannel Replication with Failover;
Using the Current Database to Filter;
More Columns on Slave Than Master;
Fewer Columns on Slave Than Master;
Replicate Selected Rows to Slave;
Replication Heartbeat;
Ignoring Servers in Circular Replication;
Feature Preview: Time-Delayed Replication;
Feature Preview: Scriptable Replication;
Feature Preview: The Oracle Algorithm;

Read More Show Less

Customer Reviews

Be the first to write a review
( 0 )
Rating Distribution

5 Star


4 Star


3 Star


2 Star


1 Star


Your Rating:

Your Name: Create a Pen Name or

Barnes & Review Rules

Our reader reviews allow you to share your comments on titles you liked, or didn't, with others. By submitting an online review, you are representing to Barnes & that all information contained in your review is original and accurate in all respects, and that the submission of such content by you and the posting of such content by Barnes & does not and will not violate the rights of any third party. Please follow the rules below to help ensure that your review can be posted.

Reviews by Our Customers Under the Age of 13

We highly value and respect everyone's opinion concerning the titles we offer. However, we cannot allow persons under the age of 13 to have accounts at or to post customer reviews. Please see our Terms of Use for more details.

What to exclude from your review:

Please do not write about reviews, commentary, or information posted on the product page. If you see any errors in the information on the product page, please send us an email.

Reviews should not contain any of the following:

  • - HTML tags, profanity, obscenities, vulgarities, or comments that defame anyone
  • - Time-sensitive information such as tour dates, signings, lectures, etc.
  • - Single-word reviews. Other people will read your review to discover why you liked or didn't like the title. Be descriptive.
  • - Comments focusing on the author or that may ruin the ending for others
  • - Phone numbers, addresses, URLs
  • - Pricing and availability information or alternative ordering information
  • - Advertisements or commercial solicitation


  • - By submitting a review, you grant to Barnes & and its sublicensees the royalty-free, perpetual, irrevocable right and license to use the review in accordance with the Barnes & Terms of Use.
  • - Barnes & reserves the right not to post any review -- particularly those that do not follow the terms and conditions of these Rules. Barnes & also reserves the right to remove any review at any time without notice.
  • - See Terms of Use for other conditions and disclaimers.
Search for Products You'd Like to Recommend

Recommend other products that relate to your review. Just search for them below and share!

Create a Pen Name

Your Pen Name is your unique identity on It will appear on the reviews you write and other website activities. Your Pen Name cannot be edited, changed or deleted once submitted.

Your Pen Name can be any combination of alphanumeric characters (plus - and _), and must be at least two characters long.

Continue Anonymously

    If you find inappropriate content, please report it to Barnes & Noble
    Why is this product inappropriate?
    Comments (optional)