Self-Introduction: Fergus Sullivan
justdave at bugzilla.org
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 http://www.justdave.net/
System Administrator, Mozilla Corporation http://www.mozilla.com/
Project Leader, Bugzilla Bug Tracking System http://www.bugzilla.org/
More information about the developers