Self-Introduction: Fergus Sullivan

[David Miller]

David Marshall wrote on 8/29/07 3:49 PM:
> On Aug 29, 2007, at 12:19 PM, Gervase Markham wrote:
>>> We have a dual-master database (we have our own proxy that can switch
>>> as needed)
>>
>> So MySQL supports this?
> 
> Er, no, it doesn't... :)  read "We have our own proxy" again.

Actually, it does.  Sort of.  We've been looking into it for Mozilla.
It's by no means easy to implement, and there's a few nasty
give-and-take hacks you have to use (like each autoincrement key gets
ranges assigned in advance per-server, and the masters have to
periodically coordinate with each other on reassigning new ranges as
they run out - which means the bug IDs won't necessarily line up with
the order the bugs are filed, and so forth).  It's difficult enough to
pull off that there's a few commercial products for rather huge $$$ that
are supposed to make it easy. ;)

-- 
Dave Miller                                   http://www.justdave.net/
System Administrator, Mozilla Corporation      http://www.mozilla.com/
Project Leader, Bugzilla Bug Tracking System  http://www.bugzilla.org/