ETL Centreon MBI: Configuration

Centreon MBI integrates its own extract, transform, load (ETL) capabilities to:

  • Synchronize raw monitoring data with the reporting server.

  • Calculate availability and performance statistics on the reporting server.

  • Manage data retention on the reporting server.

Before following the next steps, you should have read the best practice parts to ensure that the Centreon objects (e.g., groups and categories) are configured according to Centreon MBI requirements.

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

Options

Values

General options

Reporting engine uses a dedicated MySQL server

Yes. You must use 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 file storage directory on reporting server

Folder where dumps will be stored on the dedicated reporting server (depending on your architecture).

Type of statistics to build

  • Select “Availability only” if you only use availability reports.

  • Select “Performance and capacity only” if you only want to use capacity and performance reports.

  • Select “All” to calculate the statistics for both types of reports.

Use large memory tweaks (store MySQL temporary tables in memory)

Activated only if your MySQL configuration and allocated physical memory on the server permit.

Reporting perimeter selection

Hostgroups

Select only host groups for which you want to aggregate data.

Hostcategories

Select only host categories for which you want to aggregate data.

Service categories

Select only service categories for which you want to aggregate data.

Availability statistic calculation

Live services for availability statistics calculation

Select required time periods.

Performance and capacity statistic calculation

Granularity required for performance data statistics

Select level of granularity required to run the desired performance reports (1).

Live services for performance data statistics calculation

Select required time periods.

Capacity statistic aggregated by month

Live services for capacity statistics calculation

Select the “24x7” time period.

Service categories related to capacity data monitoring

Select the service categories that have been associated with capacity-type services.

Exclude metrics from service categories that do not return capacity USAGE information

Concerns the metrics linked to services which return capacity data. Select the metrics that do not return capacity usage information. but a maximum or total value. (e.g., the metric “size”).

Centile parameters

Calculating centile aggregation by

Select the desired aggregation level. The standard percentile report provided with BI 2.1 uses Month data.

Select service categories to aggregate centile on

Filter on relevant service categories for centile statistics (e.g., Traffic).

First day of the week

Select the first day of the week for Week aggregation.

Centile / Timeperiod combination

Create a new centile/timeperiod combination on which to perform the calculation.

(1) Reports requiring a precise value per hour of performance data are listed below. If you do not use the following reports, disable the statistics calculation per hour:

  • Hostgroup-Host-details-1

  • Host-detail-v2

  • Hostgroup-traffic-Average-Usage-By-Interface

  • Hostgroup-traffic-by-Interface-And-Bandwith-Ranges.