<html><head></head><body><div class="ydp6f0620edyahoo-style-wrap" style="font-family: Helvetica Neue, Helvetica, Arial, sans-serif; font-size: 13px;"><div><div dir="ltr" data-setdir="false">Hi all, <br></div><div dir="ltr" data-setdir="false"><br></div><div dir="ltr" data-setdir="false">I have a situation and I just want to validate with the community if my approach is ok.</div><div dir="ltr" data-setdir="false"><br></div><div dir="ltr" data-setdir="false">I have a <b>Master-Master</b> setup of <b>4</b> servers in different geographical regions. <br>What I want to do is to <b>remove</b> one of these servers and <b>add</b> another one in a different part of the world.</div><div dir="ltr" data-setdir="false"><span>The thing is that I would like to export the DB from the one that will
be removed and import it on the new one (as I want to recycle a
sequence).</span></div><div dir="ltr" data-setdir="false"><br></div><div dir="ltr" data-setdir="false">My current setup is that I have a Sync that uses a dbGroup where all servers are mapped as sources.<br></div><div dir="ltr" data-setdir="false"><br></div><div dir="ltr" data-setdir="false"><br></div><div dir="ltr" data-setdir="false">My approach is like this: <br></div><div dir="ltr" data-setdir="false"><br></div><div dir="ltr" data-setdir="false">- Deactivate the sync</div><div dir="ltr" data-setdir="false">- update the dbgroup with only the remaining 3 servers (this way I can continue replication between these 3 servers) <i>(<font color="#cd232c"><span>bucardo update dbgroup foobar s1 s2 s3:source</span></font>)</i><br></div><div dir="ltr" data-setdir="false">- remove the db from bucardo config <i><span>(<font style="background-color: inherit;" color="#cd232c">bucardo remove database MyDB</font></span>)</i><br></div><div dir="ltr" data-setdir="false">- activate and start the sync</div><div dir="ltr" data-setdir="false"><br></div><div dir="ltr" data-setdir="false">- export the db and move to new server</div><div dir="ltr" data-setdir="false">- create the new DB in bucardo, that will point to the new server</div><div dir="ltr" data-setdir="false"><br></div><div dir="ltr" data-setdir="false">- deactivate the sync<br></div><div dir="ltr" data-setdir="false">- update dbgroup with all 4 servers (3old + 1 new) - hoping that this will update the sync that uses this dbGroup <span><i>(<font color="#cd232c"><span>bucardo update dbgroup foobar s1 s2 s3:source</span></font>)</i></span><br></div><div dir="ltr" data-setdir="false">- reactivate and start the sync in the new config</div><div dir="ltr" data-setdir="false"><br></div><div dir="ltr" data-setdir="false">I am aware that I will miss the updates that happened between when I have removed and readded the new DB, but I think I can handle this after with some updates on one of the old server (that will propagate the changes on all servers (including the new one)).</div><div dir="ltr" data-setdir="false"><br></div><br><div dir="ltr" data-setdir="false">What do you think?<br></div><div><br></div><div class="ydp6f0620edsignature"><div style="font-family:Helvetica, Arial, sans-serif;font-size:13px;"><div><br> </div><div><span><div class="ydp744c546bsignature" dir="ltr" data-setdir="false">Thank you,</div></span></div><span><div class="ydp744c546bsignature"> Adrian Videanu</div><div class="ydp744c546bsignature"><span>Skype: videanu.adrian</span></div></span><div><span><span>Tel:+40723864025</span></span></div></div></div></div></div></body></html>