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 <[EMAIL PROTECTED]> Smokefree DC http://www.smokefreedc.org Washington, DC
-- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]