Centreon Database

Overview

Centreon Database Plugin Pack will help you set up monitoring for Centreon monitoring database.

Pack Assets

Templates

The Centreon Plugin Pack Centreon Central brings a host template:

App-Monitoring-Centreon-Database-custom

It brings the following service templates:

Service Alias	Service Template	Service Description	Default
Partitioning	App-Centreon-MySQL-Partitioning-custom	Check Centreon Database partitionning	X
Connection-Time	App-DB-MySQL-Connection-Time-custom	Check Centreon Database connection time	X
Connections-Number	App-DB-MySQL-Connections-Number-custom	Check Centreon Database connections number	X
Database-size	App-DB-MySQL-Database-Size-custom	Check Centreon Database size	X
Myisam-Keycache	App-DB-MySQL-Myisam-Keycache-custom	Check Centreon Database partitionning	X
Open-Files	App-DB-MySQL-Open-Files-custom	Check Centreon Database open files	X
Queries	App-DB-MySQL-Queries-custom	Check Centreon Database queries number	X
Slowqueries	App-DB-MySQL-Slowqueries-custom	Check Centreon Database slow queries	X
Swap	OS-Linux-Swap-SNMP-custom	Check swap usage	X
Memory	OS-Linux-Memory-SNMP-custom	Check memory usage	X
Load	OS-Linux-Load-SNMP-custom	Check load	X
Cpu	OS-Linux-Cpu-SNMP-custom	Check Cpu usage	X

Collected metrics & status

Database indicators:

Metric Name	Unit
Partitioning Status	string

Metric name	Unit
Connection time	s

Metric name	Unit
Connections number	count or %

Metric name	Unit
Database size	Bytes or %

Metric name	Unit
Myisam Keycache	%

Metric name	Unit
Open Files	%

Metric name	Unit
Slowqueries	count

Metric name	Unit
Queries	count

System indicators:

CPU
Memory
Swap
Load

Metric name	Unit
cpu.utilization.percentage	%
core.cpu.utilization.percentage	%

Metric name	Unit
memory.usage.bytes	Bytes
memory.free.bytes	Bytes
memory.usage.percentage	%
memory.buffer.bytes	Bytes
memory.cached.bytes	Bytes
memory.shared.bytes	Bytes

Metric name	Unit
swap.usage.bytes	Bytes
swap.free.bytes	Bytes
swap.usage.percentage	%

Metric name	Unit
load1	System load 1 minute-sample
load5	System load 5 minutes-sample
load15	System load 15 minutes-sample

Prerequisites

Creating a database user for Service Partitioning Monitoring

In order to be able to collect the needed information from the database, a database user with specific privileges is required:

CREATE USER 'monitor_user'@'IP_POLLER' IDENTIFIED BY 'a_very_secure_passwd';
GRANT SELECT ON *.* to 'monitor_user'@'IP_POLLER';

SNMP

SNMP must be configured on each poller being monitored. You can refer to this documentation describing how to set up a quick SNMP configuration.

Setup

Online License
Offline License

Install the Centreon Plugin packages on the poller that will monitor Centreon monitoring database:

yum install centreon-plugin-Applications-Monitoring-Centreon-Database centreon-plugin-Operatingsystems-Linux-Snmp

On the Centreon Web interface, install the Centreon Database Centreon Plugin Pack on the Configuration > Plugin Packs page.

Install the Centreon Plugin packages on every poller that will monitor Centreon monitoring database:

yum install centreon-plugin-Applications-Monitoring-Centreon-Database centreon-plugin-Operatingsystems-Linux-Snmp

Install the Centreon Database Plugin Pack RPM on the Centreon Central server:

yum install centreon-pack-applications-monitoring-centreon-database

On the Centreon Web interface, install the Centreon Database Plugin Pack on the Configuration > Plugin Packs page.

Configuration

Host

Log into Centreon and add a new Host through Configuration > Hosts.
Fill the Name, Alias & IP Address/DNS fields according to your Centreon Central server settings.
Select the App-Monitoring-Centreon-Database-custom template to apply to the host.
Once the template is applied, fill in the corresponding macros. Some macros are mandatory.
Values for macros MYSQLUSERNAME and MYSQLPASSWORD are the ones set before when creating the user to monitor the database.

Mandatory	Macro
X	MYSQLPORT
X	MYSQLUSERNAME
X	MYSQLPASSWORD
	SNMPEXTRAOPTIONS

How to check in the CLI that the configuration is OK and what are the main options for?

Once the plugin is installed, log into your Centreon Poller CLI using the centreon-engine user account (su - centreon-engine) and test the Plugin by running the following command:

/usr/lib/centreon/plugins//centreon_mysql.pl \
    --plugin=database::mysql::plugin  \
    --host=localhost   \
    --username='monitor_user' \
    --password='centreon' \
    --port='3306' \
    --mode=threads-connected \
    --warning-usage='' \
    --critical-usage='' \
    --warning-usage-prct='' \
    --critical-usage-prct='' 

The expected command output is shown below:

OK: Client connected threads total: 151 used: 10 (6.62%) free: 141 (93.38%)

All available options for a given mode can be displayed by adding the --help parameter to the command:

/usr/lib/centreon/plugins//centreon_mysql.pl \
    --plugin=database::mysql::plugin  \
    --host=localhost   \
        --help

All available options for a given mode can be displayed by adding the --list-mode parameter to the command:

/usr/lib/centreon/plugins//centreon_mysql.pl \
    --plugin=database::mysql::plugin  \
        --list-mode

Troubleshooting

Please find all the troubleshooting documentation for the Centreon Plugins in the dedicated page

Overview​

Pack Assets​

Templates​

Collected metrics & status​

Prerequisites​

Creating a database user for Service Partitioning Monitoring​

SNMP​

Setup​

Configuration​

Host​

How to check in the CLI that the configuration is OK and what are the main options for?​

Troubleshooting​