MySQL is a relational database management system that runs as a serverproviding multi-user access to a number of databases.For more information visitmysql.com.

This functionality is only available for agents running on Linux. It isnot available on Windows.

Discovery

Even if the MySQL plugin is not configured, Monitoring willdiscover MySQL services running in your Cloud Platform project by:

• Searching instance names formysql
• Checking for ports opened to3306 via firewall rules

To see the metrics for MySQL, do the following:

1. In the Google Cloud console, go to the Dashboards page:

   Go toDashboards

   If you use the search bar to find this page, then select the result whose subheading isMonitoring.

2. Select theMySQL dashboard from the list.

Configuring MySQL monitoring

The Monitoring agent uses theConnector/C API to monitor MySQL. For Linux distributions that don't include the Connector/Clibrary with MySQL, run the appropriate command to install it:

sudoapt-getinstalllibmysqlclient20

sudoapt-getinstalllibmysqlclient21

sudoapt-getinstalllibmariadbclient18

sudoyuminstallmysql-libs

sudozypperinstalllibmysqlclient18

sudozypperinstalllibmariadb3

Configuring Monitoring to monitor MySQL

After youinstall the monitoring agent, usethe following instructions to configure the MySQL plugin on your instances.

Prerequisites

For MySQL collection, you must add a user with a password to MySQL that can runtheSHOW STATUS command. This user and password are referred to asSTATS_USER andSTATS_PASS in the following config file.

Enabling the MySQL monitoring plugin

MySQL is configured per database on your system. At the moment, no drop-inconfiguration is available. The following configuration file shows how toconfigure one database, namedDATABASE_NAME.You would need to use that configuration as a template for your databases.

On your VM instance, downloadmysql.conf from theGitHub configuration repository and place it in the directory/etc/stackdriver/collectd.d/:

(cd/etc/stackdriver/collectd.d/ &&sudocurl-Ohttps://raw.githubusercontent.com/Stackdriver/stackdriver-agent-service-configs/master/etc/collectd.d/mysql.conf)

Asroot, edit the downloaded configuration file and add information aboutyour databases. Inline comments point out where you need to add configurationfor additional databases. Wherever you seeDATABASE_NAME, substitute the nameof your database.

After editing the configuration file, restart the monitoring agent by running the following command:

sudoservicestackdriver-agentrestart

For more information on thecollectdmysql plugin, seePlugin:MySQL.

What is monitored

The full list of metrics the MySQL plugin monitors is atAgent metrics: mysql.