From: Marcus Bointon
Date: October 31 2007 4:16pm
Subject: Re: Add a replicated DB w/o rebooting the server
List-Archive: http://lists.mysql.com/replication/982
Message-Id: <76C39CF7-7CDD-4139-83FF-7AE1FF692740@synchromedia.co.uk>
MIME-Version: 1.0 (Apple Message framework v912)
Content-Type: text/plain; charset=US-ASCII; format=flowed; delsp=yes
Content-Transfer-Encoding: 7bit


On 31 Oct 2007, at 15:56, Oriol Capsada wrote:

> At this point my1 does not contain the information of the insert1  
> because it has been deleted (it was replicated from my2), but it is  
> contained in the my2. Now we have an inconsistency...


That's not a replication problem, it's a transaction problem. If those  
statements were wrapped in a a transaction, either all of them or none  
of them would happen, thus avoiding your problem altogether.

I use circular replication a lot for this kind of stuff because I can  
switch my clients between masters at any time and then restart the  
inactive master to pick up new settings without any downtime.

Marcus
-- 
Marcus Bointon
Synchromedia Limited: Creators of http://www.smartmessages.net/
UK resellers of info@hand CRM solutions
marcus@stripped | http://www.synchromedia.co.uk/