Effective MySQL: Replication Techniques in Depth
Ronald Bradford has a way of distilling a great deal of information into eight chapters unlike any otehr author on MySQL. Replication has been one of the more popular features of MySQL, allowing it to blossom into environments ranging from the simplest to the awesomely complex. Usually replication is simple, predictable, and easy to manage. But this book is written for the MySQL DBA on the front lines looking for better, more resilient way of keeping data flowing. This is the latest of a series of books that cover one aspect of MySQL in a concise, no-fluff fashion. But what is this book like?
The first chapter is titled The Five Minute DBA and it shows how to identify and correct problems. The second chapter expands on the lessons from the first chapter by examining the architecture and then delves into more generic problems. The third chapter covers improvements past asynchronous replication and securing the servers via SSL. New features in the MySQL 5.6 DMR are covered.
The forth chapter is on Multi-Master Replication which leads directly into a chapter on MySQL Replication tools from many vendors — Openark Kit, Percona Toolkit, MySQL Workbench Untilites — and how to use them effectively to manage replication. MySQL MHA, MMM, Cluster Control, and Flipper are introduced as fail over managers.
Chapter 6 — Extending Replication for Practical Needs will be of great help for those exploring beyond tradition MySQL Replication. Ronald covers MySQL Cluster and Galera Cluster. He notes correctly that MySQL Cluster is a different product than the MySQL Server. Most of the chapter details Galera and Tunmgsten Replicator installations and configuration.
The last two chapters cover configuration options and monitoring respectively.
So, if you are a MySQL DBA using replication, do you really need this book as a reference on your book self? Maybe not if you are running a very simple master/salve pair that has not changed much since the days of 5.1. But if you are looking for a reference book that will aid you at 2AM when lag is high despite quiet systems, the you will be wise to invest in a copy of this book. If you are looking at exploiting new features to MySQL or venturing into areas such as multi-master replication, this book will save you time and effort. It is impossible to cover every aspect of MySQL Repilcation in 270 pages but Ronald has gone right to the vital areas you need to concentrate and avoids numbing detail for detail sake.