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…
Make sure you have the packages installed for ODBC on our CentOS / Red Hat; it can be done by installing the
unixODBCpackages.# yum install unixODBC -y # yum install unixODBC-devel -y (if you need sources to compile)
Next, we need a proper connector for our database. In our case the database is MySQL. If you have another database, look for the specific connector for your database:
# yum install mysql-connector-odbcNext we need to configure the
odbcinst...
