Upgrade MariaDB 10.0 to 10.2 for Magento Commerce Cloud

MariaDB 10.0 and 10.1 are end-of-life (EOL). Support ended 31 Mar 2019 and 17 Oct 2020 respectively. This article explains how to upgrade MariaDB from 10.0 to 10.2 or 10.2 to 10.3 or to 10.4, in order to use Magento Commerce Cloud.

MariaDB 10.0 is end-of-life (EOL) and is not supported in current Magento versions. It is best practice to move off any EOL version within 30 days of its EOL.

Affected product and versions

• MariaDB 10.2 is recommended for Magento Commerce Cloud 2.3.x.
• MariaDB 10.4 is recommended for 2.4.x. MariaDB 10.3 is also compatible with Magento Commerce Cloud 2.4.x.

Upgrade steps

To upgrade from MariaDB 10.0 to 10.2 or 10.2 to 10.3 or to 10.4, complete the following steps:

1. Create a DB backup using ECE-Tools DB backup commands. This must be done before steps 2 and 3 in case something goes wrong while updating tables/rows.
2. Check and convert all compact tables to dynamic tables. This is required to avoid potential data loss during the database upgrade.
3. Check for MYISAM tables. You need to convert all MyISAM tables to InnoD. 
   
4. After you have prepared the database tables and rows (the previous two steps), create a DB backup using ECE-Tools DB backup commands. 
5. Open a support ticket to schedule the upgrade from MariaDB 10.0 to 10.2 or 10.2 to 10.3 or 10.4. In the ticket detail the date and time when you want the DB upgraded. The support team needs 48 hours' notice and the merchants dev team needs to be available. Once the time and date are agreed for the upgrade do the following:
   1. Put your site into maintenance mode, and stop any DB activities, e.g., crons.
   2. Create a DB backup using ECE-Tools DB backup commands.
   3. Let support know you have completed the backup. Do this via your support ticket. To get steps for viewing and tracking your tickets, refer to Magento Help Center User Guide: Track your Tickets.
   4. The Magento support team will begin the MariaDB upgrade process.
6. If all the above steps have been taken, and the database is average size, this can be done in about an hour. Larger DBs will take longer. You will be informed via your ticket once the upgrade is complete.
7. Disable maintenance mode. Refer to DevDocs Enable or disable maintenance mode.

Related Reading

To learn more about requirements for Magento 2.4.x, refer to Magento DevDocs Magento 2.4 system requirements > Database.