高可用性MySQL

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

在数据库部署中经常会碰到一些瓶颈和失败，但是它们不应该导致整个部署终止。这本实用书籍解释了复制、群和监控特性，它们能够帮助你的MySQL系统避免中断，无论它是运行在实际主机、虚拟机还是云端中。
　　《高可用性MySQL（第2版 影印版）》由设计了众多工具的工程师编写而成，它揭开了很多关于MySQL可靠性方面从未记录或者难以查找的知识，而这些知识对于使用此数据库系统的公司来说必不可少。本次第二版描述了对MysoL工具的大量修改，涵盖了到55版为止的所有版本以及一些5.6版中的特性。