Hear us Roar
Article:
 |
|
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?
Yours
Jerry
|
|
| |
