MySQL Forums
Forum List  »  Replication

Re: Slave Replication Error
Posted by: Partha Dutta
Date: May 05, 2005 03:47PM

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

Options: ReplyQuote


Subject
Views
Written By
Posted
13381
May 04, 2005 07:47AM
10441
May 04, 2005 08:35AM
Re: Slave Replication Error
95762
May 05, 2005 03:47PM


Sorry, you can't reply to this topic. It has been closed.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.