High Availability MySQL Cookbook

Alex Davies

  • 出版商: Packt Publishing
  • 出版日期: 2010-04-29
  • 售價: $1,930
  • 貴賓價: 9.5$1,834
  • 語言: 英文
  • 頁數: 276
  • 裝訂: Paperback
  • ISBN: 1847199941
  • ISBN-13: 9781847199942
  • 相關分類: MySQLSQL
  • 海外代購書籍(需單獨結帳)

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

商品描述

There's more than one way to achieve high availability for MySQL and this Cookbook covers a range of techniques and tools in over 60 practical recipes. The only book of its kind, you'll be learning the natural, engaging way. Overview Analyze and learn different high availability options, including clustering and replication solutions within MySQL Improve uptime of your MySQL databases with simple recipes showing powerful high availability techniques for MySQL Tune your MySQL database for optimal performance. The only complete, practical, book of MySQL high availability techniques and tools on the market Part of Packt's Cookbook series: Each recipe is a carefully organized sequence of instructions to complete the task as efficiently as possible What you will learn from this book Configure a MySQL Cluster for scaling out MySQL Learn the technique of taking online backups and recovery Achieve high availability with MySQL Replication and various tools such as the open source Multi-Master Replication Manager (MMM) and Flipper projects Configure a MySQL replication design to replicate data from one MySQL database server to one or more other MySQL database servers Master the safety tricks of replication to prevent replication failure Configure a MySQL service to work using a shared storage device to achieve high availability, with and without a clustered filesystem Learn to use the open source Global File System (GFS) to have the same file system on more than one node Achieve high availability using block level replication with Distributed Replicated Block Device (DRBD) Improve your system's performance with the technique of performance tuning Approach This book uses the approach of a cookbook. Each recipe provides the reader with easy step-by-step descriptions of the actions necessary to accomplish a specific task. It is designed to present what often appear as extremely complicated techniques as a series of simple-to

商品描述(中文翻譯)

有多種方法可以實現MySQL的高可用性,這本食譜將涵蓋超過60個實用的技巧和工具。這是唯一一本這樣的書籍,您將以自然而有趣的方式學習。概述分析和學習不同的高可用性選項,包括MySQL內的集群和複製解決方案通過簡單的食譜提高MySQL數據庫的正常運行時間調整MySQL數據庫以獲得最佳性能。這是市場上唯一一本完整、實用的MySQL高可用性技術和工具的書籍Packt的食譜系列的一部分:每個食譜都是一系列精心組織的指令,以盡可能高效地完成任務您將從本書中學到什麼配置MySQL集群以擴展MySQL學習在線備份和恢復技術使用MySQL複製和各種工具(如開源的多主複製管理器(MMM)和Flipper項目)實現高可用性配置MySQL複製設計,將數據從一個MySQL數據庫服務器複製到一個或多個其他MySQL數據庫服務器掌握複製的安全技巧,以防止複製失敗配置MySQL服務以使用共享存儲設備實現高可用性,有或沒有集群文件系統學習使用開源全局文件系統(GFS)在多個節點上擁有相同的文件系統使用分散複製塊設備(DRBD)實現基於塊的複製以實現高可用性通過性能調優技術提高系統性能這本書採用食譜的方式。每個食譜都提供讀者易於理解的逐步描述,以完成特定任務所需的操作。它旨在將通常看起來非常複雜的技術呈現為一系列簡單易懂的步驟。