List:Replication« Previous MessageNext Message »
From:Rick James Date:January 16 2008 9:53pm
Subject:RE: Replication resurrection
View as plain text  
slave stop;
set skip_counter = 1;  # check spelling
slave start; 

> -----Original Message-----
> From: Marcus Bointon [mailto:marcus@stripped] 
> Sent: Wednesday, January 16, 2008 9:38 AM
> To: replication@stripped
> Subject: Replication resurrection
> 
> So I have a circular replication setup that has stopped because of a  
> key clash, possibly caused by queries that produce varying results,  
> such as RAND() and NOW() (and I'm not using 5.1 yet to fix 
> that). So I  
> want to stop the problem node, delete its DB and start again. 
> Now, If  
> I tell it to drop the DB, I obviously don't want that 
> statement to be  
> replicated back to the master. Can anyone point me at a replication  
> resurrection howto? Or give me a list of sanity checks?
> 
> Thanks,
> 
> Marcus
> -- 
> Marcus Bointon
> Synchromedia Limited: Creators of http://www.smartmessages.net/
> UK resellers of info@hand CRM solutions
> marcus@stripped | http://www.synchromedia.co.uk/
> 
> 
> 
Thread
Replication resurrectionMarcus Bointon16 Jan
  • RE: Replication resurrectionRick James16 Jan