MariaDB server upgrade

July 27, 2017

We are excited to announce the upgrade to MariaDB version 10 will occur during the August 7th compute grid maintenance window. As a reminder, the grid maintenance window is from 8am to noon.

This upgrade will provide a number of benefits to our users, in the form of optimizations, bug fixes, and new engines. The optimizations will result in faster queries for both simple queries and more advanced queries that incorporate ordering or unions. The new engine choices will open new possibilities with regards to workflow, such as moving your text-searches into MariaDB with Mroonga (https://mariadb.com/kb/en/mariadb/mroonga/).

MariaDB v10 also includes two fundamental updates. Firstly, you will be able to define multiple triggers on an event (https://mariadb.com/kb/en/mariadb/trigger-overview/). Secondly, you will be able to use WITH in your SQL queries (https://mariadb.com/kb/en/mariadb/with/).

We had asked our users not to change their passwords for security considerations. Once the upgrade has completed, you will be allowed to change your password. Please note that your password will have to be at least 12 characters long, with at least 1 digit, 1 lowercase letter, 1 uppercase letter, and 1 character that is neither a letter nor digit (e.g. #).

Please contact us at 617-495-6100 or research@hbs.edu with any questions or concerns regarding this upgrade.