Skip to main content
Version: ⭐ 22.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 version 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: https://mariadb.com/kb/en/upgrading-between-major-mariadb-versions/

Version of Maria DB for each version of Centreon​

CentreonMariaDB
22.0410.5
21.1010.5
21.0410.5
20.1010.3.x
20.0410.3.x
19.1010.1.x

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:

MariaDB-client-10.5.8-1.el7.centos.x86_64
MariaDB-server-10.5.8-1.el7.centos.x86_64
MariaDB-common-10.5.8-1.el7.centos.x86_64
MariaDB-shared-10.5.8-1.el7.centos.x86_64
MariaDB-compat-10.5.8-1.el7.centos.x86_64

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:

    mysql_upgrade

    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
#
[server]
innodb_file_per_table=1

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
-#innodb_additional_mem_pool_size=512M
#innodb_buffer_pool_size=512M

# For 8 Go Ram
-#innodb_additional_mem_pool_size=1G
#innodb_buffer_pool_size=1G

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