<html><head><meta http-equiv="Content-Type" content="text/html charset=windows-1252"></head><body style="word-wrap: break-word; -webkit-nbsp-mode: space; -webkit-line-break: after-white-space;"><div>Sounds good to me for Thimble and Popcorn.</div><div><br></div><div>I didn’t think <a href="http://webmaker.org">webmaker.org</a> still used a database though, is that the old events database? I think that can be decommissioned.</div><div>Can you make an announcement on the Webmaker list? It should be sort, but always good to let people know.</div><br><div><div>On Apr 24, 2014, at 1:50 PM, JP Schneider <<a href="mailto:jp@mozillafoundation.org">jp@mozillafoundation.org</a>> wrote:</div><br class="Apple-interchange-newline"><blockquote type="cite"><div dir="ltr">Good day!<div><br></div><div>AWS just gave us the ability to upgrade from MySQL 5.5 to 5.6 in-place on RDS. MySQL 5.6 is vastly superior to 5.5 for a lot of reasons, but especially for the ability to do online schema changes (migrations) without any downtime caused by table locking.</div>
<div><br></div><div>All staging apps currently are using MySQL 5.6 and have been for some time now (except source). I'd like to propose that overnight tonight, we upgrade all production apps (except source, which we'll do staging first) to MySQL 5.6.<br>
<br>What will this do? This will cause approximately three minutes of applications being unavailable while we flip db hosts.<br><br>My plan would be to do it at midnight central to allow for some testing and QA before it gets too late. For safety, I will also snapshot each and every database prior to the upgrade as a fallback.</div>
<div><br></div><div>The affected databases would include:</div><div><div>lightbeamdb</div><div>monitoring (opsview)</div><div>openbadges backpack</div><div><a href="http://openbadges.org/">openbadges.org</a></div><div>source (staging only for tonight)</div>
<div>thimble</div><div><a href="http://webmaker.org/">webmaker.org</a></div><div>popcorn</div></div><div><br></div><div>Thoughts? Feedback?</div><div><br></div><div>Future!</div><div>JP</div></div>
_______________________________________________<br>Webmaker-dev mailing list<br><a href="mailto:Webmaker-dev@mozilla.org">Webmaker-dev@mozilla.org</a><br>https://mail.mozilla.org/listinfo/webmaker-dev<br></blockquote></div><br></body></html>