Database monitoring

In Zabbix when we want to monitor some database, it is possible to do this by making use of the Open Database Connectivity (ODBC) software. ODBC is kind of a software sitting between the DBMS and the application (in our case Zabbix). Zabbix can query any database, which is supported by unixODBC or Independent Open DataBase Connectivity (iODBC).

Getting ready

We need of course, our Zabbix server setup. If you have compiled the server then you need to make sure that it was compiled with the option --with-unixODBC.

How to do it…

  1. Make sure you have the packages installed for ODBC on our CentOS / Red Hat; it can be done by installing the unixODBC packages.
    # yum install unixODBC  -y
    # yum install unixODBC-devel -y (if you need sources ...

Get Zabbix Cookbook now with O’Reilly online learning.

O’Reilly members experience live online training, plus books, videos, and digital content from 200+ publishers.