Skip to main content
Version: 21.04

Upgrading MariaDB

You may have several MariaDB databases in your architecture. The central server has a database, each remote server has a database, and the MBI and MAP modules each have a dedicated database. Within your architecture, all databases must have the same verison of MariaDB.

Upgrading process​

When you upgrade from one major version of Centreon to another, you must:

  1. Upgrade Centreon (packages, web installation, deploying the configuration).
  2. Upgrade MariaDB.

Refer to the official MariaDB documentation to know more about this process:

Version of Maria DB for each version of Centreon​


Knowing your version of MariaDB​

To know which version of MariaDB is installed on your machine, enter the following command:

rpm -qa |grep MariaDB

The results should look like this:


Upgrading between major MariaDB versions​

You have to uninstall then reinstall MariaDB to upgrade between major versions (for example to switch from version 10.4 to version 10.5).

  1. Stop the mariadb service:

    systemctl stop mariadb
  2. Uninstall the current version:

    rpm --erase --nodeps --verbose MariaDB-server MariaDB-client MariaDB-shared MariaDB-compat MariaDB-common
  3. Install the 10.5 version:

    yum install MariaDB-server-10.5\* MariaDB-client-10.5\* MariaDB-shared-10.5\* MariaDB-compat-10.5\* MariaDB-common-10.5\*
  4. Start the mariadb service:

    systemctl start mariadb
  5. Launch the MariaDB upgrade process:


    If your database is password-protected, enter:

    mysql_upgrade -u <database_admin_user> -p

    Example: if your database_admin_user is root, enter:

    mysql_upgrade -u root -p

    Refer to the official documentation for more information or if errors occur during this last step.

  6. To enable MariaDB on startup, execute the following command:

    systemctl enable mariadb

Upgrading from 10.1 to 10.5​

The innodb_additional_mem_pool_size parameter has been removed since MariaDB 10.2, so you should remove it from file /etc/my.cnf.d/centreon.cnf

# Custom MySQL/MariaDB server configuration for Centreon

open_files_limit = 32000

key_buffer_size = 256M
sort_buffer_size = 32M
join_buffer_size = 4M
thread_cache_size = 64
read_buffer_size = 512K
read_rnd_buffer_size = 256K
max_allowed_packet = 8M

# For 4 Go Ram

# For 8 Go Ram

Upgrading between minor versions of MariaDB​

Follow these steps to upgrade between minor versions of MariaDBB (for example, to switch from version 10.3.2 to version 10.3.5) :

  1. Update MariaDB :

    yum update mariadb-*
  2. Restart MariaDB :

    restart mariadb