MySQL master to master replication

[dghvoip]

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.

[falko]

http://www.howtoforge.com/how-to-rep...ql-replication

There are cases where this doesn't help, and you have to set up replication from scratch again.