Skip navigation links

MySQL Forums :: Replication :: Slave Replication Error


Advanced Search

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
Slave Replication Error 12449 Tyler Ingram 05/04/2005 07:47AM
Re: Slave Replication Error 9732 Tyler Ingram 05/04/2005 08:35AM
Re: Slave Replication Error 82467 Partha Dutta 05/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.