Re: Preventing slaves from falling behind masters...

2005-05-12 Thread Greg Whalin
qps of any of our replicants). Even w/ this, our replicants sometimes fall behind, but never more than 1 to 2 seconds. Donny -Original Message- From: Kevin Burton [mailto:[EMAIL PROTECTED] Sent: Wednesday, May 11, 2005 7:30 PM To: mysql@lists.mysql.com Subject: Preventing slaves fr

RE: Preventing slaves from falling behind masters...

2005-05-11 Thread Donny Simonton
Burton [mailto:[EMAIL PROTECTED] > Sent: Wednesday, May 11, 2005 7:30 PM > To: mysql@lists.mysql.com > Subject: Preventing slaves from falling behind masters... > > If you're running in a master/slave environment.. and you're application > is using the slave too often... rep

Preventing slaves from falling behind masters...

2005-05-11 Thread Kevin Burton
If you're running in a master/slave environment.. and you're application is using the slave too often... replication can fall behind which can then confuse your application. This can happen if the IO performance of both the master and slaves is equivalent and you're performaning INSERT/UPDATE/D