MySQL High Availability: Tools for Building Robust Data Centers, 2/e (Paperback)

Charles Bell, Mats Kindahl, Lars Thalmann

買這商品的人也買了...

商品描述

Server bottlenecks and failures are a fact of life in any database deployment, but they don’t have to bring everything to a halt. This practical book explains replication, cluster, and monitoring features that can help protect your MySQL system from outages, whether it’s running on hardware, virtual machines, or in the cloud.

Written by engineers who designed many of the tools covered, this book reveals undocumented or hard-to-find aspects of MySQL reliability and high availability—knowledge that’s essential for any organization using this database system. This second edition describes extensive changes to MySQL tools. Versions up to 5.5 are covered, along with several 5.6 features.

  • Learn replication fundamentals, including use of the binary log and MySQL Replicant Library
  • Handle failing components through redundancy
  • Scale out to manage read-load increases, and use data sharding to handle large databases and write-load increases
  • Store and replicate data on individual nodes with MySQL Cluster
  • Monitor database activity and performance, and major operating system parameters
  • Keep track of masters and slaves, and deal with failures and restarts, corruption, and other incidents
  • Examine tools including MySQL Enterprise Monitor, MySQL Utilities, and GTIDs

商品描述(中文翻譯)

伺服器瓶頸和故障在任何資料庫部署中都是不可避免的,但它們不必使一切停擺。這本實用書籍介紹了複製、叢集和監控功能,可以幫助保護您的MySQL系統免受故障的影響,無論它是在硬體、虛擬機器還是雲端上運行。

本書由設計了許多所涵蓋工具的工程師撰寫,揭示了MySQL可靠性和高可用性的未記錄或難以找到的方面,這對於任何使用這個資料庫系統的組織來說都是必不可少的。這本第二版描述了MySQL工具的廣泛變化。涵蓋了5.5版本以及幾個5.6的功能。

學習複製的基礎知識,包括使用二進制日誌和MySQL Replicant Library
通過冗餘處理失敗的組件
擴展以管理讀取負載增加,並使用數據分片處理大型數據庫和寫入負載增加
使用MySQL Cluster在個別節點上存儲和複製數據
監控數據庫活動和性能,以及主要操作系統參數
跟踪主節點和從節點,處理故障和重啟、損壞和其他事件
檢查工具,包括MySQL Enterprise Monitor、MySQL Utilities和GTIDs