From: Marcus Bointon
Date: July 20 2012 6:50am
Subject: Re: Sync between master and slave
List-Archive: http://lists.mysql.com/replication/2374
Message-Id: <8DC0E7B1-2BE5-4BF9-A9CD-8096B659EF31@synchromedia.co.uk>
MIME-Version: 1.0 (Apple Message framework v1278)
Content-Type: text/plain; charset=iso-8859-1
Content-Transfer-Encoding: quoted-printable

On 20 Jul 2012, at 06:18, Reddy YK wrote:
>=20
> 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
--=20
Marcus Bointon
Synchromedia Limited: Creators of http://www.smartmessages.net/
UK info@hand CRM solutions
marcus@stripped | http://www.synchromedia.co.uk/