Marc Munro wrote: > I am hoping to start a small discussion on the feasibility of creating > clusters of slony clusters. > > For a future project I am looking at the feasibility of creating a > geographically separated, replicated system of databases. There would > be a handful of sites, each replicating data that they own, to all other > sites. This is nothing unusual, and slony seems to work very well for > doing this. > > The difficulty arises when I want to use a 2-database slony cluster at > each site to allow for improved reliability, reduced maintenance > windows, etc. Doing this, I will double the number of databases in the > cluster, and increase the number of interconnections by a huge > (unworkable) factor. > > We could considerably reduce this interconnection overhead if we could > consider each site's pair of databases as a single slony node from the > point of view of each other site: to have in effect, a cluster of > clusters. > Can't this be accomplished right now by defining a global cluster for inter-site replication, and local clusters for intra-site traffic? Not a dream in terms of maintainability, but possible.
Regards, Andreas _______________________________________________ Slony1-general mailing list [email protected] http://gborg.postgresql.org/mailman/listinfo/slony1-general
