.
-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
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=
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
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