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