hariadi/re-sync-mysql-replication.md

## re-sync-mysql-replication.md

      
    Raw
  

              re-sync-mysql-replication.md
            
          
    Re-sync MySQL Replication

Do this command in all server. In this example I'm use 2 server master-master replication
MASTER

RESET MASTER;
SHOW MASTER STATUS\G;
SLAVE

STOP SLAVE;
RESET SLAVE;
CHANGE MASTER TO MASTER_LOG_FILE='mysql-bin.000001', MASTER_LOG_POS=120;
START SLAVE;
To view status:
SHOW SLAVE STATUS\G;