Skip to main content

Alignak checks pack for mysql/mariadb database server

Project description

Checks pack for monitoring mysql database server

Most recent PyPi version Join the chat #alignak on License AGPL v3


The installation of this checks pack will copy some configuration files in the Alignak default configuration directory (eg. /usr/local/share/alignak). The copied files are located in the default sub-directory used for the packs (eg. arbiter/packs).

From PyPI

To install the package from PyPI:

sudo pip install alignak-checks-mysql

From source files

To install the package from the source files:

git clone
cd alignak-checks-linux-mysql
sudo pip install .

Note: using `sudo python install` will not correctly manage the package configuration files! The recommended way is really to use `pip`;)


This checks pack is using the some PERL plugins that are shipped with the checks pack. As such, some more installation and preparation are necessary;)


Note: this pack embeds the check_mysql_health script from The embedded version is built from the 2.2.2 version but you may install this script by yourself …

We recommand that you download and install your own available from the web site. An abstract:

$ tar xvfz check_mysql_health-2.2.2
$ cd check_mysql_health-2.2.2
$ ./configure --prefix=/usr/local/var/libexec/alignak --with-nagios-user=alignak --with-nagios-group=alignak --with-mymodules-dir=/usr/local/var/libexec/alignak --with-mymodules-dyn-dir=/usr/local/var/libexec/alignak
$ make

$ make install

Note: replace /usr/local/var/libexec/alignak according to your platform …

After compilation and installation, the plugin is installed in the /usr/local/var/libexec/alignak directory.

Edit the /usr/local/etc/alignak/arbiter/packs/resource.d/mysql.cfg file and configure the credentials to access to the mysql server.

#-- MySQL default credentials

Install PERL dependencies for check_mysql_health plugin

You must install some PERL dependencies for the check_mysql_health script.

Before installing PERL dependencies, you must install the mysql/mariadb client for your operating system.

On FreeBSD, you can:

pkg install mariadb102-client
cpan install DBI
cpan install DBD::mysql

On some Linux distros, you can:

su -
apt-get install mariadb-client
apt-get install dbi-perl
apt-get install dbd-mysql-perl

Or you can use the PERL cpan utility:

cpan install DBI
cpan install DBD::mysql

Note: you must have previously installed the mysql client for your operating system :)

Alignak configuration

You simply have to tag the concerned hosts with the template mysql.:

define host{
    use                     mysql
    host_name               my_server

Set the MySql connection credentials in the resource.d/mysql.cfg or declare the variables in each host.:

#-- MySQL default credentials

The main mysql template declares macros used to configure the launched checks. The default values of these macros listed hereunder can be overriden in each host configuration.:

_MYSQLUSER                      $MYSQLUSER$

_UPTIME_WARN                               10:
_UPTIME_CRIT                               5:
_QCACHEHITRATE_WARN             90:
_QCACHEHITRATE_CRIT             80:
_LOGWAITS_WARN                   1
_LOGWAITS_CRIT                  10
_INDEXUSAGE_WARN                90:
_INDEXUSAGE_CRIT                80:
_TMPDISKTABLES_WARN             25
_TMPDISKTABLES_CRIT             50
_SLOWQUERIES_WARN               0.1
_SLOWQUERIES_CRIT                1
_OPENFILES_WARN                 80
_OPENFILES_CRIT                 95

To set a specific value for an host, declare the same macro in the host definition file.:

define host{
   use                     mysql
   contact_groups          admins
   host_name               my_host

   # Specific values for this host
   _MYSQLUSER              root
   _MYSQLPASSWORD          root_pwd

Bugs, issues and contributing

Contributions to this project are welcome and encouraged … issues in the project repository are the common way to raise an information.

Project details

Download files

Download the file for your platform. If you're not sure which to choose, learn more about installing packages.

Files for alignak_checks_mysql, version 1.2.2
Filename, size File type Python version Upload date Hashes
Filename, size alignak_checks_mysql-1.2.2-py2-none-any.whl (49.3 kB) File type Wheel Python version py2 Upload date Hashes View
Filename, size alignak_checks_mysql-1.2.2.tar.gz (48.1 kB) File type Source Python version None Upload date Hashes View

Supported by

Pingdom Pingdom Monitoring Google Google Object Storage and Download Analytics Sentry Sentry Error logging AWS AWS Cloud computing DataDog DataDog Monitoring Fastly Fastly CDN DigiCert DigiCert EV certificate StatusPage StatusPage Status page