ETL Centreon MBI: Execution


Before continuing, be sure that you have installed the MySQL configuration file as specified above in the prerequisites. Configure and activate data retention so that only the required data is imported and calculated.

Rebuilding statistics using historical data

Run the following command on the REPORTING server to:

  • Delete all existing data from the reporting server.
  • Import raw monitoring data from the monitoring server to the reporting server (based on retention parameters).
  • Populate the tables containing the availability statistics for hosts and services.
  • Populate the tables containing the performance and capacity statistics.
/usr/share/centreon-bi/bin/centreonBIETL -r

Activating daily execution (of the script)

Once the rebuild process is finished, you can activate the daily statistic calculation. On the reporting server, edit the file /etc/cron.d/centreon-bi-engine and uncomment the following line:

#30 4 * * * root /usr/share/centreon-bi//bin/centreonBIETL -d >> /var/log/centreon-bi//centreonBIETL.log 2>&1

Restart the service cron::

systemctl restart crond


Make sure that the batch centreonBIETL starts only once the batch eventReportBuilder has finished on the monitoring server (see the cron file * /etc/cron.d/centreon* on the monitoring server).

Centreon MBI installation is now complete!