内容简介
在数据库部署中经常会碰到一些瓶颈和失败，但是它们不应该导致整个部署终止。这本实用书籍解释了复制、群和监控特性，它们能够帮助你的MySQL系统避免中断，无论它是运行在实际主机、虚拟机还是云端中。
《高可用性MySQL（第2版影印版）》由设计了众多工具的工程师编写而成，它揭开了很多关于MySQL可靠性方面从未记录或者难以查找的知识，而这些知识对于使用此数据库系统的公司来说必不可少。本次第二版描述了对MysoL工具的大量修改，涵盖了到55版为止的所有版本以及一些5.6版中的特性。目录
ForewordfortheSecondEdition
ForewordfortheFirstEdition
Preface
PartⅠ.HighAvailabilityandScalability
1.Introduction
What'sThisReplicationStuff,Anyway?
So,BackupsAreNotNeededThen?
What'sWithAlltheMonitoring?
IsThereAnythingElseICanRead?
Conclusion
2.MySQLReplicantLibrary
BasicClassesandFunctions
SupportingDifferentOperatingSystems
Servers
ServerRoles
Conclusion
3.MySQLReplicationFundamentals
BasicStepsinReplication
ConfiguringtheMaster
ConfiguringtheSlave
ConnectingtheMasterandSlave
ABrieflntroductiontotheBinaryLog
What'sRecordedintheBinaryLog
WatchingReplicationinAction
TheBinaryLog'sStructureandContent
AddingSlaves
CloningtheMaster
CloningaSlave
ScriptingtheCloneOperation
PerformingCommonTaskswithReplication
Reporting
Conclusion
4.TheBinaryLog
StructureoftheBinaryLog
BinlogEventStructure
EventChecksums
LoggingStatements
LoggingDataManipulationLanguageStatements
LoggingDataDefinitionLanguageStatements
LoggingQueries
LOADDATAINFILEStatements
BinaryLogFilters
Triggers,Events,andStoredRoutines
StoredProcedures
StoredFunctions
Events
SpecialConstructions
NontransactionalChangesandErrorHandling
LoggingTransactions
TransactionCache
DistributedTransactionProcessingUsingXA
BinaryLogGroupCommit
Row-BasedReplication
EnablingRow-basedReplication
UsingMixedMode
BinaryLogManagement
TheBinaryLogandCrashSafety
BinlogFileRotation
Incidents
PurgingtheBinlogFile
ThemysqlbinlogUtility
BasicUsage
InterpretingEvents
BinaryLogOptionsandVariables
OptionsforRow-BasedReplication
……
PartⅡ.MonitoringandManaging
A.ReplicationTipsandTricks
B.AGTIDImplementation
Index
