Skip to main content
Version: 23.10

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 for more information about this process: https://mariadb.com/kb/en/upgrading-between-major-mariadb-versions/

Version of Maria DB for each version of Centreon

CentreonMariaDB
23.1010.5
23.0410.5
22.1010.5
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 find out 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.el8.centos.x86_64
MariaDB-server-10.5.8-1.el8.centos.x86_64
MariaDB-common-10.5.8-1.el8.centos.x86_64
MariaDB-shared-10.5.8-1.el8.centos.x86_64
MariaDB-compat-10.5.8-1.el8.centos.x86_64

Upgrading between major MariaDB versions

You must 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

During this uninstallation step, you may encounter an error because one or several MariaDB packages are missing. In that case, you should execute the uninstallation command without including the missing package.

For instance, you get the following error message:

package MariaDB-compat is not installed

As MariaDB-compat is the missing package, please execute the same command without quoting MariaDB-compat:

rpm --erase --nodeps --verbose MariaDB-server MariaDB-client MariaDB-shared MariaDB-common

Make sure you have installed the official MariaDB repository before you continue the procedure.

  1. Install the 10.5 version:
dnf install MariaDB-server-10.5\* MariaDB-client-10.5\* MariaDB-shared-10.5\* MariaDB-compat-10.5\* MariaDB-common-10.5\*
  1. Start the MariaDB service:

    systemctl start mariadb
  2. 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.

  3. 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 MariaDB (for example, to switch from version 10.3.2 to version 10.3.5):

  1. Update MariaDB:
dnf update MariaDB-*
  1. Restart MariaDB:

    systemctl restart mariadb