ETL Centreon MBI : ConfigurationΒΆ

Centreon MBI integrates its own ETL capabilities to:

  • Synchronize monitoring raw data with the reporting server
  • Calculate availability and performance statistics on the reporting server
  • Manage the data retention on the reporting server

Before following the next steps, we consider that you have read the best practice parts of the installation that give advices about the configuration (groups, categories etc..) that must be done in Centreon before launching the statistics calculation.

In the menu “Reporting > Business Intelligence > General Options > ETL options” of Centreon, specify the following options:

Options Values
General options  
Reporting engine uses a dedicated MySQL server Yes. You must have a dedicated reporting server
Compatibility mode to use report templates from version of Centreon MBI prior to 1.5.0 No (concerns only the upgrade from prior versions of Centreon MBI)
Temporary files storage directory on reporting server Folder where the dumps will be stored on the dedicated reporting server (depending on your architecture)
Type of statistics to build
  • Select “Availability only” if you use only the availability reports.
  • Select “Performance and capacity only” if you only want to use reports capacity and performance
  • Select “All” to calculate the statistics for the two types of reports.
Use large memory tweaks (store MySQL temporary tables in memory) No
Reporting perimeter selection  
Host groups Select only host group that you want to agregate data on.
Host categories Select only host categories that you want to agregate data on.
Service categories Select only service categories that you want to agregate data on.
Availability statistic calculation  
Live services for availability statistics calculation Select needed time periods
Performance and capacity statistic calculation  
Granularity required for performance data statistics Select the level of granularity required to run performance reports you want (1)
Live services for performance data statistics calculation Select needed time periods
Capacity statistic agregated by month  
Live services for capacity statistics calculation Select the “24x7” time period
Service categories related to capacity data monitoring Select the services categories that have been associated with capacity type services
Exclude metrics from service categories that does not return a capacity USAGE information Concern the metrics linked to services which return capacity data. Select the metrics that don’t return a capacity usage information, but returns a maximum or a total value. (example: the metric “size”)
Centile parameters  
Calculating centile agregation by Select the agregation level that you want. The standard percentile report provided with BI 2.1 uses Month data
Select service categories to agregate centile on Filter on relevant service categories for centile statistics (Ex: Traffic)
First day of the week Select the first day of the week to consider for Week agregation.
Centile / Timeperiod combination Create new centile/timeperiod combination on which the calculation will be dones

(1) The reports that needs a precision per hour of the performance data are those listed below. If you don’t use these reports, disable the statistics calculation by hour:

  • Hotsgroup-Host-details-1
  • Host-detail-v2
  • Hostgroup-traffic-Average-Usage-By-Interface
  • Hostgroup-traffic-by-Interface-And-Bandwith-Ranges