MySQL Forums
Forum List  »  Synchronization

mysql replication skip statement. is it possible?
Posted by: Vladimir Linevich
Date: July 17, 2013 07:58AM

There is a system with ROW-based replication. Yesterday i have executed a heavy statement on my master accidently and found my slaves far behind master. I have interrupted the query on master, but it was still running on slaves. So i got my slaves 15 hours behind master.

I have already tried to step over one position by resetting slave and increasing MASTER_LOG_POS, but with no luck: position wasn't found, because relay log wasn't read further than a heavy query event.

Read_Master_Log_Pos == Exec_Master_Log_Pos

Is there any way to skip the heavy query? (i don't care about data that has to be changed by query)
Is there a way to kill a query on a slave taken from relay log?
Is there a way to roll the slaves back in 1 position, remove the event from master bin-log and resume the replication?

Options: ReplyQuote

Written By
mysql replication skip statement. is it possible?
July 17, 2013 07:58AM

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.