List:General Discussion« Previous MessageNext Message »
From:Ananda Kumar Date:August 26 2010 2:08pm
Subject:Re: master-slave replication sync problems.
View as plain text  
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 <norman@stripped> 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.smith@stripped> 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=1
>
>

Thread
master-slave replication sync problems.Norman Khine26 Aug
  • Re: master-slave replication sync problems.Ananda Kumar26 Aug
  • Re: master-slave replication sync problems.a.smith26 Aug
    • Re: master-slave replication sync problems.Ananda Kumar26 Aug
    • Re: master-slave replication sync problems.Norman Khine26 Aug
      • Re: master-slave replication sync problems.Ananda Kumar26 Aug
      • Re: master-slave replication sync problems.a.smith26 Aug
        • Re: master-slave replication sync problems.Ananda Kumar26 Aug
          • Re: master-slave replication sync problems.a.smith26 Aug
  • Re: master-slave replication sync problems.jitendra ranjan26 Aug
    • Re: master-slave replication sync problems.a.smith26 Aug
  • RE: master-slave replication sync problems.Daevid Vincent26 Aug
    • Re: master-slave replication sync problems.MySQL)27 Aug
  • Re: master-slave replication sync problems.Todd Lyons1 Sep