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 <nor...@khine.net> 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, <a.sm...@ukgrid.net> 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... > > > > > > > > > > > > > > -- > ˙uʍop ǝpısdn p,uɹnʇ pןɹoʍ ǝɥʇ ǝǝs noʎ 'ʇuǝɯɐן sǝɯıʇ ǝɥʇ puɐ 'ʇuǝʇuoɔ > ǝq s,ʇǝן ʇǝʎ > %>>> "".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=anan...@gmail.com > >