在数据库部署中经常会碰到一些瓶颈和失效，但是它们不应该导致整个部署被终止。这本实用书籍解释了复制，集群和监控特性，它们能够免除系统崩溃，无论你的MySQL运行在实际主机，虚拟机还是云端中。
本书由设计了众多工具的工程师编写而成，它揭开了很多MySQL高可靠性方面从未记录或者难以查找的知识，而这些知识对于使用数据库系统的公司来说必不可少。本次第二版修订讲述了对MySQL工具的大量修改，涵盖了到5.5为止的所有版本，以及一些5.6中的特性。
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
书单推荐
