{"id":1120,"date":"2020-02-12T11:20:59","date_gmt":"2020-02-12T17:20:59","guid":{"rendered":"https:\/\/varialhosting.com\/blog\/?p=1120"},"modified":"2020-03-01T18:09:44","modified_gmt":"2020-03-02T00:09:44","slug":"scheduled-maintenance-mysql-upgrades-on-lockhart-malfoy-sirius","status":"publish","type":"post","link":"https:\/\/varialhosting.com\/blog\/2020\/02\/scheduled-maintenance-mysql-upgrades-on-lockhart-malfoy-sirius\/","title":{"rendered":"Scheduled Maintenance: MySQL Upgrades on Lockhart, Malfoy &#038; Sirius [Completed]"},"content":{"rendered":"\n<p class=\"wp-block-paragraph\">On March 1, 2020, we will be upgrading the MySQL database server on our Lockhart, Malfoy and Sirius servers to MySQL 5.6 as support for all previous versions will be discontinued by cPanel upon their next major release due at the end of Q1 2020.<\/p>\n\n\n\n<p class=\"wp-block-paragraph\">Significant work has been performed by our staff over the past two years to prepare customer accounts for compatibility with newer MySQL versions, which will allow us to upgrade our database servers at a more frequent pace in the future.<\/p>\n\n\n\n<p class=\"wp-block-paragraph\">Prior to the upgrades, database servers will be briefly taken offline in order to make a complete backup of all customer databases. Websites utilizing MySQL databases will become temporarily unavailable until the MySQL upgrades have completed on each server.<\/p>\n\n\n\n<p class=\"wp-block-paragraph\">Additional MySQL upgrades will be scheduled later in 2020 to switch to MariaDB (an optimized replacement for MySQL) to meet feature parity with  our more recently deployed servers.<\/p>\n\n\n\n<p class=\"wp-block-paragraph\">This document will be updated with our progress as the upgrades are performed.<\/p>\n\n\n\n<p class=\"wp-block-paragraph\"><strong>Progress:<\/strong><\/p>\n\n\n\n<p class=\"wp-block-paragraph\">Lockhart &#8211; Completed<br>Malfoy &#8211; Completed<br>Sirius &#8211; Completed<\/p>\n","protected":false},"excerpt":{"rendered":"<p>On March 1, 2020, we will be upgrading the MySQL database server on our Lockhart, Malfoy and Sirius servers to MySQL 5.6 as support for all previous versions will be discontinued by cPanel upon their next major release due at the end of Q1 2020. Significant work has been performed by our staff over the [&hellip;]<\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"_jetpack_newsletter_access":"","_jetpack_dont_email_post_to_subs":false,"_jetpack_newsletter_tier_id":0,"_jetpack_memberships_contains_paywalled_content":false,"_jetpack_feature_clip_id":0,"_jetpack_memberships_contains_paid_content":false,"footnotes":"","jetpack_post_was_ever_published":false},"categories":[1,2],"tags":[331,332,89,74,329,328,330,98],"class_list":["post-1120","post","type-post","status-publish","format-standard","hentry","category-announcements","category-maintenance","tag-database","tag-database-upgrade","tag-lockhart","tag-malfoy","tag-mariadb","tag-mysql","tag-mysql-upgrade","tag-sirius"],"jetpack_shortlink":"https:\/\/wp.me\/p7kThA-i4","jetpack-related-posts":[{"id":1281,"url":"https:\/\/varialhosting.com\/blog\/2021\/02\/scheduled-maintenance-mysql-upgrades-on-lockhart-malfoy-and-sirius\/","url_meta":{"origin":1120,"position":0},"title":"Scheduled Maintenance: MySQL Upgrades on Lockhart, Malfoy and Sirius [Completed]","author":"Varial","date":"February 3, 2021","format":false,"excerpt":"In the evening of Friday, March 5, 2021, we will be upgrading the MySQL database server on our Lockhart, Malfoy and Sirius servers from MySQL 5.6 to MySQL 5.7. MySQL will be run with strict mode disabled for best compatibility. Prior to the upgrades, database servers will be briefly taken\u2026","rel":"","context":"In &quot;Announcements&quot;","block_context":{"text":"Announcements","link":"https:\/\/varialhosting.com\/blog\/category\/announcements\/"},"img":{"alt_text":"","src":"https:\/\/i0.wp.com\/varialhosting.com\/assets\/img\/facebook-square.png?ssl=1&resize=350%2C200","width":350,"height":200},"classes":[]},{"id":1573,"url":"https:\/\/varialhosting.com\/blog\/2023\/09\/scheduled-maintenance-mysql-mariadb-upgrades-on-malfoy-and-sirius\/","url_meta":{"origin":1120,"position":1},"title":"Scheduled Maintenance: MySQL (MariaDB) Upgrades on Malfoy and Sirius [Completed]","author":"Varial","date":"September 19, 2023","format":false,"excerpt":"In the evening of Saturday, October 7, 2023 we will be upgrading the MySQL database server on our Malfoy and Sirius servers from MySQL 5.7 to MariaDB 10.5. MariaDB is an optimized, drop-in replacement for MySQL. This upgrade will be completed in two steps, first the migration from MySQL 5.7\u2026","rel":"","context":"In &quot;Maintenance&quot;","block_context":{"text":"Maintenance","link":"https:\/\/varialhosting.com\/blog\/category\/maintenance\/"},"img":{"alt_text":"","src":"https:\/\/i0.wp.com\/varialhosting.com\/assets\/img\/facebook-square.png?ssl=1&resize=350%2C200","width":350,"height":200},"classes":[]},{"id":1221,"url":"https:\/\/varialhosting.com\/blog\/2020\/10\/scheduled-maintenance-mariadb-mysql-upgrades-on-hermione-and-snape\/","url_meta":{"origin":1120,"position":2},"title":"Scheduled Maintenance: MariaDB (MySQL) Upgrades on Hermione and Snape [Completed]","author":"Varial","date":"October 1, 2020","format":false,"excerpt":"On October 17, 2020, we will be upgrading the MariaDB database server on our Hermione and Snape servers from MariaDB 10.1 (based on MySQL 5.6) to MariaDB 10.2 (based on MySQL 5.7). MariaDB will be run with strict mode disabled for best compatibility. Prior to the upgrades, database servers will\u2026","rel":"","context":"In &quot;Announcements&quot;","block_context":{"text":"Announcements","link":"https:\/\/varialhosting.com\/blog\/category\/announcements\/"},"img":{"alt_text":"","src":"https:\/\/i0.wp.com\/varialhosting.com\/assets\/img\/facebook-square.png?ssl=1&resize=350%2C200","width":350,"height":200},"classes":[]},{"id":1531,"url":"https:\/\/varialhosting.com\/blog\/2023\/05\/scheduled-maintenance-mariadb-mysql-upgrades-on-hermione-snape-and-tonks\/","url_meta":{"origin":1120,"position":3},"title":"Scheduled Maintenance: MariaDB (MySQL) Upgrades on Hermione, Snape and Tonks [Completed]","author":"Varial","date":"May 5, 2023","format":false,"excerpt":"In the evening of Saturday, May 20, 2023 we will be upgrading the MariaDB (MySQL) database server on our Hermione, Snape and Tonks servers from MariaDB 10.3 to MariaDB 10.5. Websites utilizing MariaDB\/MySQL databases will be temporarily unavailable for approximately 10-15 minutes until the upgrades are completed on each server.","rel":"","context":"In &quot;Announcements&quot;","block_context":{"text":"Announcements","link":"https:\/\/varialhosting.com\/blog\/category\/announcements\/"},"img":{"alt_text":"","src":"https:\/\/i0.wp.com\/varialhosting.com\/assets\/img\/facebook-square.png?ssl=1&resize=350%2C200","width":350,"height":200},"classes":[]},{"id":1411,"url":"https:\/\/varialhosting.com\/blog\/2022\/05\/scheduled-maintenance-mariadb-mysql-upgrades-on-hermione-and-snape-2\/","url_meta":{"origin":1120,"position":4},"title":"Scheduled Maintenance: MariaDB (MySQL) Upgrades on Hermione and Snape [Completed]","author":"Varial","date":"May 2, 2022","format":false,"excerpt":"In the evening of Saturday, May 14, 2022 we will be upgrading the MariaDB (MySQL) database server on our Hermione and Snape servers from MariaDB 10.2 to MariaDB 10.3. Websites utilizing MariaDB\/MySQL databases will be temporarily unavailable for approximately 10-15 minutes until the upgrades are completed on each server. As\u2026","rel":"","context":"In &quot;Announcements&quot;","block_context":{"text":"Announcements","link":"https:\/\/varialhosting.com\/blog\/category\/announcements\/"},"img":{"alt_text":"","src":"https:\/\/i0.wp.com\/varialhosting.com\/assets\/img\/facebook-square.png?ssl=1&resize=350%2C200","width":350,"height":200},"classes":[]},{"id":830,"url":"https:\/\/varialhosting.com\/blog\/2018\/11\/default-php-version-to-be-changed-to-5-6-on-december-1-2018\/","url_meta":{"origin":1120,"position":5},"title":"Default PHP version to be changed to 5.6 on December 1, 2018","author":"Varial","date":"November 1, 2018","format":false,"excerpt":"In the coming months cPanel will be discontinuing their current web stack, in use on our Lockhart, Malfoy, Sirius and Snape servers, in favour of a new, modular system that allows for easy, automatic upgrades of its many components. We have been preparing for this change for many months, planning\u2026","rel":"","context":"In &quot;Announcements&quot;","block_context":{"text":"Announcements","link":"https:\/\/varialhosting.com\/blog\/category\/announcements\/"},"img":{"alt_text":"","src":"https:\/\/i0.wp.com\/varialhosting.com\/assets\/img\/facebook-square.png?ssl=1&resize=350%2C200","width":350,"height":200},"classes":[]}],"jetpack_sharing_enabled":true,"jetpack_featured_media_url":"","_links":{"self":[{"href":"https:\/\/varialhosting.com\/blog\/wp-json\/wp\/v2\/posts\/1120","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/varialhosting.com\/blog\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/varialhosting.com\/blog\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/varialhosting.com\/blog\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/varialhosting.com\/blog\/wp-json\/wp\/v2\/comments?post=1120"}],"version-history":[{"count":20,"href":"https:\/\/varialhosting.com\/blog\/wp-json\/wp\/v2\/posts\/1120\/revisions"}],"predecessor-version":[{"id":1157,"href":"https:\/\/varialhosting.com\/blog\/wp-json\/wp\/v2\/posts\/1120\/revisions\/1157"}],"wp:attachment":[{"href":"https:\/\/varialhosting.com\/blog\/wp-json\/wp\/v2\/media?parent=1120"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/varialhosting.com\/blog\/wp-json\/wp\/v2\/categories?post=1120"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/varialhosting.com\/blog\/wp-json\/wp\/v2\/tags?post=1120"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}