Charles Bell,博士是一位专注于复制和备份方面的资历开发者。他的兴趣范围包括数据库理论、软件工程和敏捷开发实践。 Mats Kindahl,博士是MySQL复制与备份团队的复制功能主要开发者。 Lars Thalmann,博土是MySQL复制与备份团队的开发经理和技术,他设计了很多复制备份方面的功能特性。
目录
Foreword Preface Part 1. Replication 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 Replication Fundamentals Basic Steps in Replication Configuring the Master Configuring the Slave Connecting the Master and Slave 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 Reporting Conclusion 3. The Binary Log Structure of the Binary Log Binlog Event Structure 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 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 Conclusion 4. Replication for High Availability Redundancy Planning Slave Failures Master Failures Relay Failures Disaster Recovery Procedures Hot Standby ……