ONJava.com -- The Independent Source for Enterprise Java
oreilly.comSafari Books Online.Conferences.

advertisement

AddThis Social Bookmark Button
Article:
  Advanced MySQL Replication Techniques
Subject:   Consistency problem?
Date:   2007-03-14 08:43:53
From:   UloPe
Hi,


thank you for you interesting article.


I have a quation though.


Lets assume we have 4 servers (A,B,C,D) setup to replicate as follows: A->B->C->-D->A


As I understand your setup the following will happen if we pull the plug on C:
D should switch over to B as its master.


But here is the question: what happens if there are updates made on B while C is already dead? As soon (i.e. 30-59 sec if checkinterval is 30 s) as D detects that C is gone it will tell B to "reset master" and switch over, thereby missing all the changes that happend on A and B for maybe nearly a minute.


Am I correct in that assumption or did i miss something?


Thanks.


Ulrich


1 to 1 of 1
1 to 1 of 1