Page MenuHomeSoftware Heritage

Schedule a MySQL upgrade on our Gandi simple hosting instance
Closed, MigratedEdits Locked

Description

Our WordPress website is powered by an outdated MySQL version (5.5).

WordPress recommends a minimum version of 5.6 for MySQL.

Using this outdated MySQL is currently a blocker for properly installing the Give WordPress plugin
to enhance our donation form due to a database migration issue (CURRENT_TIMESTAMP
is only avaible since MySQL 5.6.5).

[30-Mar-2021 09:40:30 UTC] WordPress database error Invalid default value for 'last_run' for query CREATE TABLE wp_give_migrations (
			id VARCHAR(180) NOT NULL,
			status VARCHAR(16) NOT NULL,
			error text NULL,
			last_run DATETIME NOT NULL DEFAULT CURRENT_TIMESTAMP,
			PRIMARY KEY  (id)
		) DEFAULT CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci made by do_action('admin_init'), WP_Hook->do_action, WP_Hook->apply_filters, Give\Helpers\Hooks::Give\Helpers\{closure}, call_user_func_array, Give\Framework\Migrations\MigrationsRunner->run, Give\MigrationLog\Migrations\CreateMigrationsTable->run, Give\Framework\Database\DB::delta, Give\Framework\Database\DB::runQueryWithErrorChecking, Give\Framework\Database\DB::Give\Framework\Database\{closure}, dbDelta

I already contact Gandi support a couple of months ago on that subject and got the following answer:

Gandi support can upgrade MySQL to version 5.7. Please confirm via reply you have a taken a recent backup of your website files and databases as a precautionary measure. Expect around 30 minutes of downtime for the upgrade to be completed. So if there is a specific time-frame you'd like this upgrade to occur, let us know and we'll try to accommodate as best we can.

I will ping them back to schedule that upgrade.

Event Timeline

anlambert created this task.

Gandi support has been contacted, MySQL will be upgraded to 8.0 later today.

Website will be down for around 30 min during the maintenance.

Hello Antoine,

Thank you for your message.

We can proceed with the upgrade later today if you'd like. Kindly confirm if this is OK. Expect the websites to be down for around ~30 minutes during the upgrade process.

Also, we now provide MySQL 8.0 as well, if you'd prefer to upgrade to that version, let us know.

Kind regards,

--
\o/ Richard
 G https://www.gandi.net/

MySQL has been successfully upgrade to 8.0 and website is now back up and working.

Hello Antoine,

The upgrade to MySQL 8.0 went smoothly. Your websites are back online now.

Kind regards,

--
\o/ Richard
 G https://www.gandi.net/