ContextQMD
Back to Grafana

MySQL data source

docs/sources/datasources/mysql/_index.md

13.0.14.2 KB
Original Source

MySQL data source

Grafana ships with built-in support for MySQL. You can query and visualize data from MySQL-compatible databases like MariaDB or Percona Server.

Use this data source to create dashboards, explore SQL data, and monitor MySQL-based workloads in real time.

Watch this video to learn more about using the Grafana MySQL data source plugin: {{< youtube id="p_RDHfHS-P8">}}

{{< docs/play title="MySQL Overview" url="https://play.grafana.org/d/edyh1ib7db6rkb/mysql-overview" >}}

Supported databases

This data source supports the following MySQL-compatible databases:

  • MySQL 5.7 and newer
  • MariaDB 10.2 and newer
  • Percona Server 5.7 and newer
  • Amazon Aurora MySQL
  • Azure Database for MySQL
  • Google Cloud SQL for MySQL

Grafana recommends using the latest available version for your database for optimal compatibility.

Key capabilities

The MySQL data source supports:

  • Time series queries: Visualize metrics over time using built-in time grouping macros.
  • Table queries: Display query results in table format for any valid SQL query.
  • Template variables: Create dynamic dashboards with variable-driven queries.
  • Annotations: Overlay events from MySQL on your dashboard graphs.
  • Alerting: Create alerts based on MySQL query results.
  • Macros: Simplify queries with built-in macros for time filtering and grouping.

Get started

The following documentation helps you get started with the MySQL data source:

Additional resources

After configuring the MySQL data source, you can also:

Pre-configured dashboards

If you want to monitor your MySQL server's performance metrics (connections, queries, replication, and more), Grafana provides pre-configured dashboards through the MySQL integration:

  • MySQL Overview - Key performance metrics for your MySQL server.
  • MySQL Logs - Log analysis for troubleshooting.

The MySQL integration uses the Prometheus MySQL Exporter to collect server metrics and includes 15 pre-configured alert rules.

To use these dashboards:

  1. In Grafana Cloud, navigate to Connections > Add new connection.
  2. Search for MySQL and select the MySQL integration.
  3. Follow the setup instructions to install the MySQL Exporter.
  4. Import the pre-configured dashboards from the integration page.

For more MySQL dashboards, browse the Grafana dashboard catalog.

{{< admonition type="note" >}} The MySQL integration monitors your MySQL server using Prometheus metrics. The MySQL data source documented here queries data stored in MySQL tables. These are complementary features for different use cases. {{< /admonition >}}