<html>
<head>
<meta http-equiv="Content-Type" content="text/html; charset=UTF-8">
</head>
<body>
<p>All,</p>
<p>The upgrade to MySQL (Percona) 5.7 on the mysql1-vip cluster has
been completed successfully! We had a few minutes of downtime to
fail-over the cluster around 12:33 PDT.<br>
</p>
<p>Please reach out if you run into any issues. Expect information
on additional maintenance in the near future.</p>
<p> Thanks!</p>
<p><br>
</p>
<div class="moz-cite-prefix">On 5/27/22 10:43 AM, Ethan Hampton
wrote:<br>
</div>
<blockquote type="cite"
cite="mid:744b5062-8c60-69f0-4bdc-8199c247d2f4@osuosl.org">
<meta http-equiv="content-type" content="text/html; charset=UTF-8">
<div id="magicdomid2" class="ace-line"><span class="">All,</span></div>
<div id="magicdomid3" class="ace-line"><br>
</div>
<div id="magicdomid4" class="ace-line"><span class="">We will be
upgrading one of our MySQL clusters (mysql1-vip
(mysql1/mysql2)) Monday, June 6th, 2022 between 17:00-20:00
UTC (10am-1pm PDT).</span></div>
<div id="magicdomid5" class="ace-line"><br>
</div>
<div id="magicdomid6" class="ace-line"><span class="">Just prior
to the upgrade (9am PDT), we will be running a backup of the
cluster. We have tested that the backup can be completed
without a read lock on the cluster. We have several
contingencies in place to allow continued use during the
backup. As a result, we expect no downtime from this backup
operation.</span></div>
<div id="magicdomid7" class="ace-line"><br>
</div>
<div id="magicdomid8" class="ace-line"><span class="">We are
upgrading MySQL (Percona) from 5.6 to 5.7. This is the next
step towards managing the cluster under Chef and upgrading to
a modern OS version. Expect more maintenance on this cluster
in the near future.</span></div>
<div id="magicdomid9" class="ace-line"><br>
</div>
<div id="magicdomid10" class="ace-line"><span class="">This will
result in up to 20 minutes of downtime in the middle of the
window as we fail-over the cluster. We estimate that the
actual downtime will be far less than that bound.</span></div>
<div id="magicdomid11" class="ace-line"><br>
</div>
<div id="magicdomid12" class="ace-line"><span class="">MySQL 5.7
increases the 'strictness' of the default `sql_mode` used. We
will keep the configuration used by MySQL 5.6 during this
upgrade, however we plan to migrate to the default MySQL 5.7
setting at a future date.</span></div>
<div id="magicdomid13" class="ace-line"><br>
</div>
<div id="magicdomid14" class="ace-line"><span class="b"><b>If you
are using the vip1 cluster, please make sure you are using
the mysql1-vip.osuosl.org address instead of
mysql1/2.osuosl.org directly or additional outages will
occur.</b></span></div>
<div id="magicdomid15" class="ace-line"><br>
</div>
<div id="magicdomid16" class="ace-line"><span class="">We have
tested this upgrade in a separate environment and believe that
it will have minimal impact to projects on the cluster. If you
have any questions or concerns, please let us know. We'll be
in #osuosl on Libera Chat during the upgrade in case any one
needs to contact us directly.</span></div>
<div class="ace-line"><span class=""><br>
</span></div>
<div class="ace-line"><span class="">Thanks!<br>
</span></div>
<pre class="moz-signature" cols="72">--
Ethan Hampton
Student Systems Engineer
Oregon State University | Open Source Lab</pre>
</blockquote>
<pre class="moz-signature" cols="72">--
Ethan Hampton
Student Systems Engineer
Oregon State University | Open Source Lab</pre>
</body>
</html>