MusicBrainz database replication
Robert (Jamie) Munro (Arjam.net)
rjmunro at arjam.net
Wed Jan 9 11:24:07 UTC 2002
----- Original Message -----
From: Robert Kaye <rob at eorbit.net>
To: <musicbrainz at musicbrainz.org>
Sent: Wednesday, January 09, 2002 1:40 AM
Subject: RE: MusicBrainz database replication
> On Tue, 2002-01-08 at 17:12, Robert Munro wrote:
> > That sounds like quite a bad idea. How on earth would an update that
> > 2 tables get done? How would foreign key integrity be preserved across
> > servers? If one server went down, how would the others all co-ordinate
> > adoption of the table it was managing? I think we need proper
> > from a proper database. I would say check out
> > http://www.sf.net/projects/fibre, but I've not made a website for it
> > you look in the CVS, you will find a brief document describing how it
> > work.
> Interesting. A few questions for you:
> - What support for writes are you planning to support initially?
> Writes only on the master? Writes get forwarded to the master?
All writes get stored to be batched to the master when required.
> - It looks like every master will need know about every other
> server. Right?
> - Are you going to use Interbase specific features?
> - Any idea for when this might be useable?
It depends on Viva's budgets and decisions as to weather I do it full time
for them, or just in my spare time for musicbrainz / the firebird community.
> If you get this to work nicely, maybe you will convince me to leave
> MySQL. Maybe Postgres? I dunno about Interbase...
Firebird is a fork of Interbase that was neccesary because Borland decided
that open sourcing it was no longer a good idea. Interbase has been in
production use by many organisations for about 20 years.
It has loads of features that make it more comparable to Oracle than to
MySQL. Transactions, Foreign keys, triggers, stored procedures, BLOBs and
BLOB filters (letting you do things like store a BMP in the database, but
select it as a GIF or JPG)...
It has a replication tool. It's just that bit isn't open source (Borland
again), so my project doesn't cover any new ground and should therefore be
Musicbrainz mailing list
Musicbrainz at musicbrainz.org
More information about the MusicBrainz-users