MariaDB - Upgrade

PaaS upgrade workflow

Request

The update of a mariaDB PaaS is the responsibility of cegedim.cloud and can be requested via a request ticket submitted from ITCare, specifying a time slot for the operation.

Please specify if the operation is to be carried out outside of business hours in order to plan an RFC.

It is recommended that you upgrade your non-production environments first in order to estimate the downtime generated by the operation and to test your applications using the new engine version.

Process

The upgrade of a mariaDB deployment (single-instance or Galera Cluster) takes place in two fully automated steps:

• Update the Operating system first if required

  • Multiple updates depending on the scenario: Debian 10 → Debian 11 -> Debian 12

• Update of the mariaDB engine in the target version

Depending on the source and target versions of mariaDB, it may be necessary to first migrate the operating system to a version supported by cegedim.cloud

Impacts

• The duration of an update is variable depending on:

  • The configured cpu and ram resources

  • The amount of data whose headers must be modified by the mariaDB engine.

  • The amount of data to be reindexed following the change of C library, after an OS update (Debian).

• The backup mode:

  • Point-in-time Recovery (PITR) from Rubrik Software.

Time references

As an average guideline, durations for each steps of an upgrade in place of a 10 GB database (standalone):

• Debian upgrade: 10 minutes on average

• mariaDB updated: 5 minutes on average

As an average guideline, durations for each steps of an upgrade in place of a 10 GB database (Cluster Galera):

• Debian upgrade: 10 minutes on average

• mariaDB updated: 5 minutes on average

OS / mariaDB support matrix

Linux distributions supported by cegedim.cloud depending on the mariaDB version:

Versions de MariaDB	Distribution Linux supportée
mariaDB 10.6	Debian 11
mariaDB 10.11	Debian 12
mariaDB 11.4	Debian 12

Supported mariaDB update paths

If the operating system is updated, it may require a complete reindexing (also handled by cegedim.cloud) due to changes in the C library when the operating system is updated.

Depending on the amount of data, this operation may take some time.