Book review: High Availability MySQL Cookbook

Posted Posted by Patrice Guay in Web hosting     Comments No comments

Under the CentOS distribution, a MySQL database service can be transformed into an highly available service using different approaches. High Availability MySQL Cookbook presents them:

  • MySQL Cluster
  • MySQL replication
  • Shared storage
  • Block-level replication

This book is mainly focused on the MySQL Cluster approach with four (4) entire chapters dedicated to this method. The three (3) remaining approaches are covered in dedicated single chapters while the last chapter covers performance tuning of MySQL.

The configuration examples presented in the book are rich and well explained. These examples could be used to quickly set up an highly available MySQL database from scratch. However, the inner workings of MySQL in a highly available configuration could be more detailed. The graphical representations used to illustrate the theory behind the examples are poorly designed.

Another weakness of this book is the proposed method of installation for the Multi Master Replication Manager (MMM). The author recommends the installation of source packages. While these tools seem to be a valuable resource for a multi-master replication configuration, the use of manually installed software on a production environment should be avoided. The author should provide a way to install these tools via a set of packages specifically built for the CentOS distribution.

Nonetheless, this book is a valuable resource for a novice to intermediate level MySQL database administrator in his journey toward making its database highly available.

Product Details

  • Author: Alex Davies
  • Paperback: 276 pages
  • Publisher: Packt Publishing; 1st New edition edition (April 2010)
  • Language: English
  • ISBN-10: 1847199941
  • ISBN-13: 978-1847199942

Post comment