Replication is a feature of MySQL that allows one database server to mirror the data on another database server by executing the same queries. There are more complicated ways of setting it up but basic replication involves one master server and one slave server. Read more…
I have noticed strange behavior with MySQL version 5 and replication. I manage several MySQL database servers. The setup is simple, one master and two replication slaves acting as backups. The master server version is 5.0.22-log and the two slaves are 5.0.51a and 5.0.45.
When the replication gets interrupted (either via a clean server shutdown or a forced one), replication refuses to restart citing the following error:
ERROR 1201: Could not initialize master info structure, more error messages can be found in the MySQL error log