MySQL Replication Re-Syncing

MySQL Replication Re-Syncing

I may be in the minority here, but I’ve spent alot of time resyncing my MySQL replication slaves. They just seem to drift away from an exact duplicate of the master. Here’s a quick list of tips to remember when performing this task. Make sure you STOP the MySQL service on the master before you make your snapshot.  Otherwise you’ll have no idea where to start your slaves.  When you restart the service, you’ll see what...

Read More

Mysql Replication Issues and Errors

Everywhere I look I see articles about how easy it is to set up replication in MySQL.  I will admit that it’s easy, but at what cost?  I am not comfortable enough with MySQL’s replication to just set it and forget it.  It’s been difficult to keep things synchronized between the master and slave. As I work this out, I’ll be adding links and comments to this post.  There’s alot of good material out there, and...

Read More