RE: mySQL slave IO Running and SQL Running

2009-05-21 Thread Jerry Schwartz
. -Original Message- From: Daevid Vincent [mailto:dae...@daevid.com] Sent: Wednesday, May 20, 2009 4:49 PM To: mysql@lists.mysql.com Cc: 'Gavin Towey'; 'Claudio Nanni' Subject: RE: mySQL slave IO Running and SQL Running Well, in 90% of our cases it is. Most often caused by some dumb-ass (usually

Re: mySQL slave IO Running and SQL Running

2009-05-20 Thread Claudio Nanni
Yeah Daevid! I know very well the issue! first set the slave to READ ONLY [mysqld] read-only then there is a configuration option to tell the server to skip some type of errors automatically slave-skip-errors=

RE: mySQL slave IO Running and SQL Running

2009-05-20 Thread Gavin Towey
problems. -Original Message- From: Claudio Nanni [mailto:claudio.na...@gmail.com] Sent: Wednesday, May 20, 2009 12:49 PM To: Daevid Vincent Cc: mysql@lists.mysql.com Subject: Re: mySQL slave IO Running and SQL Running Yeah Daevid! I know very well the issue! first set the slave to READ

RE: mySQL slave IO Running and SQL Running

2009-05-20 Thread Daevid Vincent
To: Claudio Nanni; Daevid Vincent Cc: mysql@lists.mysql.com Subject: RE: mySQL slave IO Running and SQL Running Please note that this is *NOT* a way to get them synched again In fact if you have to skip a replication statement on the slave then it is usually a sign your slave has different