{"id":1281,"date":"2021-02-03T11:46:21","date_gmt":"2021-02-03T17:46:21","guid":{"rendered":"https:\/\/varialhosting.com\/blog\/?p=1281"},"modified":"2021-03-06T00:23:10","modified_gmt":"2021-03-06T06:23:10","slug":"scheduled-maintenance-mysql-upgrades-on-lockhart-malfoy-and-sirius","status":"publish","type":"post","link":"https:\/\/varialhosting.com\/blog\/2021\/02\/scheduled-maintenance-mysql-upgrades-on-lockhart-malfoy-and-sirius\/","title":{"rendered":"Scheduled Maintenance: MySQL Upgrades on Lockhart, Malfoy and Sirius [Completed]"},"content":{"rendered":"\n<p class=\"wp-block-paragraph\">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.<\/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 for a short period until the MySQL upgrades have completed on each server.<\/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>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 offline in order to make [&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],"tags":[89,74,328,330,287,98],"class_list":["post-1281","post","type-post","status-publish","format-standard","hentry","category-announcements","tag-lockhart","tag-malfoy","tag-mysql","tag-mysql-upgrade","tag-scheduled-maintenance","tag-sirius"],"jetpack_featured_media_url":"","jetpack_shortlink":"https:\/\/wp.me\/p7kThA-kF","jetpack-related-posts":[{"id":1120,"url":"https:\/\/varialhosting.com\/blog\/2020\/02\/scheduled-maintenance-mysql-upgrades-on-lockhart-malfoy-sirius\/","url_meta":{"origin":1281,"position":0},"title":"Scheduled Maintenance: MySQL Upgrades on Lockhart, Malfoy &#038; Sirius [Completed]","author":"Varial","date":"February 12, 2020","format":false,"excerpt":"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\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":1281,"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":1281,"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":1411,"url":"https:\/\/varialhosting.com\/blog\/2022\/05\/scheduled-maintenance-mariadb-mysql-upgrades-on-hermione-and-snape-2\/","url_meta":{"origin":1281,"position":3},"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":1531,"url":"https:\/\/varialhosting.com\/blog\/2023\/05\/scheduled-maintenance-mariadb-mysql-upgrades-on-hermione-snape-and-tonks\/","url_meta":{"origin":1281,"position":4},"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":830,"url":"https:\/\/varialhosting.com\/blog\/2018\/11\/default-php-version-to-be-changed-to-5-6-on-december-1-2018\/","url_meta":{"origin":1281,"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,"_links":{"self":[{"href":"https:\/\/varialhosting.com\/blog\/wp-json\/wp\/v2\/posts\/1281","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=1281"}],"version-history":[{"count":6,"href":"https:\/\/varialhosting.com\/blog\/wp-json\/wp\/v2\/posts\/1281\/revisions"}],"predecessor-version":[{"id":1295,"href":"https:\/\/varialhosting.com\/blog\/wp-json\/wp\/v2\/posts\/1281\/revisions\/1295"}],"wp:attachment":[{"href":"https:\/\/varialhosting.com\/blog\/wp-json\/wp\/v2\/media?parent=1281"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/varialhosting.com\/blog\/wp-json\/wp\/v2\/categories?post=1281"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/varialhosting.com\/blog\/wp-json\/wp\/v2\/tags?post=1281"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}