The MySQL integration is open source software. That means you can browse its source code and send improvements, or create your own fork and build it.
MySQL instance settings
The MySQL integration collects both Metrics and Inventory information. In the table, use the Applies to column for the settings available to each collection:
Setting | Description | Default | Applies to |
---|---|---|---|
| Hostname or IP where MySQL is running. | localhost | Metrics/Inventory |
| Port on which MySQL server is listening. | 3306 | Metrics/Inventory |
| Username for accessing the MySQL server. | N/A | Metrics/Inventory |
| Password for the given user. | N/A | Metrics/Inventory |
| Path to Unix socket file on which MySQL server is listening. Use this instead of Hostname/Port. | N/A | Metrics/Inventory |
| Name of the database to be monitored. If omitted all databases will be monitored. | N/A | Metrics/Inventory |
| Use TLS when communicating with the MySQL server. | false | Metrics/Inventory |
| Disable server name verification when connecting over TLS. | false | Metrics/Inventory |
| Use old password hashing method. | false | Metrics/Inventory |
| Specify extra connection parameters as | N/A | Metrics/Inventory |
| Captures an extended set of metrics. This also enables the capture of slave metrics. | false | Metrics |
| Captures additional innodb metrics. | false | Metrics |
| Captures additional MyISAM metrics. | false | Metrics |
| Enable multi-tenancy monitoring. Read more about remote monitoring. | true | Metrics/Inventory |
| Set to | false | |
| Set to | false |
The values for these settings can be defined in several ways:
Adding the value directly in the config file. This is the most common way.
Replacing the values from environment variables using the
{{ }}
notation. Read more about using environment variable passthroughs with on-host integrations or see the example for environment variables replacement.Important
This requires infrastructure agent v1.14.0+.Using secrets management. Use this to protect sensitive information, such as passwords that would be exposed in plain text on the configuration file. For more information, see secrets management.
Inventory
The MySQL integration captures the configuration parameters of the MySQL node returned by SHOW GLOBAL VARIABLES
. The data is available on the Infrastructure inventory page, under the config/mysql
source.
System metadata
The MySQL integration collects the following metadata attributes about your MySQL system:
Name | Description |
---|---|
|
|
| The MySQL server version. |
| Either |