MariaDB (MySQL) database server update from 10.1 to 10.3

Update 9:16 PM June 27: the maintenance described below has be completed on all servers, so all servers are now running the MariaDB 10.3 series.

Over the next three weeks, we’ll be updating the MariaDB (MySQL) database server software on all our servers from the MariaDB 10.1 series to the MariaDB 10.3 series (equivalent to the Oracle MySQL 5.7 series).

The MariaDB/MySQL database software is what stores pages for WordPress and other sites that are run by scripts. Customers should not notice any difference after this change; we’re upgrading it to a more recent version simply to make sure it’s as fast, reliable and secure as possible. We’ve been using the new version on internal and test servers for some time.

At the moment the software is updated on a server, WordPress and other database-backed sites on that server will have 30-60 seconds of unavoidable “downtime”. To minimize the impact of that, we do these upgrades only on Friday, Saturday and Sunday nights between 9 PM and midnight Pacific time (midnight-3 AM Eastern time). This process will be complete on all servers by June 28.

Beyond that one-time brief interruption in service, customers should not notice any difference to how their site works, as we said. But as always, don’t hesitate to contact us if you have any trouble or questions.

 

Brief MySQL scheduled maintenance February 15, 2020

Update 10:58 PM Pacific time: the maintenance described below has been completed, and all services are running normally.

Between 9:00 PM and 11:59 PM Pacific time on Saturday, February 15, 2020, the MySQL database software on each of our servers will be upgraded from MariaDB version 10.0.41 to 10.0.44 (roughly equivalent to MySQL 5.6.47). This will cause an approximately 60 second interruption of service on each MySQL-using customer website at some point during this period.

This upgrade is necessary for security reasons and to fix bugs in MySQL.

In addition, the web14 server will be restarted during this period for a hardware upgrade, causing an approximately 3-minute additional outage for sites and email on that server only.

We apologize for the inconvenience this causes.

MariaDB / MySQL updated to version 10.1.41; Debian updated to 9.11

We’ve updated the MariaDB / MySQL database software on all our servers to version 10.1.41. This was part of a general update of Debian Linux to version 9.10 and then 9.11.

This upgrade should not be noticeable to our customers in any way, but of course, don’t hesitate to contact us if you have any questions or difficulties.

Brief MySQL scheduled maintenance February 8, 2019 (completed)

Update 9:32 PM Pacific time: the maintenance described below has been completed, and all services are running normally.

Between 9:00 PM and 11:59 PM Pacific time on Friday, February 8, 2019, the MySQL database software on each of our servers will be upgraded from MariaDB version 10.0.37 to 10.0.38 (equivalent to MySQL 5.6.43). This will cause an approximately 60 second interruption of service on each MySQL-using customer website at some point during this period.

This upgrade is necessary for security reasons and to fix bugs in MySQL. We apologize for the inconvenience this causes.

Brief MySQL scheduled maintenance December 1, 2018 for some servers (completed)

Update 11:22 PM Pacific time Dec. 1: The maintenance described below has been completed and all services are running normally.

Between 10:00 PM and 11:59 PM Pacific time on Saturday, December 1, 2018, the MySQL database software on some hosting servers will be updated. This will cause an approximately two minute interruption of service on each MySQL-using customer Web site (including WordPress sites) at some point during this period.

Specifically, this will affect servers ending in digits 0, 1, 2 and 3, such as “web01” and “web10”. (All other servers were previously updated on November 17 or November 24.)

Read the rest of this entry »

Brief MySQL scheduled maintenance November 24, 2018 for some servers (completed)

Update 10:39 PM Pacific time Nov. 24: The maintenance described below has been completed and all services are running normally.

Between 10:00 PM and 11:59 PM Pacific time on Saturday, November 24, 2018, the MySQL database software on some hosting servers will be updated. This will cause an approximately two minute interruption of service on each MySQL-using customer Web site (including WordPress sites) at some point during this period.

Specifically, this will affect servers ending in digits 4, 5 and 6, such as “web04” and “web14”. Servers ending in digits 0-3 are not affected now and will be updated later; servers ending with digits 7-9 were previously updated.

Read the rest of this entry »

Brief MySQL scheduled maintenance November 17, 2018 for some servers (completed)

Update 10:46 PM Pacific time Nov. 17: The maintenance described below has been completed and all services are running normally.

Between 10:00 PM and 11:59 PM Pacific time on Saturday, November 17, 2018, the MySQL database software on some hosting servers will be updated. This will cause an approximately two minute interruption of service on each MySQL-using customer Web site (including WordPress sites) at some point during this period.

Specifically, this will affect servers ending in digits 7, 8 and 9, such as “web07” and “web08”. Servers ending in digits 0-6 are not affected now and will be updated later this month.

Read the rest of this entry »

Brief MySQL scheduled maintenance April 20, 2018 (completed)

Between 9:00 PM and 11:59 PM Pacific time on Friday, April 20, 2018, the MySQL database software on each of our servers will be upgraded from version 5.6.39 to 5.6.40. This will cause an approximately 60 second interruption of service on each MySQL-using customer website at some point during this period.

This upgrade is necessary for security reasons and to fix bugs in MySQL. We apologize for the inconvenience this causes.

Update 9:44 PM Pacific time: The maintenance was completed as planned and all services are running normally.

Brief MySQL scheduled maintenance March 30, 2018 (completed)

Between 9:00 PM and 11:59 PM Pacific time on Friday, March 30, 2018, the MySQL database software on each of our servers will be upgraded from version 5.6.38 to 5.6.39. This will cause an approximately 60 second interruption of service on each MySQL-using customer website at some point during this period.

This upgrade is necessary for security reasons and to fix bugs in MySQL. We apologize for the inconvenience this causes.

Update 9:36 PM Pacific time: The maintenance was completed as planned and all services are running normally.

MySQL “innodb_large_prefix” and “Barracuda” innodb_file_format now supported

Our MySQL database servers now support the innodb_large_prefix option and the “Barracudainnodb_file_format option.

Users should not notice any difference, but this should improve compatibility with a small number of scripts that require these options (notably recent versions of Moodle).

Read the rest of this entry »