I have master to master replication ran was fine. One time admin re-booted one host and
followed rebooted another one. After that, one of the masters was able to automatically
re-connect to master and continue replication, but another master caould not resume
I did three things and all got same error message on the screen. (1. re-started slave;
2.change master to where it was stopped; 3. change master to current log file and
position). The error message is:
ERROR 1201 Could not initialize master info structure; more error messages can be found in
the MySQL error log.
In the error log, it only said cannot connect to sserver... Error reading relay log...
read up to .... SQL thread killed ... Normal shutdown
this log is the same as in another master and that server was able to re-connect.
Any idea of how to recover the replication without dump and sync database?