MusicBrainz database replication

[Robert (Jamie) Munro (Arjam.net)]

----- 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
alterd
> > 2 tables get done? How would foreign key integrity be preserved across
the
> > 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
replication
> > from a proper database. I would say check out
> > http://www.sf.net/projects/fibre, but I've not made a website for it
yet. If
> > you look in the CVS, you will find a brief document describing how it
will
> > 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?

Yes.

>  - Are you going to use Interbase specific features?

Yes. Absolutely.

>  - 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.
http://www.interbase2000.org/ib_casestudies.htm

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
easy.

Robert Munro

_______________________________________________
Musicbrainz mailing list
Musicbrainz at musicbrainz.org
http://www.musicbrainz.org/mailman/listinfo/musicbrainz