Please note: In order to keep Hive up to date and provide users with the best features, we are no longer able to fully support Internet Explorer. The site is still available to you, however some sections of the site may appear broken. We would encourage you to move to a more modern browser like Firefox, Edge or Chrome in order to experience the site fully.

MySQL High Availability : Tools for Building Robust Data Centers, PDF eBook

MySQL High Availability : Tools for Building Robust Data Centers PDF

PDF

Please note: eBooks can only be purchased with a UK issued credit card and all our eBooks (ePub and PDF) are DRM protected.

Description

Server bottlenecks and failures are a fact of life in any database deployment, but they dont 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 its 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 availabilityknowledge thats 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

Information

Other Formats

Information