[Bucardo-general] scenario advice

[Joshua Tolley]

On Tue, Aug 18, 2009 at 01:09:36AM +1000, Grant Maxwell wrote:
>    Hi there
>    Im new to bucardo but am pleased at what it is doing for me already. I
>    have a scenario that I would like to ask advice on.
>    I have three (or more) databases arranged as (using my terminology)
>    Central, Tower1 and Tower2. The Towers create message records that are
>    replicated back to the Central.
>    The towers share a table (called table A). They both update and insert
>    records in their version of table A, and table A needs to be replicated
>    between them. The primary key is kept unique by assigning sequential
>    numbers from a different range on each tower for inserts.

Bucardo does nicely, provided certain assumptions, for multi-master
replication between two systems. More than two systems, though, could get
tricky. You'd need a set of different syncs, probably some with makedelta
enabled, and it still might not work. I recommend you experiment :) When/if
you solve the problem of getting replication to work at all in the schema you
describe, you can make it more complex with the various constraints you
described later in your email.

-- 
Josh Tolley  josh at endpoint.com  801-485-0203
End Point Corporation

-------------- next part --------------
A non-text attachment was scrubbed...
Name: not available
Type: application/pgp-signature
Size: 197 bytes
Desc: Digital signature
Url : https://mail.endcrypt.com/pipermail/bucardo-general/attachments/20090820/c6bab6ca/attachment.bin