Jennifer Spencer jennifer.spencer at stanford.edu
Wed Aug 27 19:46:06 PDT 2008
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.

Existing situation:
--I have a master db (node 1) on port 5432, a slave (node 2) on 5430, all running slony proper.
--I have one cluster, jsoc_example, between nodes 1 & 2
--I am successfully log-shipping jsoc_example to /mylogdir using a slon -a command on my slon for node 
2.

****************Problem to be solved:
1.  The boss wants minimal drag on the production database (e.g. minimal triggers, minimal number of 
overlapping clusters).
2.  We have about 10 future subscriber sites that want sometimes the same data tables, sometimes 
different data tables from the same database (arg!).
3.  All subscribers will be log-ship subscribers.

I figure I can do one cluster per table, or I can parse one cluster's logs.  <--What do you suggest 
here???


More information about the Slony1-general mailing list