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.

Start Your Free Trial
Domotz + MySQL Integration

checkiconMonitor your MySQL instance

checkiconMonitor the service status and version

checkiconRecord key metrics: average queries per second served, slow queries, uptime and more

checkiconKeep track of the memory used by the service

Easily monitor MySQL key metrics

MySql Server Detail

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.

Device driver variable history

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

  • Check the history of a specific variable (like “used RAM”)
  • Identify significant changes and make proactive decisions
  • Have an historical view of the data varying from 1 day, 7 days, up to 1 month

How to enable the integration with MySQL

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

  1. From the left menu, click on "Integration" then on the tab "Custom Integration"
  2. 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”).
  3. 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)
  4. 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:

Want to learn more about how to set up the MySQL integration with Domotz?

Ready to get started with Domotz?

  • Powerful
  • Automated
  • Simple
  • Affordable
Start Your Free Trial Contact Sales