I've gotten beyond much of my issues with replicating between locations.
Most of which were all network, timeouts, keepalive settings etc.

but now I'm trying to figure out the best way to have 2 slon clusters, that
will allow tear down of one without affecting the other.

So currently I have a 4 node cluster (Active Site A)


masterhost- node 1
slavehost - node 2
queryslavehost1 node 3
queryslavehost2 - node 4

master and slave have full table replication (3 sets), these are
switchover/failover candidates.   masterhost also replicates to
queryslavehost1 and queryslavehost2 but only  1 set.

I now want to bring up a second site, with 4 nodes (would love to  have
these node 1-4 as well, but that's not going to work).

Site B:

dc2masterhost - node 5
dc2slavehost - node 6
dc2queryslavehost1 - node 7
dc2queryslavehost2 - node 8

I would like slavehost (node2), replicate to dc2masterhost (node 5) and be
a switchover/failover choice  with both node1 and node2.

At the same time,  have node 6, 7, 8 replicate from node 5, where node 6 is
again a failover/switchover replica partner for node 5 (full 3 set
replication), and have node 6 replicate to nodes 7 and 8 (1 set
replication).

I really need a graphic to show this I think.  But I need to create
multiple scripts I think to make this work as at some point nodes 1-4 may
go away entirely and then I'm left with 5-8 which is not an issue in itself
it's the time where both environments are up that I need to make sure i
have this configured right.

I'm just not sure what happens if (and I've got this working), replicate
all 3 sets from node2 to node 5. But now I need to tell node6 to replicate
from node5 and node 7/8 to replicate from node6.  I'm not sure what happens
with node 6-8 if I do a switchover between  node 1/2 to node 5 and or
reverse.


Guess I'm not entirely sure how everything is aware of where they need to
replicate from if things change in the cluster.

Thanks and I'm more then willing to try to make this more clear!:)

Tory
-------------- next part --------------
An HTML attachment was scrubbed...
URL: http://lists.slony.info/pipermail/slony1-general/attachments/20140319/aef85aa7/attachment.htm