Databases partitioning

Overview

Centreon Partitioning module is integrated to Centreon Web, features and advantages are:

  • It allows you to partition MariaDB table according to data date. Giving optimization of request execution time.

  • Data purge is improved, it’s now just needed to delete old partitions.

  • Extent of MariaDB crash are limited. Only needed to rebuild concerned partitions.

  • Existent partitions can be partitioned

Note

There are some limitations: - Maximum number of partitions (for a MariaDB table) is 1024 - Foreign keys are not supported

Since Centreon Web 2.8.0 version, tables logs, data_bin, log_archive_host and log_archive_service are partitioned during installation.

More details about MariaDB partitioning here.

Prerequisites

The following packages are required:

  • php-mysql

  • Pear-DB

  • MariaDB (>= 10.1)

MariaDB open_files_limit parameter must be set to 32000 in [server] section :

[server]
open_files_limit = 32000

Note

If you install Centreon via the dedicated ISO, this parameter is already configured. If you do it on your RedHat or CentOS Linux version, you will be able to do it manually. Don’t forget to restart mariadb processes if you change this value in my.cnf.

If you use systemd, you need to create file “/etc/systemd/system/mariadb.service.d/mariadb.conf” :

[Service]
LimitNOFILE=32000

Then reload systemd and MariaDB :

$ systemctl daemon-reload
$ systemctl restart mariadb

Contents: