From: a.smith Date: August 26 2010 3:18pm Subject: Re: master-slave replication sync problems. List-Archive: http://lists.mysql.com/mysql/222696 Message-Id: <20100826161842.594650lk3u6emask@webmail2.ukgrid.net> MIME-Version: 1.0 Content-Type: text/plain; charset=UTF-8; DelSp="Yes"; format="flowed" Content-Transfer-Encoding: 7bit Quoting Norman Khine : > i see, so the best is to just stop slave and then check the master > status, and when the master status syncs then i start the slave? > > > Well Im willing to hear from others experiences, but if you really shouldnt have to do anything. If you want you can issue a stop slave before the reboot and a start slave after, but it shouldnt make any difference. And Im not sure what you refer to when you talk about the master status syncing. The master will continue to increment the binlog when changes are made regardless of whether the slave is up. If the slave has been rebooted and is behind the master binlog pos it should automatically sync those changes when started...