II. Monitoring and Managing
by Lars Thalmann, Mats Kindahl, Charles Bell
MySQL High Availability, 2nd Edition
- 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
Part II. Monitoring and Managing
Now that you have a sophisticated, multiserver system that hopefully meets your site’s needs, you must keep on top of it. This part of the book explains monitoring, with some topics in performance, and covers backups and other aspects of handling the inevitable failures that sometimes occur.
-
No Comment
..................Content has been hidden....................
You can't read the all page of ebook, please click here login for view all page.