Replication Sync Error

Replication Sync Error

am 23.06.2011 12:36:00 von Anupam Karmarkar

--0-1200941328-1308825360=:28533
Content-Type: text/plain; charset=utf-8
Content-Transfer-Encoding: quoted-printable

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 syn=
c, 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=20

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, positi=
on 15505129.

can any one help on this.=20

--Anupam

--0-1200941328-1308825360=:28533--