Wed Aug 27 19:46:06 PDT 2008
- Previous message: [Slony1-general] Partition Tables - How does slony replicate it
- Next message: [Slony1-general] How to define clusters - please help
- Messages sorted by: [ date ] [ thread ] [ subject ] [ author ]
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???
- Previous message: [Slony1-general] Partition Tables - How does slony replicate it
- Next message: [Slony1-general] How to define clusters - please help
- Messages sorted by: [ date ] [ thread ] [ subject ] [ author ]
More information about the Slony1-general mailing list