MySQL High Availability: Tools for Building Robust Data Centers

MySQL High Availability: Tools for Building Robust Data Centers

Mats Kindahl, Lars Thalmann

Server bottlenecks and screw ups are a truth of lifestyles in any database deployment, yet they don’t need to carry every little thing to a halt. This useful e-book explains replication, cluster, and tracking good points that could aid shield your MySQL procedure from outages, no matter if it’s working on undefined, digital machines, or within the cloud.

Written via engineers who designed a few of the instruments coated, this booklet finds undocumented or hard-to-find points of MySQL reliability and excessive availability—knowledge that’s crucial for any association utilizing this database approach. This moment version describes broad alterations to MySQL instruments. models as much as 5.5 are lined, in addition to numerous 5.6 features.

  • Learn replication basics, together with use of the binary log and MySQL Replicant Library
  • Handle failing parts via redundancy
  • Scale out to control read-load raises, and use info sharding to address huge databases and write-load increases
  • Store and reflect information on person nodes with MySQL Cluster
  • Monitor database job and function, and significant working method parameters
  • Keep music of masters and slaves, and care for mess ups and restarts, corruption, and different incidents
  • Examine instruments together with MySQL firm computer screen, MySQL Utilities, and GTIDs

Show sample text content

Download sample