<div dir="ltr">I've gotten beyond much of my issues with replicating between locations. Most of which were all network, timeouts, keepalive settings etc.<br><div class="gmail_extra"><br></div><div class="gmail_extra">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.<br>
<br>So currently I have a 4 node cluster (Active Site A)<br><br></div><div class="gmail_extra"><br></div><div class="gmail_extra">masterhost- node 1<br>slavehost - node 2<br>queryslavehost1 node 3<br></div><div class="gmail_extra">
queryslavehost2 - node 4<br><br></div><div class="gmail_extra">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.<br>
<br></div><div class="gmail_extra">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).<br><br></div><div class="gmail_extra">Site B:<br><br></div>
<div class="gmail_extra">dc2masterhost - node 5<br></div><div class="gmail_extra">dc2slavehost - node 6<br>dc2queryslavehost1 - node 7<br>dc2queryslavehost2 - node 8<br><br></div><div class="gmail_extra">I would like slavehost (node2), replicate to dc2masterhost (node 5) and be a switchover/failover choice with both node1 and node2. <br>
<br></div><div class="gmail_extra">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).<br>
<br></div><div class="gmail_extra">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.<br>
<br></div><div class="gmail_extra">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.<br>
<br><br></div><div class="gmail_extra">Guess I'm not entirely sure how everything is aware of where they need to replicate from if things change in the cluster.<br><br>Thanks and I'm more then willing to try to make this more clear!:)<br>
<br></div><div class="gmail_extra">Tory<br></div></div>