Replication Sync Error

--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

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.

--Anupam

--0-1200941328-1308825360=:28533--
Anupam Karmarkar [ Do, 23 Juni 2011 12:36 ] [ ID #2061438 ]
Datenbanken » gmane.comp.db.mysql.general » Replication Sync Error

Vorheriges Thema: Help making tablespaces work for my application
Nächstes Thema: MySQL Replication - promote slave