Foreword for the Second Edition
Foreword for the First Edition
Preface
PartⅠ.High Availability and Scalability
1.Introduction
What's This Replication Stuff, Anyway?
So, Backups Are Not Needed Then?
What's With All the Monitoring?
Is There Anything Else I Can Read?
Conclusion
2.MySQL Replicant Library
Basic Classes and Functions
Supporting Different Operating Systems
Servers
Server Roles
Conclusion
3.MySQL Replication Fundamentals
Basic Steps in Replication
Configuring the Master
Configuring the Slave
Connecting the Master and Slave
A Brieflntroduction to the Binary Log
What's Recorded in the Binary Log
Watching Replication in Action
The Binary Log's Structure and Content
Adding Slaves
Cloning the Master
Cloning a Slave
Scripting the Clone Operation
Performing Common Tasks with Replication
Reporting
Conclusion
4.The Binary Log
Structure of the Binary Log
Binlog Event Structure
Event Checksums
Logging Statements
Logging Data Manipulation Language Statements
Logging Data Definition Language Statements
Logging Queries
LOAD DATA INFILE Statements
Binary Log Filters
Triggers, Events, and Stored Routines
Stored Procedures
Stored Functions
Events
Special Constructions
Nontransactional Changes and Error Handling
Logging Transactions
Transaction Cache
Distributed Transaction Processing Using XA
Binary Log Group Commit
Row-Based Replication
Enabling Row-based Replication
Using Mixed Mode
Binary Log Management
The Binary Log and Crash Safety
Binlog File Rotation
Incidents
Purging the Binlog File
The mysqlbinlog Utility
Basic Usage
Interpreting Events
Binary Log Options and Variables
Options for Row-Based Replication
……
PartⅡ.Monitoring and Managing
A.Replication Tips and Tricks
B.A GTID Implementation
Index