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).
Synchromedia Limited: Creators of http://www.smartmessages.net/
UK info@hand CRM solutions
marcus@stripped | http://www.synchromedia.co.uk/