Skip to main content
The MySQL integration requires CXDOT Collector 1.4.0 or greater. MySQL is a relational database for transactional applications. Use the MySQL CXDOT Collector integration with the CXDOT Collector to collect connection, query, and storage metrics from MySQL servers running in your environment. The MySQL CXDOT Collector integration supports MySQL 8.4 or greater.

Supported telemetry types

The MySQL CXDOT Collector integration supports these telemetry types:

Prerequisites

The MySQL CXDOT Collector integration has the following prerequisites:
  • Enable the MySQL Performance Schema. On each MySQL server the CXDOT Collector monitors, connect with a MySQL client and run:
    Confirm that the value is ON.
  • Create a MySQL account for the CXDOT Collector. On each MySQL server the CXDOT Collector monitors, connect as an account with permission to create users and grant privileges. For the complete metric set, grant the monitoring account the following privileges:
    Replace cxdot and % with the account name and allowed host for your environment.
  • Make port 3306, or your custom MySQL port, reachable from the CXDOT Collector.

Configure

The MySQL integration is enabled by default. You can configure targets either by annotating pods in your Kubernetes cluster or by listing static endpoints in your Helm values. To configure the MySQL CXDOT Collector integration, follow these steps:
  1. To collect from MySQL pods in Kubernetes, add a CXDOT integration annotation to the pod template. The annotation key must end with the container name, and its value can reference credentials stored in a Kubernetes Secret in the same namespace. For example, add the following annotation to your MySQL workload:
    The Collector replaces ${target.host} with the pod IP address, ${target.port.mysql} with the container port named mysql, and ${k8s_secret:mysql-monitoring/password} with the password key of the mysql-monitoring Secret. To allow the Collector to read the Secret, add the pod’s namespace to apiServer.metadataServer.secretAllowlist in the Helm values for your CXDOT Collector.
  2. Optional: To collect from specific MySQL servers, such as a Kubernetes Service or a server outside your cluster, configure static targets and provide the password through your deployment’s secret management. For example, the following Helm values reference the MYSQL_PASSWORD environment variable:
    When you configure static targets, this integration instance collects from exactly those targets and stops reading CXDOT integration annotations.
  3. Optional: Configure a second integration instance to collect from both annotated pods and static targets. For example, add the following to the Helm values for your CXDOT Collector:
    The mysql/external key defines a named instance for the static targets, with its own credentials. The bare mysql key continues to collect from annotated pods.
For more information about how the CXDOT Collector discovers targets, see autodiscovery.

Validate

To validate the MySQL CXDOT Collector integration, follow these steps:
  1. In Live Telemetry Analyzer, filter for cxdot.integration.name=mysql. Confirm that cxdot.integration.target.health appears and reports 1 for each target.
  2. In Metrics Explorer, run the following query while the MySQL servers handle query traffic:
    Confirm that the query returns the expected time series for each target.

Configuration reference

Configure one MySQL integration instance with the following settings. In Helm values, place these settings under collection.cxdot.integrations.mysql. In a Collector configuration file, place them under cxdot.integrations.mysql.

Optional settings

  • enabled Type: boolean. Optional. Default: true. Whether to run the MySQL integration. If true, the Collector collects MySQL metrics. If false, the Collector doesn’t run this integration.
  • username Type: string. Optional. Default: root. MySQL username for connections to the configured targets.
  • password Type: string. Optional. MySQL password for connections to the configured targets. The Collector masks this value in diagnostic output, logs, and errors.
  • database Type: string. Optional. Default: empty string. Database to use for connections to the configured targets.
  • allow_native_passwords Type: boolean. Optional. Default: true. If true, permits MySQL native password authentication. If false, rejects connections that require the native password authentication method.
  • collection_interval Type: duration. Optional. Default: 10s. Time between metric collections from each MySQL target.
  • timeout Type: duration. Optional. Default: 10s. Maximum time to wait for each MySQL metric collection.
  • instances Type: array of object. Optional. Default: []. MySQL targets. Each entry’s endpoint is host:port, for example, mysql.default.svc:3306. When this list isn’t empty, the integration collects from exactly these targets instead of targets found through discovery annotations. If no listed or discovered targets exist, the integration doesn’t collect metrics.
  • instances[].endpoint Type: string. Required. MySQL target in host:port format.
  • tls Type: object. Optional. TLS settings for connections to the configured MySQL targets. When set, the connection uses TLS and verifies the server certificate. Set insecure_skip_verify to true to skip certificate verification, or set insecure to true to use an unencrypted connection.
  • tls.ca_file Type: string. Optional. Path to the CA cert. For a client this verifies the server certificate. For a server this verifies client certificates. If empty uses system root CA. (optional)
  • tls.ca_pem Type: string. Optional. In memory PEM encoded cert. (optional)
  • tls.cert_file Type: string. Optional. Path to the TLS cert to use for TLS required connections. (optional)
  • tls.cert_pem Type: string. Optional. In memory PEM encoded TLS cert to use for TLS required connections. (optional)
  • tls.cipher_suites Type: array of string. Optional. CipherSuites is a list of TLS cipher suites that the TLS transport can use. If left blank, a safe default list is used. See https://go.dev/src/crypto/tls/cipher_suites.go for a list of supported cipher suites.
  • tls.curve_preferences Type: array of string. Optional. contains the elliptic curves that will be used in an ECDHE handshake, in preference order Defaults to empty list and “crypto/tls” defaults are used, internally.
  • tls.include_system_ca_certs_pool Type: boolean. Optional. If true, load system CA certificates pool in addition to the certificates configured in this struct.
  • tls.insecure Type: boolean. Optional. In gRPC and HTTP when set to true, this is used to disable the client transport security. See https://godoc.org/google.golang.org/grpc#WithInsecure for gRPC. Please refer to https://godoc.org/crypto/tls#Config for more information. (optional, default false)
  • tls.insecure_skip_verify Type: boolean. Optional. InsecureSkipVerify will enable TLS but not verify the certificate.
  • tls.key_file Type: string. Optional. Path to the TLS key to use for TLS required connections. (optional)
  • tls.key_pem Type: string. Optional. In memory PEM encoded TLS key to use for TLS required connections. (optional)
  • tls.max_version Type: string. Optional. MaxVersion sets the maximum TLS version that is acceptable. If not set, refer to crypto/tls for defaults. (optional)
  • tls.min_version Type: string. Optional. MinVersion sets the minimum TLS version that is acceptable. If not set, TLS 1.2 will be used. (optional)
  • tls.reload_interval Type: duration. Optional. ReloadInterval specifies the duration after which the certificate will be reloaded If not set, it will never be reloaded (optional)
  • tls.server_name_override Type: string. Optional. ServerName requested by client for virtual hosting. This sets the ServerName in the TLSConfig. Please refer to https://godoc.org/crypto/tls#Config for more information. (optional)
  • tls.tpm Type: object. Optional. Trusted platform module configuration
  • tls.tpm.auth Type: string. Optional. Authorization value for the trusted platform module key.
  • tls.tpm.enabled Type: boolean. Optional. Whether to use a trusted platform module for the TLS private key. If true, the Collector loads the key from the configured device or socket. If false, the Collector uses the configured key file or in-memory key.
  • tls.tpm.owner_auth Type: string. Optional. Owner authorization value for the trusted platform module.
  • tls.tpm.path Type: string. Optional. The path to the TPM device or Unix domain socket. For instance /dev/tpm0 or /dev/tpmrm0.