MySQL High Availability: Tools for Building Robust Data Centers (Paperback)
暫譯: MySQL 高可用性:構建穩健資料中心的工具 (平裝本)

Charles Bell, Mats Kindahl, Lars Thalmann

  • 出版商: O'Reilly
  • 出版日期: 2010-07-26
  • 售價: $1,900
  • 貴賓價: 9.5$1,805
  • 語言: 英文
  • 頁數: 624
  • 裝訂: Paperback
  • ISBN: 0596807309
  • ISBN-13: 9780596807306
  • 相關分類: MySQLSQL
  • 已過版

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

商品描述

Server bottlenecks and failures are a fact of life in any database deployment, but they don't have to bring everything to a halt. MySQL has several features that can help you protect your system from outages, whether it's running on hardware, virtual machines, or in the cloud. MySQL High Availability explains how to use these replication, cluster, and monitoring features in a wide range of real-life situations.

Written by engineers who designed many of the tools covered inside, 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.

  • Explore the binary log, a file for replication that helps in disaster recovery and troubleshooting
  • Get techniques for improving response time and handling large data sets
  • Monitor database activity and performance, as well as major operating system parameters
  • Keep track of what masters and slaves are doing, and deal with failures and restarts, corruption, and other incidents
  • Automate key tasks with code from an open source library written by the authors
  • Learn techniques for using MySQL in virtualized environments, such as Amazon Web Services
  • Use MySQL Cluster to achieve high availability
"MySQL replication is widely deployed but has never been adequately explained. This book changes that." -- Mark Callaghan, MySQL contributor and leader of MySQL engineering efforts at a few of the world's largest Internet companies

商品描述(中文翻譯)

伺服器瓶頸和故障是任何資料庫部署中不可避免的事實,但它們不必使一切停擺。MySQL 擁有多項功能,可以幫助您保護系統免受停機影響,無論它是在硬體、虛擬機器還是在雲端上運行。《MySQL 高可用性》解釋了如何在各種現實情況中使用這些複製、集群和監控功能。

本書由設計了許多內部工具的工程師撰寫,揭示了 MySQL 可靠性和高可用性中未記錄或難以找到的方面——這些知識對於任何使用此資料庫系統的組織都是必不可少的。

- 探索二進位日誌,這是一個用於複製的檔案,有助於災難恢復和故障排除
- 獲取改善響應時間和處理大型資料集的技術
- 監控資料庫活動和性能,以及主要作業系統參數
- 追蹤主從伺服器的操作,並處理故障和重啟、損壞及其他事件
- 使用作者撰寫的開源庫中的程式碼自動化關鍵任務
- 學習在虛擬化環境中使用 MySQL 的技術,例如 Amazon Web Services
- 使用 MySQL Cluster 實現高可用性

「MySQL 複製被廣泛部署,但從未得到充分解釋。本書改變了這一點。」—— Mark Callaghan,MySQL 貢獻者及全球幾家大型互聯網公司的 MySQL 工程工作負責人