List:General Discussion« Previous MessageNext Message »
From:Norman Khine Date:August 26 2010 2:04pm
Subject:Re: master-slave replication sync problems.
View as plain text  
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" ] )
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