Skip to main content

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