List:General Discussion« Previous MessageNext Message »
From:Keith Ivey Date:March 10 2005 11:02pm
Subject:Re: replication errors
View as plain text  
Irek Słonina wrote:

> I was thinking that master is executing the same queries that slave does 
> - if an error exists on slave then it first comes up on the master and 
> master is not executing it either.
> You prove that I was wrong... now I must check the integrity of the data
> on my slaves, which all are running with slave skip errors turned on :/.

Anyone thinking of using slave-skip-errors should read the 
documentation about it, which should be enough to scare them 
away from that option (especially "all"):

| You can (but should not) also use the very non-recommended
| value of _all_ which ignores all error messages and keeps
| barging along regardless of what happens. Needless to say, if
| you use it, we make no promises regarding your data integrity.
| Please do not complain if your data on the slave is not
| anywhere close to what it is on the master in this case. You
| have been warned.

http://dev.mysql.com/doc/mysql/en/replication-options.html

-- 
Keith Ivey <keith@stripped>
Smokefree DC
http://www.smokefreedc.org
Washington, DC
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