书籍详情
高可用性MySQL(影印版 第二版)
作者:Charles,Bell,,Mats,Kindahl,,Lars,Thalmann
出版社:东南大学出版社
出版时间:2015-02-01
ISBN:9787564153861
定价:¥98.00
购买这本书可以去
内容简介
在数据库部署中经常会碰到一些瓶颈和失败,但是它们不应该导致整个部署终止。这本实用书籍解释了复制、群和监控特性,它们能够帮助你的MySQL系统避免中断,无论它是运行在实际主机、虚拟机还是云端中。《高可用性MySQL(第2版 影印版)》由设计了众多工具的工程师编写而成,它揭开了很多关于MySQL可靠性方面从未记录或者难以查找的知识,而这些知识对于使用此数据库系统的公司来说必不可少。本次第二版描述了对MysoL工具的大量修改,涵盖了到55版为止的所有版本以及一些5.6版中的特性。
作者简介
作者:(美国)贝尔(Charles A.Bell) (美国)肯德尔(Mats Kindahl) (瑞典)塞尔曼(Lars Thalmann) 贝尔(Charles A.Bell)博士,是Oracle公司的高级软件工程师,他目前是备份方面的开发主管,也是MySQL备份与复制团队中的一员。 肯德尔(Mats Kindahl)博士,是Oracle公司MySQL团队的资深高级软件开发师。他是MySQL行级复制和其他一些复制特性的主要架构师和实现者。目前他是搭建MySQLFabric的MySQL高可用性团队的架构师和项目主管。 肯德尔(Lars Thalmann)博士,是MySQL备份与复制团队的开发经理。他曾经促使了MySQL备份特性的出现并且指导了MySQL复制的演进,是MySQLCluster复制的主要参与者。
目录
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
猜您喜欢