Database upgrade

Scheduled Maintenance Report for Simplero

Postmortem

The total downtime was 2 bouts of about 3 minutes each, for each of the upgrades to first MariaDB 10.1 then 10.2.

The upgrade to PostgreSQL 10 from version 9 had no downtime, because we only use PostgreSQL for logging, and we’ve engineered our system such that a downtime for PostgreSQL doesn’t result in an outage of the Simplero application.

All went well. When MariaDB 10.3 and PostgreSQL 11 are available, we’ll probably upgrade to those sooner.

Posted Aug 04, 2018 - 11:57 EDT

Completed

The scheduled maintenance has been completed.

Posted Aug 04, 2018 - 11:00 EDT

Update

MariaDB upgrade has completed. We're now at 10.2 and everything's running smoothly.

PostgreSQL upgrade is next...

Posted Aug 04, 2018 - 10:15 EDT

Update

The upgrade from MariaDB 10.0 to 10.1 is complete. Looks like we had about 2-3 minutes of actual downtime, though the process as a whole took about 35 minutes.

I've now started the upgrade to MariaDB 10.2, which completes that part of the process.

I'm going to also upgrade our PostgreSQL installation from 9.x to 10.x now that we're at it.

Posted Aug 04, 2018 - 09:57 EDT

In progress

Scheduled maintenance is currently in progress. We will provide updates as necessary.

Posted Aug 04, 2018 - 09:00 EDT

Scheduled

We're upgrading our database to the latest version. I don't expect much of a downtime, or many complications, but better safe than sorry, you know?

Posted Jul 27, 2018 - 14:14 EDT

This scheduled maintenance affected: Web interface and API and Background processing.