Upgrade MariaDB 10.0 to 10.2 for Adobe Commerce on cloud

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.

Check and convert all compact tables to dynamic tables. This is required to avoid potential data loss during the database upgrade.

Check for MYISAM tables. You need to convert all MyISAM tables to InnoD.

After you have prepared the database tables and rows (the previous two steps), create a DB backup using ECE-Tools DB backup commands.

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 Adobe Commerce Help Center User Guide: Track your Tickets in our support knowledge base.
4. The Adobe Commerce support team will begin the MariaDB upgrade process. 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.

Disable maintenance mode. Refer to Enable or disable maintenance mode in our developer documentation.