在數(shù)據(jù)庫部署中經(jīng)常會碰到一些瓶頸和失效,但是它們不應該導致整個部署被終止。這本實用書籍解釋了復制,集群和監(jiān)控特性,它們能夠免除系統(tǒng)崩潰,無論你的MySQL運行在實際主機,虛擬機還是云端中。
本書由設計了眾多工具的工程師編寫而成,它揭開了很多MySQL高可靠性方面從未記錄或者難以查找的知識,而這些知識對于使用數(shù)據(jù)庫系統(tǒng)的公司來說必不可少。本次第二版修訂講述了對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