List:General Discussion« Previous MessageNext Message »
From:Irek S?onina Date:March 10 2005 3:49pm
Subject:Re: replication errors
View as plain text  
Chris Knipe wrote:
[..]
> Sure, there is a syntax error in the query - yes.  But why does the 
> master not put the complete query in the bin log?????????  This is the 
> second time in 3 days that it has happened now.  Whilst we are on this, 
> how do I tell the slave to skip the query and proceed with the rest of 
> the binlog... Thanks to this now, we already have a MASSIVE backlog that 
> needs to be processed.
[..]

I do not know if it is a best solution but that's shure that it's an 
easiest. Just add

slave-skip-errors = all

to the config... or just with errors that you want to skip, refer to the 
  manual for an extensive description.

--
Irek Slonina
Thread
replication errorsChris Knipe10 Mar
  • Re: replication errorsIrek S?onina10 Mar
  • Re: replication errorsChris Knipe10 Mar
  • Re: replication errorsChris Knipe10 Mar
    • Re: replication errorsIrek SÅ‚onina10 Mar
      • Re: replication errorsKeith Ivey11 Mar
    • Re: replication errorsRichard Lynch10 Mar
    • Re: replication errorsJeremy Cole10 Mar
  • Re: replication errorsChris Knipe10 Mar
  • Re: replication errorsChris Knipe10 Mar