On 11/20/2008 4:34 AM, Mark Hagger wrote:
Apologies if this has been answered in the lists before, but I can't
seem to find any place or site that lets me directly search the archives
(a brute force "read the entire archives by hand" doesn't greatly appeal
to me...), google searches haven't really turned up anything useful
either.
If I want to replicate multiple databases from hostA to hostB does
anyone have any opinions/thoughts on using multiple clusters vs a single
cluster? Somehow both approaches feel wrong in some way, but those
appear to be the 2 choices.
I would tend to do it in separate clusters.
Even if they never exchange any data, all nodes in one cluster must have
possible event paths to each other. Which means that the nodes exchange
events for no reason at all, which leads to some unnecessary confirm
traffic. Also, if one set of databases gets screwed up and they are a
separate cluster, one can simply drop both databases and recreate a new
cluster. If it all is one big cluster, one at least has to properly drop
those nodes.
The only advantage of building one cluster seems to be that one hosts
sl_status view may reveal that everything is humming fine.
Jan
--
Anyone who trades liberty for security deserves neither
liberty nor security. -- Benjamin Franklin
_______________________________________________
Slony1-general mailing list
[email protected]
http://lists.slony.info/mailman/listinfo/slony1-general
