List:Replication« Previous MessageNext Message »
From:Marcus Bointon Date:July 20 2012 6:50am
Subject:Re: Sync between master and slave
View as plain text  
On 20 Jul 2012, at 06:18, Reddy YK wrote:
> 
> How come even though replication is in sync, sometimes the no of rows will
> be different between master and slave? Without any bugs!

It must mean that they were different originally or pushed out of sync by
non-replication-safe statements, or possibly mysql bugs. You can use the percona toolkit
to spot and fix differences between hosts. It may well be easier to set up the slave from
scratch again (use xtrabackup, makes it really easy).

Marcus
-- 
Marcus Bointon
Synchromedia Limited: Creators of http://www.smartmessages.net/
UK info@hand CRM solutions
marcus@stripped | http://www.synchromedia.co.uk/



Thread
Sync between master and slaveReddy YK20 Jul
  • Re: Sync between master and slaveMarcus Bointon20 Jul