<div dir="ltr"><br><div class="gmail_extra"><br><div class="gmail_quote">On Thu, Aug 13, 2015 at 3:51 PM, Tory M Blue <span dir="ltr"><<a href="mailto:tmblue@gmail.com" target="_blank">tmblue@gmail.com</a>></span> wrote:<br><blockquote class="gmail_quote" style="margin:0 0 0 .8ex;border-left:1px #ccc solid;padding-left:1ex"><div dir="ltr"><br><div class="gmail_extra">Been a bit, but I'm back with a question.</div><div class="gmail_extra"><br></div><div class="gmail_extra">I'm looking at doing a migration from one site to another and eventually have a hot warm site.</div><div class="gmail_extra"><br></div><div class="gmail_extra">Right now I have a 5 box slony cluster at site A</div><div class="gmail_extra"><br></div><div class="gmail_extra">Site A: Node 1 and 2 can switch/fail, nodes 3-5 are partial and can't become master.</div><div class="gmail_extra"><br></div><div class="gmail_extra">Node 1: MASTER</div><div class="gmail_extra">Node 2: SLAVE</div><div class="gmail_extra">Node 3: QUERYSLAVE1</div><div class="gmail_extra">Node 4: QUERYSLAVE2</div><div class="gmail_extra">Node 5: QUERYSLAVE3</div><div class="gmail_extra"><br></div><div class="gmail_extra">I have a new 5 node cluster in Site B.</div><div class="gmail_extra"><br></div><div class="gmail_extra">Site B: This is our default turn up, so they have the same NODE ID as Site A..</div><div class="gmail_extra"><br></div><div class="gmail_extra"><div class="gmail_extra">Node 1: MASTER</div><div class="gmail_extra">Node 2: SLAVE</div><div class="gmail_extra">Node 3: QUERYSLAVE1</div><div class="gmail_extra">Node 4: QUERYSLAVE2</div><div class="gmail_extra">Node 5: QUERYSLAVE3</div><div class="gmail_extra"><br></div><div class="gmail_extra">I was really interested in Node 2 of Site A replicating to Node 1 of Site B, and then just let the other boxen in site B take their information from Node 1 of the same site.</div><div class="gmail_extra"><br></div><div class="gmail_extra"> I think there is going to be some confusion with NODE ID's. I believe I can tell Site A that the Master of Site B is actually node 10 <whatever> and get it replicating and be able to drop NODE 10 if I needed from site A. However if I end up switching to the Master in Site B, It won't know how to tell SITE A to kiss off, as the NODE's in it's config will be 1,2,3,4,5, which are the same as Site A, so there would be no real way for me to clean up and or remove SITE A devices, drop node using NODE ID would be no beuno.<br></div><div class="gmail_extra"><br></div><div class="gmail_extra">So I guess basically, do I have to have unique NODE ID's (think I do, but if not??). It will just require some rework for every site I bring up, this means I have a few different configurations and or scripts to use depending on what site the cluster is in.</div><div class="gmail_extra"><br></div><div class="gmail_extra">Is this sort of clear, murky yet you have the general idea, or holy carp Tory what are you asking?</div><div class="gmail_extra"><br></div><div class="gmail_extra">Thanks</div><span class="HOEnZb"><font color="#888888"><div class="gmail_extra">Tory</div></font></span></div></div>
</blockquote></div><br></div><div class="gmail_extra"><br></div><div class="gmail_extra">Okay so someone pinged me off list and stated yes NODE ID's have to be unique, okay figured but that's good to know.</div><div class="gmail_extra"><br></div><div class="gmail_extra">Now I'm wondering how to best setup the replication.</div><div class="gmail_extra"><br></div><div class="gmail_extra">If Site A has </div><div class="gmail_extra"><br></div><div class="gmail_extra">(Nodes 1-5)</div><div class="gmail_extra">MASTER - Replicates to the 4 servers below</div><div class="gmail_extra">SLAVE</div><div class="gmail_extra">QUERYSLAVE1,2,3</div><div class="gmail_extra"><br></div><div class="gmail_extra">Site B has similar</div><div class="gmail_extra"><br></div><div class="gmail_extra">(Nodes 11-15)</div><div class="gmail_extra">DRMASTER - Replicates to the 4 servers below.</div><div class="gmail_extra">DRSLAVE</div><div class="gmail_extra">DRQUERYSLAVE1,2,3</div><div class="gmail_extra"><br></div><div class="gmail_extra">I was just thinking I would add DRMASTER as a slave off of SLAVE. Since SLAVE has forward = yes, it could easily forward the data on to DRMASTER and DRMASTER could in turn send all that DATA down it's pipe to DRSLAVE/DRQUERYS*</div><div class="gmail_extra"><br></div><div class="gmail_extra">I've run into a couple of issues and that is that it seems that all nodes in site A become aware of DRMASTER from site B, and not sure I want that and/or if it's possible to get around that. </div><div class="gmail_extra"><br></div><div class="gmail_extra">The paths should be in site A</div><div class="gmail_extra"><br></div><div class="gmail_extra">Master <-> Slave (set 1-3)</div><div class="gmail_extra">Master <-> Queryslave* (set 1)</div><div class="gmail_extra">Slave <-> Queryslave* (set 1) (due to switchover possibility).</div><div class="gmail_extra"><br></div><div class="gmail_extra">paths in site B</div><div class="gmail_extra"><br></div><div class="gmail_extra">DrMaster <-> DRSlave (set 1-3)</div><div class="gmail_extra">DrMaster <-> DRQueryslave* (set 1)<br></div><div class="gmail_extra"><div class="gmail_extra">DrSlave <-> DRQueryslave* (set 1) (due to switchover possibility).</div><div><br></div></div><div class="gmail_extra"><br></div><div class="gmail_extra">Then I would add a new path</div><div class="gmail_extra"><br></div><div class="gmail_extra">Slave <-> DrMaster (set 1-3)</div><div class="gmail_extra"><br></div><div class="gmail_extra">I'm wondering if I'm looking at this right. These are 2 separate clusters but the data has to be in sync and I'm looking to use this as a site migration tool.</div><div class="gmail_extra"><br></div><div class="gmail_extra">BTW we have been using slony for over 9 years ,so I'm not totally new to it, but it's always been isolated into it's own cluster (prod, staging, Qa, Dev etc), now I'm looking to use it as a migration mechanism between 2 clusters at differing locations.</div><div class="gmail_extra"><br></div><div class="gmail_extra">Thanks and sorry for being dense</div><div class="gmail_extra">Tory</div><div class="gmail_extra"><br></div><div class="gmail_extra"><br></div></div>