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.
http://www.howtoforge.com/how-to-repair-mysql-replication There are cases where this doesn't help, and you have to set up replication from scratch again.
