# MariaDB - Upgrade

## **PaaS upgrade workflow** <a href="#redisupgradeinplace-redispaasupgrade" id="redisupgradeinplace-redispaasupgrade"></a>

### Request <a href="#mariadbupgradeinplace-request" id="mariadbupgradeinplace-request"></a>

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 <a href="#mariadbupgradeinplace-process" id="mariadbupgradeinplace-process"></a>

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**

<figure><picture><source srcset="https://835168969-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2F2FXoHyOBZPpJv3UALn4V%2Fuploads%2Fgit-blob-7fed4690f67f3d959b250bc34c2ff511be96a435%2Fmariadb-upgrade-dark-en.png?alt=media" media="(prefers-color-scheme: dark)"><img src="https://835168969-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2F2FXoHyOBZPpJv3UALn4V%2Fuploads%2Fgit-blob-03855897475872c357f04a953930145ae2f76953%2Fmariadb-upgrade-light-en.png?alt=media" alt="" width="563"></picture><figcaption></figcaption></figure>

### 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 <a href="#mariadbupgradeinplace-timereferences" id="mariadbupgradeinplace-timereferences"></a>

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** <a href="#mariadbupgradeinplace-os-mariadbsupportmatrixmatrice" id="mariadbupgradeinplace-os-mariadbsupportmatrixmatrice"></a>

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

<table><thead><tr><th width="258">Versions de MariaDB</th><th>Distribution Linux supportée</th></tr></thead><tbody><tr><td>mariaDB 10.6</td><td>Debian 11</td></tr><tr><td>mariaDB 10.11</td><td>Debian 12</td></tr><tr><td>mariaDB 11.4</td><td>Debian 12</td></tr></tbody></table>

## **Supported mariaDB update paths** <a href="#mariadbupgradeinplace-supportedmariadbupdatepaths" id="mariadbupgradeinplace-supportedmariadbupdatepaths"></a>

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.