Book description
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.
Table of contents
- Foreword for the Second Edition
- Foreword for the First Edition
- Preface
-
I. High Availability and Scalability
- 1. Introduction
- 2. MySQL Replicant Library
- 3. MySQL Replication Fundamentals
-
4. The Binary Log
- Structure of the Binary Log
- Logging Statements
- Logging Transactions
- Row-Based Replication
- Binary Log Management
- The mysqlbinlog Utility
- Binary Log Options and Variables
- Conclusion
- 5. Replication for High Availability
- 6. MySQL Replication for Scale-Out
- 7. Data Sharding
-
8. Replication Deep Dive
- Replication Architecture Basics
- Running Replication over the Internet
- Finer-Grained Control Over Replication
- Options for Handling Broken Connections
- How the Slave Processes Events
- Semisynchronous Replication
- Global Transaction Identifiers
- Slave Safety and Recovery
- Multisource Replication
- Details of Row-Based Replication
- Conclusion
- 9. MySQL Cluster
-
II. Monitoring and Managing
-
10. Getting Started with Monitoring
- Ways of Monitoring
- Benefits of Monitoring
- System Components to Monitor
- Monitoring Solutions
- Linux and Unix Monitoring
- Mac OS X Monitoring
- Microsoft Windows Monitoring
- Monitoring as Preventive Maintenance
- Conclusion
- 11. Monitoring MySQL
- 12. Storage Engine Monitoring
- 13. Replication Monitoring
-
14. Replication Troubleshooting
- What Can Go Wrong
- Problems on the Master
-
Problems on the Slave
- Slave Server Crashed and Replication Won’t Start
- Slave Connection Times Out and Reconnects Frequently
- Query Results Are Different on the Slave than on the Master
- Slave Issues Errors when Attempting to Restart with SSL
- Memory Table Data Goes Missing
- Temporary Tables Are Missing After a Slave Crash
- Slave Is Slow and Is Not Synced with the Master
- Data Loss After a Slave Crash
- Table Corruption After a Crash
- Relay Log Is Corrupt on the Slave
- Multiple Errors During Slave Restart
- Consequences of a Failed Transaction on the Slave
- I/O Thread Problems
- SQL Thread Problems: Inconsistencies
- Different Errors on the Slave
- Advanced Replication Problems
- Tools for Troubleshooting Replication
- Best Practices
- Reporting Replication Bugs
- Conclusion
-
15. Protecting Your Investment
- What Is Information Assurance?
- Information Integrity, Disaster Recovery, and the Role of Backups
- Backup Tools and OS-Level Solutions
- Backup and MySQL Replication
- Automating Backups
- Conclusion
- 16. MySQL Enterprise Monitor
-
17. Managing MySQL Replication with MySQL
Utilities
- Common MySQL Replication Tasks
- MySQL Utilities
-
General Utilities
- Comparing Databases for Consistency: mysqldbcompare
- Copying Databases: mysqldbcopy
- Exporting Databases: mysqldbexport
- Importing Databases: mysqldbimport
- Discovering Differences: mysqldiff
- Showing Disk Usage: mysqldiskusage
- Checking Tables Indexes: mysqlindexcheck
- Searching Metadata: mysqlmetagrep
- Searching for Processes: mysqlprocgrep
- Cloning Servers: mysqlserverclone
- Showing Server Information: mysqlserverinfo
- Cloning Users: mysqluserclone
- Utilities Client: mysqluc
- Replication Utilities
- High Availability Utilities
- Creating Your Own Utilities
- Conclusion
-
10. Getting Started with Monitoring
-
A. Replication Tips and Tricks
- 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 (5.4.4 or Later)
- Ignoring Servers in Circular Replication (5.5 or Later)
- Time-Delayed Replication (5.6 or Later)
- Shell Commands for Common Tasks
- Multisource Replication in a Shell Script
- Stored Procedure to Change Master
- Implementing Multisource Replication in Pure SQL (5.6 or Later)
- B. A GTID Implementation
- Index
- Colophon
- Copyright
Product information
- Title: MySQL High Availability, 2nd Edition
- Author(s):
- Release date: April 2014
- Publisher(s): O'Reilly Media, Inc.
- ISBN: 9781449339586
You might also like
book
Hands-On Machine Learning with Scikit-Learn, Keras, and TensorFlow, 2nd Edition
Through a series of recent breakthroughs, deep learning has boosted the entire field of machine learning. …
book
Designing Data-Intensive Applications
Data is at the center of many challenges in system design today. Difficult issues need to …
book
Software Engineering at Google
Today, software engineers need to know not only how to program effectively but also how to …
book
High Performance MySQL, 2nd Edition
High Performance MySQL is the definitive guide to building fast, reliable systems with MySQL. Written by …