Monitorizar MySQL or MariaDB database con DumbMonit

Logs in and runs a query: catches a database that is up but no longer answering.

Las descripciones están en inglés, como en el producto. Las etiquetas de la página siguen su idioma.

Qué vigila DumbMonit

Uso habitual. Database: connection and a query you choose

Ejemplos

Qué necesita

Username / passwordA read-only account created for monitoring, never an application one.

Puerto por defecto: 3306

Pasos de configuración: Monitor a MySQL or MariaDB database

In the mysql client, create an account with no privilege (adjust the host part to the DumbMonit machine).
```
CREATE USER 'dumbmonit'@'%' IDENTIFIED BY 'a-long-password';
```
In DumbMonit, enter the server, for example db.home.lan:3307 (port 3306 by default), then the account's user and password.
Optional: replace the default query SELECT 1 with one that returns a single number, to chart it.

Ojo. The check opens a real connection on every poll: on an instance close to its connection limit, give it a longer interval.