From: Ananda Kumar (anandklgmail.com)
Date: Thu Aug 26 2010 - 09:08:29 CDT

• Messages sorted by: [ date ] [ thread ] [ subject ] [ author ]

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 <normankhine.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.smithukgrid.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=anandklgmail.com
>
>

• Messages sorted by: [ date ] [ thread ] [ subject ] [ author ]