<html>
<head>
<meta http-equiv="Content-Type" content="text/html; charset=Windows-1252">
<style type="text/css" style="display:none;"> P {margin-top:0;margin-bottom:0;} </style>
</head>
<body dir="ltr">
<div style="font-family: Calibri, Arial, Helvetica, sans-serif; font-size: 12pt; color: rgb(0, 0, 0);">
<br>
</div>
<div>
<div style="font-family: Calibri, Arial, Helvetica, sans-serif; font-size: 12pt; color: rgb(0, 0, 0);">
<br>
</div>
<div id="appendonsend"></div>
<hr tabindex="-1" style="display:inline-block; width:98%">
<div id="divRplyFwdMsg" dir="ltr"><font face="Calibri, sans-serif" color="#000000" style="font-size:11pt"><b>From:</b> Marty Wise <wise@jlab.org><br>
<b>Sent:</b> Wednesday, November 11, 2020 8:35 AM<br>
<b>To:</b> Mark Ito <marki@jlab.org>; David Lawrence <davidl@jlab.org>; Nathan Baltzell <baltzell@jlab.org>; Brad Sawatzky <brads@jlab.org>; Hovanes Egiyan <hovanes@jlab.org>; Stephen Wood <saw@jlab.org>; Douglas Higinbotham <doug@jlab.org><br>
<b>Cc:</b> Kelvin Edwards <kelvin@jlab.org>; Paul Letta <letta@jlab.org>; Sherman White <srwhite@jlab.org>; Myung Bang <bangdm@jlab.org>; Jessica Perry <jperry@jlab.org>; Joel Watkins <jwatkins@jlab.org>; Matthew Sconyers <sconyers@jlab.org><br>
<b>Subject:</b> FW: Central Fileserver changes and impact to DB servers</font>
<div> </div>
</div>
<div lang="EN-US">
<div class="x_WordSection1">
<p class="x_MsoNormal" style="margin: 0in 0in 0.0001pt; font-size: 11pt; font-family: Calibri, sans-serif;">
<span style="color:#1F497D">All,</span></p>
<p class="x_MsoNormal" style="margin: 0in 0in 0.0001pt; font-size: 11pt; font-family: Calibri, sans-serif;">
<span style="color:#1F497D"> </span></p>
<p class="x_MsoNormal" style="margin: 0in 0in 0.0001pt; font-size: 11pt; font-family: Calibri, sans-serif;">
<span style="color:#1F497D">MySQL/MariaDB servers will ALL be rebooted next Tuesday evening in step 4 of the general plan provided below. The affected DB servers include:</span></p>
<p class="x_MsoNormal" style="margin: 0in 0in 0.0001pt; font-size: 11pt; font-family: Calibri, sans-serif;">
<span style="color:#1F497D"> </span></p>
<p class="x_MsoListParagraph" style="margin: 0in 0in 0.0001pt 0.5in; font-size: 11pt; font-family: Calibri, sans-serif;text-indent:-.25in; mso-list:l0 level1 lfo2">
<span style="font-family:Symbol; color:#1F497D"><span style="mso-list:Ignore">·<span style="font:7.0pt "Times New Roman"">
</span></span></span><span style="color:#1F497D">halladb</span></p>
<p class="x_MsoListParagraph" style="margin: 0in 0in 0.0001pt 0.5in; font-size: 11pt; font-family: Calibri, sans-serif;text-indent:-.25in; mso-list:l0 level1 lfo2">
<span style="font-family:Symbol; color:#1F497D"><span style="mso-list:Ignore">·<span style="font:7.0pt "Times New Roman"">
</span></span></span><span style="color:#1F497D">hallbdb</span></p>
<p class="x_MsoListParagraph" style="margin: 0in 0in 0.0001pt 0.5in; font-size: 11pt; font-family: Calibri, sans-serif;text-indent:-.25in; mso-list:l0 level1 lfo2">
<span style="font-family:Symbol; color:#1F497D"><span style="mso-list:Ignore">·<span style="font:7.0pt "Times New Roman"">
</span></span></span><span style="color:#1F497D">clasdb (including central replicas, external server, etc)</span></p>
<p class="x_MsoListParagraph" style="margin: 0in 0in 0.0001pt 0.5in; font-size: 11pt; font-family: Calibri, sans-serif;text-indent:-.25in; mso-list:l0 level1 lfo2">
<span style="font-family:Symbol; color:#1F497D"><span style="mso-list:Ignore">·<span style="font:7.0pt "Times New Roman"">
</span></span></span><span style="color:#1F497D">hallcdb</span></p>
<p class="x_MsoListParagraph" style="margin: 0in 0in 0.0001pt 0.5in; font-size: 11pt; font-family: Calibri, sans-serif;text-indent:-.25in; mso-list:l0 level1 lfo2">
<span style="font-family:Symbol; color:#1F497D"><span style="mso-list:Ignore">·<span style="font:7.0pt "Times New Roman"">
</span></span></span><span style="color:#1F497D">hallddb (including central replicas, external server, etc)</span></p>
<p class="x_MsoListParagraph" style="margin: 0in 0in 0.0001pt 0.5in; font-size: 11pt; font-family: Calibri, sans-serif;text-indent:-.25in; mso-list:l0 level1 lfo2">
<span style="font-family:Symbol; color:#1F497D"><span style="mso-list:Ignore">·<span style="font:7.0pt "Times New Roman"">
</span></span></span><span style="color:#1F497D">qweakdb</span></p>
<p class="x_MsoListParagraph" style="margin: 0in 0in 0.0001pt 0.5in; font-size: 11pt; font-family: Calibri, sans-serif;text-indent:-.25in; mso-list:l0 level1 lfo2">
<span style="font-family:Symbol; color:#1F497D"><span style="mso-list:Ignore">·<span style="font:7.0pt "Times New Roman"">
</span></span></span><span style="color:#1F497D">jmysql</span></p>
<p class="x_MsoNormal" style="margin: 0in 0in 0.0001pt; font-size: 11pt; font-family: Calibri, sans-serif;">
<span style="color:#1F497D"> </span></p>
<p class="x_MsoNormal" style="margin: 0in 0in 0.0001pt; font-size: 11pt; font-family: Calibri, sans-serif;">
<span style="color:#1F497D">They will also be patched prior to the reboots. </span>
</p>
<p class="x_MsoNormal" style="margin: 0in 0in 0.0001pt; font-size: 11pt; font-family: Calibri, sans-serif;">
<span style="color:#1F497D"> </span></p>
<p class="x_MsoNormal" style="margin: 0in 0in 0.0001pt; font-size: 11pt; font-family: Calibri, sans-serif;">
<span style="color:#1F497D">We will be making major changes to the file servers listed below on Tuesday, Nov 17, 2020</span></p>
<p class="x_MsoNormal" style="margin: 0in 0in 0.0001pt; font-size: 11pt; font-family: Calibri, sans-serif;">
<span style="color:#1F497D"> </span></p>
<p class="x_MsoNormal" style="margin: 0in 0in 0.0001pt; font-size: 11pt; font-family: Calibri, sans-serif;">
<span style="color:#1F497D">Jlabsite:/site</span></p>
<p class="x_MsoNormal" style="margin: 0in 0in 0.0001pt; font-size: 11pt; font-family: Calibri, sans-serif;">
<span style="color:#1F497D">Jlabapps:/appsroot</span></p>
<p class="x_MsoNormal" style="margin: 0in 0in 0.0001pt; font-size: 11pt; font-family: Calibri, sans-serif;">
<span style="color:#1F497D"> </span></p>
<p class="x_MsoNormal" style="margin: 0in 0in 0.0001pt; font-size: 11pt; font-family: Calibri, sans-serif;">
<span style="color:#1F497D">If any of your machines mount these areas.. you need to act on this.</span></p>
<p class="x_MsoNormal" style="margin: 0in 0in 0.0001pt; font-size: 11pt; font-family: Calibri, sans-serif;">
<span style="color:#1F497D"> </span></p>
<p class="x_MsoNormal" style="margin: 0in 0in 0.0001pt; font-size: 11pt; font-family: Calibri, sans-serif;">
<span style="color:#1F497D">Currently jlabsite and jlabapps are actually aliases that point to the same NetApp, cfs1a.jlab.org.</span></p>
<p class="x_MsoNormal" style="margin: 0in 0in 0.0001pt; font-size: 11pt; font-family: Calibri, sans-serif;">
<span style="color:#1F497D">We are moving these areas to new virtual filers on new NetApp hardware. The IP addresses that both of these resolve to now, will change and will be different from each other.</span></p>
<p class="x_MsoNormal" style="margin: 0in 0in 0.0001pt; font-size: 11pt; font-family: Calibri, sans-serif;">
<span style="color:#1F497D"> </span></p>
<p class="x_MsoNormal" style="margin: 0in 0in 0.0001pt; font-size: 11pt; font-family: Calibri, sans-serif;">
<span style="color:#1F497D">So – the IP addresses that jlabsite and jlabapps resolve to right now, will be changing. This has major implications for MOST linux machines at JLAB.</span></p>
<p class="x_MsoNormal" style="margin: 0in 0in 0.0001pt; font-size: 11pt; font-family: Calibri, sans-serif;">
<span style="color:#1F497D"> </span></p>
<p class="x_MsoNormal" style="margin: 0in 0in 0.0001pt; font-size: 11pt; font-family: Calibri, sans-serif;">
<span style="color:#1F497D">We have published these to all JLAB machines via the automounter maps for many years.. therefore the number and location of machines that actually use them is impossible for us to know.</span></p>
<p class="x_MsoNormal" style="margin: 0in 0in 0.0001pt; font-size: 11pt; font-family: Calibri, sans-serif;">
<span style="color:#1F497D">(mainly because many other exports share the same NetApp right now).</span></p>
<p class="x_MsoNormal" style="margin: 0in 0in 0.0001pt; font-size: 11pt; font-family: Calibri, sans-serif;">
<span style="color:#1F497D"> </span></p>
<p class="x_MsoNormal" style="margin: 0in 0in 0.0001pt; font-size: 11pt; font-family: Calibri, sans-serif;">
<span style="color:#1F497D">Here is the general plan:</span></p>
<p class="x_MsoListParagraph" style="margin: 0in 0in 0.0001pt 0.5in; font-size: 11pt; font-family: Calibri, sans-serif;text-indent:-.25in; mso-list:l1 level1 lfo4">
<span style="color:#1F497D"><span style="mso-list:Ignore">1.<span style="font:7.0pt "Times New Roman"">
</span></span></span><span style="color:#1F497D">Tuesday, 11/17 at 5PM – change exports of jlabsite:/site and jlabapps:/appsroot to Read Only for all hosts. This isn’t that big a change, as there are only handful of machines that have r/w access to it.</span></p>
<p class="x_MsoListParagraph" style="margin: 0in 0in 0.0001pt 0.5in; font-size: 11pt; font-family: Calibri, sans-serif;text-indent:-.25in; mso-list:l1 level1 lfo4">
<span style="color:#1F497D"><span style="mso-list:Ignore">2.<span style="font:7.0pt "Times New Roman"">
</span></span></span><span style="color:#1F497D">Do a final incremental copy – this should take less than an hour.</span></p>
<p class="x_MsoListParagraph" style="margin: 0in 0in 0.0001pt 0.5in; font-size: 11pt; font-family: Calibri, sans-serif;text-indent:-.25in; mso-list:l1 level1 lfo4">
<span style="color:#1F497D"><span style="mso-list:Ignore">3.<span style="font:7.0pt "Times New Roman"">
</span></span></span><span style="color:#1F497D">Change DNS so that jlabsite and jlabapps now point to their new IPs.</span></p>
<p class="x_MsoListParagraph" style="margin: 0in 0in 0.0001pt 0.5in; font-size: 11pt; font-family: Calibri, sans-serif;text-indent:-.25in; mso-list:l1 level1 lfo4">
<span style="color:#1F497D"><span style="mso-list:Ignore">4.<span style="font:7.0pt "Times New Roman"">
</span></span></span><span style="color:#1F497D">Tuesday, 11/17 at about 6PM – start rebooting all Linux machines that we have controls over – including desktops.</span></p>
<p class="x_MsoListParagraph" style="margin: 0in 0in 0.0001pt 0.5in; font-size: 11pt; font-family: Calibri, sans-serif;text-indent:-.25in; mso-list:l1 level1 lfo4">
<span style="color:#1F497D"><span style="mso-list:Ignore">5.<span style="font:7.0pt "Times New Roman"">
</span></span></span><span style="color:#1F497D">Tuesday, 11/17 at about 8PM – remove even the ReadOnly exports from the old filer’s IP address for jlabsite:/site and jlabapps:/appsroot.</span></p>
<p class="x_MsoNormal" style="margin: 0in 0in 0.0001pt; font-size: 11pt; font-family: Calibri, sans-serif;">
<span style="color:#1F497D"> </span></p>
<p class="x_MsoNormal" style="margin: 0in 0in 0.0001pt; font-size: 11pt; font-family: Calibri, sans-serif;">
<span style="color:#1F497D"> </span></p>
<div>
<p class="x_MsoNormal" style="margin: 0in 0in 0.0001pt; font-size: 11pt; font-family: Calibri, sans-serif;">
<span style="color:#1F497D">Marty Wise</span></p>
<p class="x_MsoNormal" style="margin: 0in 0in 0.0001pt; font-size: 11pt; font-family: Calibri, sans-serif;">
<span style="color:#1F497D">Jlab CST/CNI</span></p>
</div>
</div>
</div>
</div>
</body>
</html>