Re: Master Master Replication ... do a fail over and a week agos data is revealed.

[Johan De Meersman]

On Tue, Oct 19, 2010 at 1:03 PM, Carl <carl@stripped> wrote:

> Johan,
>
> You state that master - master is not reliable in dual active environments.
> I am in the process of setting up just such an environment (moderate active
> on the primary server, lighter activity on the other server.)  Do you know
> where I can get some information on the risks?
>

On the MySQL site, I guess :-) Your major issue is likely to be the lack of
two-phase commits (which has been added in the most recent release, iirc):
even if you properly interleave your autoincrements, the lack of a true
global lock means you still risk conflicting updates.

I can't really tell you a single spot where I got my knowledge on the
subject - I'm a long-time and multi-platform DBA, so it's a combination of
stuff I read and an understanding of how things work - or don't.

-- 
Bier met grenadyn
Is als mosterd by den wyn
Sy die't drinkt, is eene kwezel
Hy die't drinkt, is ras een ezel