Self-Introduction: Fergus Sullivan

David Miller justdave at
Thu Aug 30 00:08:36 UTC 2007

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                         
System Administrator, Mozilla Corporation
Project Leader, Bugzilla Bug Tracking System

More information about the developers mailing list