From: Ananda Kumar Date: August 26 2010 2:08pm Subject: Re: master-slave replication sync problems. List-Archive: http://lists.mysql.com/mysql/222693 Message-Id: MIME-Version: 1.0 Content-Type: multipart/alternative; boundary=002215b025725e0c3b048eba8896 --002215b025725e0c3b048eba8896 Content-Type: text/plain; charset=UTF-8 Content-Transfer-Encoding: quoted-printable Yes, You need to note down the master bin-log file name and position on the slave, this is a must. regards anandkl On Thu, Aug 26, 2010 at 7:34 PM, Norman Khine wrote: > 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? > > > > On Thu, Aug 26, 2010 at 3:09 PM, wrote: > > That is really bad, you will loose changes. > > > > You shouldnt have to do anything when rebooting either the master or > slave. > > If the master is down, then the slave recieves no updates. If the slave > is > > down, when it comes back up it checks the master log pos and plays thro > any > > changes that are necessary to bring it up to date... > > > > > > > > > > > > > > -- > =CB=99u=CA=8Dop =C7=9Dp=C4=B1sdn p,u=C9=B9n=CA=87 p=D7=9F=C9=B9o=CA=8D = =C7=9D=C9=A5=CA=87 =C7=9D=C7=9Ds no=CA=8E '=CA=87u=C7=9D=C9=AF=C9=90=D7=9F = s=C7=9D=C9=AF=C4=B1=CA=87 =C7=9D=C9=A5=CA=87 pu=C9=90 '=CA=87u=C7=9D=CA=87u= o=C9=94 > =C7=9Dq s,=CA=87=C7=9D=D7=9F =CA=87=C7=9D=CA=8E > %>>> "".join( [ {'*':'@','^':'.'}.get(c,None) or > chr(97+(ord(c)-83)%26) for c in ",adym,*)&uzq^zqf" ] ) > > -- > MySQL General Mailing List > For list archives: http://lists.mysql.com/mysql > To unsubscribe: http://lists.mysql.com/mysql?unsub=3Danandkl@stripped > > --002215b025725e0c3b048eba8896--