Aller au contenu principal

MySQL/MariaDB

Prerequisites

This chapter describes the prerequisites installation needed by plugins to run.

Centreon Plugin

Install this plugin on each needed poller:

yum install centreon-plugin-Applications-Databases-Mysql

Creating a database user

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

grant usage on *.* to 'centreon'@'pollerip' identified by 'password'

MariaDB, perl-dbi, perl-dbd-mysql

All prerequisites needed to run mysql plugins are packaged and installed with Centreon Entreprise Server: perl-DBI , perl-DBD-mysql , mysql.

Centreon Configuration

Create a new MariaDB server

Go to "Configuration > Hosts" and click "Add". Then, fill the form as shown by the following table :

FieldsValue
Host nameName of the host
AliasHost description
IPHost IP Address
Monitored fromMonitoring Poller to use
Host Multiple TemplatesApp-DB-MySQL-custom

Click "Save" button.

Those services were automatically created for this host:

ServiceDescription
PingMonitor host response time
Connection-TimeMonitor to the connection time to the server
Connections-NumberMonitor the number of open connections
Database-SizeMonitor all the databases size
Innodb-BufferpoolMonitor the InnoDB buffer pool hitrate
Myisam-KeycacheMonitor the MyISAM key cache hitrate
Open-Filespercentage of openned files
QueriesMonitor the average of queries per second
SlowqueriesMonitor the number of slow queries
Optionnal ServiceDescription
UptimeMonitor the server's uptime

Host Macro Configuration

The following macros must be configured on host:

MacroDescriptionDefault valueExample
MYSQLPORTPort used to connect to the DB serverMYSQLPORT3306
MYSQLUSERNAMEthe mysql db userMYSQLUSERNAMEroot
MYSQLPASSWORDthe mysql db user's passwordMYSQLPASSWORDHuGr6834