Hi All, 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 (master-bin.000031, 15494716) 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. --Anupam