On Wed, Aug 27, 2008 at 07:46:06PM -0700, Jennifer Spencer wrote:
> I need help figuring out how to create a smart cluster layout to log-ship my data.
> Please, oh please, help me understand a couple of things about nodes & 
> clusters.  What is possible and what is not, specifically.
>

I think you're missing a concept you need, which is "sets".

> 1.  The boss wants minimal drag on the production database (e.g. minimal 
> triggers, minimal number of overlapping clusters).

Additional sets should not produce detectable drag.

> 2.  We have about 10 future subscriber sites that want sometimes the same 
> data tables, sometimes different data tables from the same database (arg!).

Put the minimal set of tables that could be wanted at any one site
into one set.  That site subscribes to that set, and not the others.

A


-- 
Andrew Sullivan
ajs at commandprompt.com
+1 503 667 4564 x104
http://www.commandprompt.com/