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 the O’Reilly learning platform.

O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.

Start your free trial