Monitoring MySQL server through Domotz

MySQL, the most popular Open Source Relational Database Management System, now can be easily monitored through Domotz (using the “Custom Integration” functionality).

The integration enables our users to monitor the MySQL status and metrics from a Linux machine.

Domotz has developed the following two driver codes to extract information from a MySQL Server:

Also, you can find the driver’s code in our examples library. The drivers can be used as they are or be customized to your needs.

You can monitor your MySQL instance running in a Linux server by leveraging the Custom Integration feature.

We’ve created a driver with the following capabilities:

Monitoring the service status and version
Keeping track of the memory usage of the service
Recording key metrics, such as average queries per second served, slow queries, uptime etc.

Thanks to the custom integration feature, with MySQL you will be able to:

To enable the custom integration with MySQL open the WebApp and follow these few steps:

From the left menu, click on "Integration" then on the tab "Custom Integration"
By clicking on “Create a new driver” will open a window where you need to choose the “Driver name” and the “Driver description”.
For example, “MySQL stats” as a Driver name for “mysql.js” (or “MySQL Specs” for mysql_spec.js) and a brief description of the purpose for this integration (e.g. “Extract statistics and specification out of the MySQL Server”).
Copy the content of the mysql.js (or mysql_spec.js) scripts from the example in the Driver code area (the empty space for the code)
Apply the Custom Integration to the Linux machine hosting the MySQL Server

The driver example code to monitor MySQL servers can be found at the link below: