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