Re: [siesta-dev] multimaster replication

[prev] [thread] [next] [lurker] [Date index for 2006/05/22]

From: Richard Clamp
Subject: Re: [siesta-dev] multimaster replication
Date: 17:02 on 22 May 2006
Morty wrote:
> Should siesta work correctly in conjunction with a DB that does
> multimaster replication?  Ie. two instances of sympa on two different
> mail servers, each with its own DB backend, and the DBs sync with each
> other.
> 

Unlikely, if only because we use auto-incrementing ints as primary keys 
everywhere, and from what I remember clustered databases aren't terribly 
happy when you do that.

Off the top of my head I can't think of a reason why we couldn't just 
rip out all the integer ids and replace them with uuids assigned by the 
code say via Class::DBI::UUID, apart from that it would be a migration 
headache for existing users.


-- 
Richard Clamp <richardc@xxxxxxxxx.xxx>

Generated at 14:00 on 12 Aug 2006 by mariachi 0.52