MariaDB/MySQL health monitoring

General
,
1

**CMK version:**2.3.0p2
**OS version:**Ubuntu 22.04.5 LTS

Hey guys,
how do you monitor the health of mariadb/mysql databases with checkmk?
So I deployed the mysql-plugin on my servers but I don’t get any info if a database is corrupted or something like that, correct? Are there any ways to check that as well or do I have to adjust the mysql plugin?

Thanks & BR,
n3m0

2

How would you detect that a database is corrupted?

3

Hey Robert,
there is a tool from mysql to check databases and/or tables:
https://dev.mysql.com/doc/refman/8.4/en/mysqlcheck.html

4

Yes, but this is not something you would want to run every minute on your DB server.

You could create a local check that runs every hour or even less that uses mysqlcheck and its output.

5

Okay, I thought maybe there is an inbuilt check for health checks.
Thanks for your help!