MySQL High Availability, 2nd Edition

Chapter 17. Managing MySQL Replication with MySQL Utilities

Joel was feeling pretty good about his job. Over the last few months he had conquered many tasks, including setting up replication and tuning MySQL. Most recently, his boss agreed to allow Joel to hire another MySQL administrator. Yes, Joel had finally made the job his own.

A familiar knock followed by an equally familiar intrusion by his boss broke Joel’s revelry.

“Joel, I’ve got a few candidates I’d like to interview. Before you do that, I’d like you to write up a training manual. Make sure you include all of the tricks and tips as well as all of your administrative trickery so that our new employee can come up to speed quickly. Start with that replication thing. That worries me.”

Not waiting for a reply, Joel’s boss disappeared on his way to the next drive-by tasking. Joel chuckled as he considered his latest challenge.

Suddenly, Joel’s boss thrust his head back into the doorway and said, “Be sure to use that DocBook format the documentation guys like so much.”

“Great!” Joel said with a mock smile as his boss once again disappeared. “I guess I’ll go visit the documentation team to see what tools they use to compile their DocBook files.”

MySQL replication is a very sound and reliable server feature. As you have seen in previous chapters, initiating and configuring replication requires a certain amount of knowledge as well as a set of procedures tailored to your needs. Knowing what to do when is the key to managing MySQL replication ...