salman salmanb at quietcaresystems.com
Wed Dec 3 12:28:49 PST 2008
Josh Harrison wrote:
> Hi,
>
> Can 1 database be a slave for 2 different masters?
> ie., For example I have 2 databases - 1 holding "Instittion-A" data and
> another database for "Institution-B" data.
> These 2 database have some common tables with the same table structure.
>
> Is it possible to have a Slony replication from "Institution A"  database to
> "SLAVE-x"
> and a slony replication from "Institution-B" database to "SLAVE-x".
> These 2 "Institution" databases wont be accessing the same data...they have
> their own data but can Slony replicate them in the same slave?
>
> Thanks
> Josh
>
>   
> ------------------------------------------------------------------------
>
> _______________________________________________
> Slony1-general mailing list
> Slony1-general at lists.slony.info
> http://lists.slony.info/mailman/listinfo/slony1-general
>   
Maybe by creating two sets with the tables for institution A and B split 
between them and then subscribing the A set to master-1, and the B set 
to master-2 might work?

-salman


More information about the Slony1-general mailing list