Advanced MySQL Replication Techniques
Subject:   Double masters
Date:   2006-05-26 15:54:21
From:   jerry2000
Hi there

I would like to set up double masters and I have read your excellent article. I have 2 questions though:

1. Is there any problem setting the increment to 2, so all my ID's would be multiples of 2 instead of one? I mean, server doesn't care if I have 1 milion auto incremented numbers or 1 million numbers in increments of 2?

2. I would use one master for one domain and the other for another domain site (same sites)... What is my concern is what if a link breaks, something goes wrong the the replication stops working. I would end with 2 separate homepages that forum et. would not sync. Is there any way to get the 2 pages resynced again or is the script necesarry that looks all the ID's and inserts accordingly (quite a complex script). Is it possible to "repair" a broken replication link?