Install MySQL dashboards and alerts

In this milestone, you install the pre-built MySQL dashboards and alert rules that come with the integration. These provide immediate visibility into your MySQL database performance and automated notifications for critical issues.

The MySQL integration includes 2 pre-built dashboards and 15 useful alert rules that cover essential monitoring scenarios such as database connectivity, replication status, performance bottlenecks, and resource utilization.

To install the MySQL dashboards and alerts, complete the following steps:

1. On the MySQL integration page in Grafana Cloud, scroll to the Install dashboards and alerts section.

2. Click the Install button to add the pre-built dashboards and alerts to your Grafana Cloud instance.

3. Wait for the installation to complete.

   You’ll see a confirmation message when the dashboards and alerts are successfully installed.

4. Navigate to Dashboards in your Grafana Cloud instance to view the installed MySQL dashboards:

   • MySQL: Overview dashboard with key performance metrics
   • MySQL logs: Log analysis dashboard for troubleshooting

5. Navigate to Alerting > Alert rules to view the installed MySQL alert rules.

6. Review the alert rules to understand what conditions trigger notifications:

   • MySQLDown: Critical alert when MySQL is not up
   • MySQLGaleraDonorFallingBehind: Warning when XtraDB cluster donor node is falling behind
   • MySQLGaleraNotReady: Warning when Galera cluster node is not ready
   • MySQLGaleraOutOfSync: Warning when Galera cluster node is out of sync
   • MySQLHeartbeatLag: Critical alert when MySQL heartbeat is lagging
   • MySQLInnoDBLogWaits: Warning when MySQL InnoDB log writes are stalling
   • MySQLInsufficientBinLogCacheSize: Warning when MySQL binary log cache size is insufficient
   • MySQLInsufficientBinLogStmtCacheSize: Warning when MySQL binary log statement cache size is insufficient
   • MySQLInsufficientTempTableSize: Warning when MySQL temp table size is insufficient
   • MySQLReplicationLag: Critical alert when MySQL slave replication is lagging
   • MySQLReplicationNotRunning: Critical alert when replication is not running
   • MySQLRestarted: Critical alert when MySQL has restarted
   • MySQLSlaveBehindMaster: Warning when MySQL InnoDB slave is behind master
   • MySQLSlowQueries: Warning when MySQL slow queries are detected
   • MySQLTuneThreadCacheSize: Warning when MySQL thread cache needs tuning

The pre-built dashboards and alerts are configured and ready to monitor your MySQL database. You can customize them to match your specific monitoring requirements.

In the next milestone, you explore the MySQL dashboards to understand the monitoring insights they provide.