On March 8, 2007 05:31 am, John Goetsch wrote:
> Hi,
> I have a master-slave model running just great.
>
> I now want to replicate a subset of the above database to a number of
> other nodes.  I thought of replicating this from the aforementioned
> slave (to reduce the the load on the master).
>
> The question is:  should all the nodes be one cluster ie master, slave
> and all subnodes, or should I have one cluster for the master-slave
> replication and one cluster for the slave-multinode replication.
>
> I can't seem to find the policy/rules/conventions about cluster creation.

A single cluster with multiple sets.

One set is the subset of relations that you want to cascade, the other set is 
the non cascaded relations.

>
> can any offer pointers or references....
>
> Thanks
> John
>
> _______________________________________________
> Slony1-general mailing list
> Slony1-general at lists.slony.info
> http://lists.slony.info/mailman/listinfo/slony1-general

-- 
Darcy Buskermolen
Command Prompt, Inc.
Sales/Support: +1.503.667.4564 || 24x7/Emergency: +1.800.492.2240
PostgreSQL solutions since 1997
http://www.commandprompt.com/