MySQL High Availability

Tools for Building Robust Data Centers

Nonfiction, Computers, Database Management
Cover of the book MySQL High Availability by Charles Bell, Mats Kindahl, Lars Thalmann, O'Reilly Media
View on Amazon View on AbeBooks View on Kobo View on B.Depository View on eBay View on Walmart
Author: Charles Bell, Mats Kindahl, Lars Thalmann ISBN: 9781449339562
Publisher: O'Reilly Media Publication: April 10, 2014
Imprint: O'Reilly Media Language: English
Author: Charles Bell, Mats Kindahl, Lars Thalmann
ISBN: 9781449339562
Publisher: O'Reilly Media
Publication: April 10, 2014
Imprint: O'Reilly Media
Language: English

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
View on Amazon View on AbeBooks View on Kobo View on B.Depository View on eBay View on Walmart

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.

More books from O'Reilly Media

Cover of the book Rails Pocket Reference by Charles Bell, Mats Kindahl, Lars Thalmann
Cover of the book Developing Large Web Applications by Charles Bell, Mats Kindahl, Lars Thalmann
Cover of the book Praxiswissen Drupal 7 by Charles Bell, Mats Kindahl, Lars Thalmann
Cover of the book 802.11 Wireless Networks: The Definitive Guide by Charles Bell, Mats Kindahl, Lars Thalmann
Cover of the book Python for Data Analysis by Charles Bell, Mats Kindahl, Lars Thalmann
Cover of the book HTML5 Hacks by Charles Bell, Mats Kindahl, Lars Thalmann
Cover of the book Online-Shops mit Magento by Charles Bell, Mats Kindahl, Lars Thalmann
Cover of the book Photoshop Elements 6: The Missing Manual by Charles Bell, Mats Kindahl, Lars Thalmann
Cover of the book Learning XNA 4.0 by Charles Bell, Mats Kindahl, Lars Thalmann
Cover of the book DNS and BIND on IPv6 by Charles Bell, Mats Kindahl, Lars Thalmann
Cover of the book The Myths of Innovation by Charles Bell, Mats Kindahl, Lars Thalmann
Cover of the book WebSocket by Charles Bell, Mats Kindahl, Lars Thalmann
Cover of the book App Savvy by Charles Bell, Mats Kindahl, Lars Thalmann
Cover of the book iWork '09: The Missing Manual by Charles Bell, Mats Kindahl, Lars Thalmann
Cover of the book Minecraft Modding with Forge by Charles Bell, Mats Kindahl, Lars Thalmann
We use our own "cookies" and third party cookies to improve services and to see statistical information. By using this website, you agree to our Privacy Policy