Effective MySQL: Replication Techniques in Depth
Ronald Bradford
Oracle Press
270 pages

Effective MySQL: Replication Techniques in Depth

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.


One Response to

  1. Ben Altman says:

    Hi, I am also a fan of the book and enjoyed the review, thanks. For those who don’t own it, Ronald has shared a sample chapter for free download:

    This third chapter in the book reveals practical information about:
    – How MySQL and third-party tools overcome the limitations of asynchronous replication, by providing semisynchronous and fully synchronous replication.
    – Why securing MySQL replication using SSL is becoming critical in the face of the burgeoning use of cloud services.
    – New replication features in MySQL 5.6, with a focus on data integrity, performance, and usability.

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out /  Change )

Google+ photo

You are commenting using your Google+ account. Log Out /  Change )

Twitter picture

You are commenting using your Twitter account. Log Out /  Change )

Facebook photo

You are commenting using your Facebook account. Log Out /  Change )

Connecting to %s

%d bloggers like this: