Setting up database monitoring
Databases are a black hole to a lot of engineers; there's data being written to them and there's something 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
We'll be monitoring our Zabbix database, for convenience. 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 to install a MariaDB instance on a Linux host.
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:
- Let's start by installing the required modules on our server.
RHEL-based systems:
dnf install unixODBC mariadb-connector-odbc
Ubuntu systems:
apt install...