高可用性MySQL

內(nèi)容概要

　　服務(wù)器瓶頸和故障是任何數(shù)據(jù)庫(kù)都無法回避的現(xiàn)實(shí)問題，但它們不至于導(dǎo)致整體宕機(jī)。mysql具有多種特性，可以幫助你保護(hù)系統(tǒng)免于失效，無論它運(yùn)行在硬件、虛擬機(jī)上，還是云中?！陡呖捎眯詍ysql》將詳細(xì)解釋如何在各種各樣的現(xiàn)實(shí)場(chǎng)景中運(yùn)用這些復(fù)制、集群和監(jiān)控功能特性。
　　《高可用性mysql(英文影印版)》由設(shè)計(jì)相關(guān)工具的工程師編寫，披露了很多關(guān)于mysql可靠性和高可用性方面未寫入文檔或者很難找到的內(nèi)容——對(duì)于任何使用該數(shù)據(jù)庫(kù)系統(tǒng)的組織都是很重要的知識(shí)。
　　 ·探索二進(jìn)制日志，這是用于實(shí)現(xiàn)復(fù)制功能的文件，有助于災(zāi)難恢復(fù)和故障診斷
　　 ·獲取改善響應(yīng)時(shí)間和處理大規(guī)模數(shù)據(jù)集的技巧
　　 ·學(xué)習(xí)如何通過復(fù)制來擴(kuò)展服務(wù)器
　　 ·監(jiān)控?cái)?shù)據(jù)庫(kù)活動(dòng)和性能，以及主要的操作系統(tǒng)參數(shù)
　　 ·追蹤主從數(shù)據(jù)庫(kù)動(dòng)態(tài)，并且處理故障、重啟、數(shù)據(jù)損壞和其他事件
　　 ·使用本書作者編寫的開源庫(kù)代碼自動(dòng)化關(guān)鍵任務(wù)
　　 ·學(xué)習(xí)在虛擬化環(huán)境中使用mysql的技巧，比如amazon web services
　　 ?利用mysql cluster實(shí)現(xiàn)高可用性

作者簡(jiǎn)介

　　Charles
Bell博士是一位專注于復(fù)制和備份方面的資深開發(fā)者。他的興趣范圍包括數(shù)據(jù)庫(kù)理論、軟件工程和敏捷開發(fā)實(shí)踐。
　　Mats Kindahl博士是MySQL復(fù)制與備份團(tuán)隊(duì)的復(fù)制功能主要開發(fā)者。
　　Lars Thalmann博土是MySQL復(fù)制與備份團(tuán)隊(duì)的開發(fā)經(jīng)理和技術(shù)領(lǐng)導(dǎo)者，他設(shè)計(jì)了很多復(fù)制備份方面的功能特性。

書籍目錄

foreword
preface
part 1. replication
　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 replication fundamentals
　　basic steps in replication
　　　configuring the master
　　　configuring the slave
　　　connecting the master and slave
　　a brief introduction to the binary log
　　　what's recorded in the binary log
　　　watching replication in action
　　　the binary log's structure and content
　　　python support for managing replication
　　　basic classes and functions
　　　operating system
　　　server class
　　　server roles
　　　creating new slaves
　　　cloning the master
　　　cloning the slave
　　　scripting the clone operation
　　performing common tasks with replication
　　　reporting
　　conclusion
　3. the binary log
　　structure of the binary log
　　　binlog event structure
　　logging statements
　　　logging data manipulation language statements
　　　logging data definition language statements
　　　logging queries
　　　load data infile statements
　　　binary log filters
　　……
part 2. monitoring and disaster recovery
part 3. high availability environments
appendix: replication tips and tricks
index

章節(jié)摘錄

版權(quán)頁(yè)：插圖：Joel jumped as a sharp rap on his door announced his boss's unapologetic interruption.Before Joel could say "Come in," the boss stepped into his doorway and said, "Joel,we're getting complaints that our response time is getting slow. See what you can doto speed things up. The administrator told me there are too many read operations fromthe applications. See what you can do to offload some of that."Before Joel could respond, Mr. Summerson was out the door and on his way elsewhere."I suppose he means we need a bigger server," Joel thought.As if he had read Joel's mind, Mr. Summerson stuck his head back in the doorway andsaid, "Oh, and by the way, the startup we bought all the equipment from had a bunchof servers we haven't found any use for yet; can you take a look at those and see whatyou can do with them？ OK, Joel？" Then he was gone again."I wonder if I'll ever get used to this," Joel thought as he pulled his favorite MySQLbook off the shelf and glanced at the table of contents. He found the chapter on repli-cation and decided that might fit the bill.

媒體關(guān)注與評(píng)論

“MySQL復(fù)制雖然已廣泛部署，但是從未被充分闡釋過。本書改變了這一切?！薄　　狹ark Callaghan MySQL貢獻(xiàn)者，擔(dān)任過多家世界上最大型互聯(lián)網(wǎng)公司的MySQL工程團(tuán)隊(duì)領(lǐng)導(dǎo)

圖書封面

圖書標(biāo)簽Tags

無

評(píng)論、評(píng)分、閱讀與下載

---

    高可用性MySQL PDF格式下載

---