From: a.smith Date: August 26 2010 3:46pm Subject: Re: master-slave replication sync problems. List-Archive: http://lists.mysql.com/mysql/222701 Message-Id: <20100826164626.81442ndrj54gj7gg@webmail2.ukgrid.net> MIME-Version: 1.0 Content-Type: text/plain; charset=UTF-8; DelSp="Yes"; format="flowed" Content-Transfer-Encoding: 8bit Quoting jitendra ranjan : > Hi, >   > The best way to use sync the master and slave is using mk-checksum > tools. just google it and use the the tools for online sync of > master and slave. >   > Jeetendra Ranjan > MySQL DBA > Yes, data integrity isnt guaranteed with MySQL replication. So if you want to be sure good idea to use the maartkit tools... Tho this isnt necessarily answering the original question, which is to do with the master and slave not showing the same binlog file and log position. If replication is working at all, these will be in sync (assuming the changes on the master arent happening faster than replication can keep up).