We are running semi-sync replication on production server, last week found out that
replication suck at some event schedule created at master, as that was not important i
skipped that started replication again, found out that slave is days behind at master, i
invested gate more and found that it is read 200 MB of binary file and few more need to be
read by salve get in sync, still i think 200 MB file should not take hours to read, any
ways but in error logs i am keep on getting following error
110623 15:50:56 [Note] Semi-sync replication switched OFF.
110623 15:50:56 [Note] Semi-sync replication switched ON with slave (server_id: 2) at
110623 15:51:02 [Warning] Timeout waiting for reply of binlog (file: master-bin.000031,
pos: 15505733), semi-sync up to file master-bin.000031, position 15505129.
can any one help on this.
|• Replication Sync Error||Anupam Karmarkar||23 Jun|