Setting up database monitoring

Databases are a black hole to a lot of engineers; data is being written to them and something is being done with this data. But what if you want to know more about the health of your database? That’s where Zabbix database monitoring comes in – we can use it to monitor the health of our database.

Getting ready

For convenience, in this recipe, we’ll be monitoring our Zabbix database. This means that all we are going to need is our installed Zabbix server with our database on it. We’ll be using MariaDB in this example, so if you have a PostgreSQL setup, make sure you install a MariaDB instance on a Linux host (although the same kind of setup could be created on PostgreSQL if you change some of the ODBC parameters).

How to do it…

Before getting started with the item configuration, we’ll have to do some stuff on the CLI side of the server:

1. Let’s start by installing the required modules on...