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. 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
Publisher resources
Table of contents
- MySQL High Availability
- Foreword
- Preface
-
I. Replication
- 1. Introduction
-
2. MySQL Replication Fundamentals
- Basic Steps in Replication
-
A Brief Introduction to the Binary Log
- What’s Recorded in the Binary Log
- Watching Replication in Action
- The Binary Log’s Structure and Content
- Python Support for Managing Replication
- Basic Classes and Functions
- Operating System
- Server Class
- Server Roles
- Creating New Slaves
- Cloning the Master
- Cloning the Slave
- Scripting the Clone Operation
- Performing Common Tasks with Replication
- Conclusion
-
3. The Binary Log
- Structure of the Binary Log
- Logging Statements
- Logging Transactions
- Binary Log Management
- The mysqlbinlog Utility
- Binary Log Options and Variables
- Conclusion
- 4. Replication for High Availability
- 5. MySQL Replication for Scale-Out
- 6. Advanced Replication
-
II. Monitoring and Disaster Recovery
-
7. 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
- 8. Monitoring MySQL
- 9. Storage Engine Monitoring
- 10. Replication Monitoring
-
11. 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
- Advanced Replication Problems
- Tools for Troubleshooting Replication
- Best Practices
- Reporting Replication Bugs
- Conclusion
-
What Can Go Wrong
-
12. Protecting Your Investment
- What Is Information Assurance?
- Information Integrity, Disaster Recovery, and the Role of Backups
- Backup Utilities and OS-Level Solutions
- Backup and MySQL Replication
- Automating Backups
- Conclusion
- 13. MySQL Enterprise
-
7. Getting Started with Monitoring
-
III. High Availability Environments
-
14. Cloud Computing Solutions
- What Is Cloud Computing?
- Cloud Computing Use Cases
- Cloud Computing Benefits
- Cloud Computing Vendors
-
AWS
- A Brief Overview of Technologies
- How Does It All Work?
- Amazon Cloud Tools
-
Getting Started
- Getting an account
- Getting your credentials
- Amazon login and password
- Access key ID and secret access key
- SOAP and EC2 command-line tools
- Credentials for working with CloudFront
- Credentials for working with instances
- Other credentials
- Running an instance with the AMS Management Console
- Launching an instance with the EC2 API tools
- Working with Disk
- Where to Go from Here
- MySQL in the Cloud
- Open Source Cloud Computing
- Conclusion
- 15. MySQL Cluster
-
14. Cloud Computing Solutions
-
A. 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
- Index
- About the Authors
- Colophon
- Copyright
Product information
- Title: MySQL High Availability
- Author(s):
- Release date: July 2010
- Publisher(s): O'Reilly Media, Inc.
- ISBN: 9780596807306
You might also like
book
Designing Data-Intensive Applications
Data is at the center of many challenges in system design today. Difficult issues need to …
book
Generative Deep Learning, 2nd Edition
Generative AI is the hottest topic in tech. This practical book teaches machine learning engineers and …
book
Flow Architectures
Software development today is embracing events and streaming data, which optimizes not only how technology interacts …
book
Spring Boot: Up and Running
With over 75 million downloads per month, Spring Boot is the most widely used Java framework …