Prometheus Mysql Exporter¶

A Prometheus exporter for MySQL metrics.

This chart bootstraps a Prometheus MySQL Exporter deployment on a Kubernetes cluster using the Helm package manager.

Get Helm Repository Info¶

helm repo add prometheus-community https://helm-charts.itboon.top/prometheus-community
helm repo update

See helm repo for command documentation.

Install Chart¶

helm install [RELEASE_NAME] prometheus-community/prometheus-mysql-exporter

See configuration below.

See helm install for command documentation.

Uninstall Chart¶

helm uninstall [RELEASE_NAME]

This removes all the Kubernetes components associated with the chart and deletes the release.

See helm uninstall for command documentation.

See helm upgrade for command documentation.

Upgrading Chart¶

helm upgrade [RELEASE_NAME] [CHART] --install

To =< 1.0.0¶

Version 1.0.0 is a major update.

• The chart now follows the new Kubernetes label recommendations: https://kubernetes.io/docs/concepts/overview/working-with-objects/common-labels/

The simplest way to update is to do a force upgrade, which recreates the resources by doing a delete and an install.

helm upgrade prometheus-mysql-exporter prometheus-community/prometheus-mysql-exporter --force

Configuration¶

See Customizing the Chart Before Installing. To see all configurable options with detailed comments, visit the chart's values.yaml, or run these configuration commands:

helm show values prometheus-community/prometheus-mysql-exporter

MySQL Connection¶

The exporter can connect to mysql directly or using the Cloud SQL Proxy.

• To configure direct MySQL connection by value, set mysql.user, mysql.pass, mysql.host and mysql.port (see additional options in the mysql configuration block)
• To configure direct MySQL connection by secret, you must store a connection string in a secret, and set mysql.existingSecret to [SECRET_NAME]

Exporter Documentation and Params¶

Documentation for the MySQL Exporter can be found here: (https://github.com/prometheus/mysqld_exporter) A mysql params overview can be found here: (https://github.com/go-sql-driver/mysql#dsn-data-source-name)

Collector Flags¶

Available collector flags can be found in the values.yaml and a description of each flag can be found in the mysqld_exporter repository.

CloudSql Proxy Workload Identity¶

Enable it with flag cloudsqlproxy.workloadIdentity To more details about Workload Identity visit Use Workload Identity