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.
When you upgrade from one major version of Centreon to another, you must:
- Upgrade Centreon (packages, web installation, deploying the configuration).
- 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
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).
Stop the mariadb service:
systemctl stop mariadb
Uninstall the current version:
rpm --erase --nodeps --verbose MariaDB-server MariaDB-client MariaDB-shared MariaDB-compat MariaDB-common
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\*
Start the mariadb service:
systemctl start mariadb
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
mysql_upgrade -u root -p
Refer to the official documentation for more information or if errors occur during this last step.
To enable MariaDB on startup, execute the following command:
systemctl enable mariadb
Upgrading from 10.1 to 10.5
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) :
Update MariaDB :
yum update mariadb-*
Restart MariaDB :