MySQL master to master replication

Discussion in 'Server Operation' started by dghvoip, Apr 29, 2012.

  1. dghvoip

    dghvoip New Member

    Hi, I setup two servers in master to master replication but I'd like to know how if anything goes wrong in replication for some reason what should I do, should I restart fro the begginning deleting all databases on the seconda master or can I just use CHANGE MASTER TO ... stanza and use the LOG_POSITION= to what the SHOW MASTER STATUS; on server one and restart the slave.

    The concise question is how do I resync the servers if replication breaks?.

    Thanks.
     
  2. falko

    falko Super Moderator

Share This Page