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:
- Upgrade Centreon (packages, web installation, deploying the configuration).
- 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
Centreon | MariaDB |
---|---|
24.04 | 10.11 |
23.10 | 10.5 |
23.04 | 10.5 |
22.10 | 10.5 |
22.04 | 10.5 |
21.10 | 10.5 |
21.04 | 10.5 |
20.10 | 10.3.x |
20.04 | 10.3.x |
19.10 | 10.1.x |
Knowing your version of MariaDB
To find out which version of MariaDB is installed on your machine, enter the following command:
- Alma / RHEL / Oracle Linux 8
- Alma / RHEL / Oracle Linux 9
- Debian 11 & 12
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
rpm -qa |grep MariaDB
The results should look like this:
MariaDB-client-10.5.8-1.el9.centos.x86_64
MariaDB-server-10.5.8-1.el9.centos.x86_64
MariaDB-common-10.5.8-1.el9.centos.x86_64
MariaDB-shared-10.5.8-1.el9.centos.x86_64
MariaDB-compat-10.5.8-1.el9.centos.x86_64
dpkg -l |grep MariaDB
The results should look like this:
ii libdbd-mysql-perl:amd64 4.050-3+b1 amd64 Perl5 database interface to the MariaDB/MySQL database
ii libmariadb3:amd64 1:10.5.17+maria~deb11 amd64 MariaDB database client library
ii mariadb-client-10.5 1:10.5.17+maria~deb11 amd64 MariaDB database client binaries
ii mariadb-client-core-10.5 1:10.5.17+maria~deb11 amd64 MariaDB database core client binaries
ii mariadb-common 1:10.5.17+maria~deb11 all MariaDB common configuration files
ii mariadb-server 1:10.5.17+maria~deb11 all MariaDB database server (metapackage depending on the latest version)
ii mariadb-server-10.5 1:10.5.17+maria~deb11 amd64 MariaDB database server binaries
ii mariadb-server-core-10.5 1:10.5.17+maria~deb11 amd64 MariaDB database core server files
ii mysql-common 1:10.5.17+maria~deb11 all MariaDB database common files (e.g. /etc/mysql/my.cnf)
Upgrading between major MariaDB versions
You must uninstall then reinstall MariaDB to upgrade between major versions (for example to switch from version 10.5 to version 10.11).
Stop the MariaDB service:
systemctl stop mariadb
Uninstall the current version:
- Alma / RHEL / Oracle Linux 8
- Alma / RHEL / Oracle Linux 9
- Debian 11 & 12
rpm --erase --nodeps --verbose MariaDB-server MariaDB-client MariaDB-shared MariaDB-compat MariaDB-common
rpm --erase --nodeps --verbose MariaDB-server MariaDB-client MariaDB-shared MariaDB-compat MariaDB-common
At the Knowing your version of MariaDB step, the grep command returned the precise version of MariaDB you have.
- If the results of the grep command included “10.5”, your uninstallation command must include it too, like in the following example:
dpkg -r --ignore-depends=mariadb-server,mariadb-client,mariadb-shared,mariadb-compat,mariadb-common mariadb-server mariadb-server-10.5 mariadb-client mariadb-client-10.5 mariadb-client-core-10.5 mariadb-common mariadb-server-core-10.5 mysql-common
- If the results of the grep command did not include “10.5”, use the following command:
dpkg -r --ignore-depends=mariadb-server,mariadb-client,mariadb-shared,mariadb-compat,mariadb-common mariadb-server mariadb-server mariadb-client mariadb-client mariadb-client-core mariadb-common mariadb-server-core mysql-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.
- Install version 10.11:
- Alma / RHEL / Oracle Linux 8
- Alma / RHEL / Oracle Linux 9
- Debian 11
- Debian 12
dnf install MariaDB-server-10.11\* MariaDB-client-10.11\* MariaDB-shared-10.11\* MariaDB-compat-10.11\* MariaDB-common-10.11\*
dnf install MariaDB-server-10.11\* MariaDB-client-10.11\* MariaDB-shared-10.11\* MariaDB-compat-10.11\* MariaDB-common-10.11\*
curl -LsS https://r.mariadb.com/downloads/mariadb_repo_setup | sudo bash -s -- --os-type=debian --os-version=11 --mariadb-server-version="mariadb-10.11"
sudo apt-get install mariadb-server galera-4 mariadb-client libmariadb3 mariadb-backup mariadb-common
If an error message informs you that one or several MariaDB packages are missing, you will need to specify the missing packages in the command, like in the following example:
sudo apt-get install mariadb-server galera-4 mariadb-client libmariadb3 mariadb-backup mariadb-common MISSING-PACKAGE_A MISSING-PACKAGE_B
curl -LsS https://r.mariadb.com/downloads/mariadb_repo_setup | sudo bash -s -- --os-type=debian --os-version=12 --mariadb-server-version="mariadb-10.11"
sudo apt-get install mariadb-server galera-4 mariadb-client libmariadb3 mariadb-backup mariadb-common
If an error message informs you that one or several MariaDB packages are missing, you will need to specify the missing packages in the command, like in the following example:
sudo apt-get install mariadb-server galera-4 mariadb-client libmariadb3 mariadb-backup mariadb-common MISSING-PACKAGE_A MISSING-PACKAGE_B
Start the MariaDB service:
systemctl start mariadb
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.
To enable MariaDB on startup, execute the following command:
systemctl enable mariadb
Upgrading from 10.1 to a more recent version
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):
- Update MariaDB:
- Alma / RHEL / Oracle Linux 8
- Alma / RHEL / Oracle Linux 9
- Debian 11 & 12
dnf update MariaDB-*
dnf update MariaDB-*
apt update MariaDB-*
Restart MariaDB:
systemctl restart mariadb