Re: Slave Replication Error

[Partha Dutta]

There is another mechanism that you can use, which is the skip counter. You can skip the current transaction that the replication thread is hung on and continue. You can issue the following command in mysql to skip a transaction:

mysql> SET GLOBAL SQL_SLAVE_SKIP_COUNTER = 1;
mysql> START SLAVE;

Use the value 1 for any SQL statement that does not use AUTO_INCREMENT or LAST_INSERT_ID(), otherwise you will need to use the value 2. Statements that use AUTO_INCREMENT or LAST_INSERT_ID() take up 2 events in the binary log.

Partha Dutta
Senior Consultant, MySQL Inc.

http://www.mysql.com