List:General Discussion« Previous MessageNext Message »
From:Ananda Kumar Date:August 26 2010 1:09pm
Subject:Re: master-slave replication sync problems.
View as plain text  
since u r starting slave by postion beyond master, and if some of the
changes are already present on slave, it would error out with duplicate.

You need
show slave status\G;
slave stop;
show slave status\G;..wait for few min..than again
show slave status\G;....just to make sure...slave is in complete sync with
master...
Here u will see the master log file and position.
U need to use this, next time u start ur slave to sync with master.

regards
anandkl

On Thu, Aug 26, 2010 at 6:34 PM, Norman Khine <norman@stripped> wrote:

> hello,
> i have a working master-slave replication, the problem i find is that
> if i restart the MASTER there is a difference in the MASTER_LOG_FILE
> and MASTER_LOG_POS on the SLAVE.
>
> what is the correct way to keep the two slaves in sync even after i
> restart the server. the way i do it now is to:
>
> [MASTER]
> mysql> show master status;
>
>
> +------------------+----------+----------------------+--------------------------+
> | mysql-bin.000010 | 13405429 | upgrade,tracker,bugs |
> mysql,information_schema |
>
> +------------------+----------+----------------------+--------------------------+
> 1 row in set (0.00 sec)
>
> [SLAVE]
> mysql> stop slave;
> mysql> change master to MASTER_HOST='master.domain.com',
> MASTER_USER='replicator', MASTER_PASSWORD='xxx',
> MASTER_LOG_FILE='mysql-bin.000010', MASTER_LOG_POS=13301215;
> mysql> start slave;
>
> is this correct or is there a better way to do this?
>
> thanks
>
> --
> ˙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