Re: Proposal for a cascaded master-slave replication system

On Nov 11, 2003, at 12:11 PM, Joe Conway wrote:

> Jan Wieck wrote:
>> http://developer.postgresql.org/~wieck/slony1.html
>
> Very interesting read. Nice work!

Ditto.  I'll read it a bit closer later,  but after a quick read it
seems quite complete and well thought out. I especially like
that sequences are being dealt with.

Thanks for putting the effort in, and making it a community project.

>
>> We want to build this system as a community project. The plan was from
>> the beginning to release the product under the BSD license. And we
>> think
>> it is best to start it as such and to ask for suggestions during the
>> design phase already.
>
> I couldn't quite tell from the design doc -- do you intend to support
> conditional replication at a row level?
>
> I'm also curious, with cascaded replication, how do you handle the
> case where a second level slave has a transaction failure for some
> reason, i.e.:
>
>             M
>            / \
>           /   \
>         Sa     Sb
>        /  \   /  \
>       Sc  Sd Se  Sf
>
> What happens if data is successfully replicated to Sa, Sb, Sc, and Sd,
> and then an exception/rollback occurs on Se?
>
> Joe
>
>
> ---------------------------(end of
> broadcast)---------------------------
> TIP 2: you can get off all lists at once with the unregister command
>    (send "unregister YourEmailAddressHere" to majordomo@postgresql.org)
>
--------------------

Andrew Rawnsley
President
The Ravensfield Digital Resource Group, Ltd.
(740) 587-0114
www.ravensfield.com