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