integrations-charts

MySQL integration

This helm chart is part of the integration of PromCat.io for mysql installs our version of the MySQL Prometheus exporter.

Visit PromCat.io for dashboards, alerts and further documentation for this integration.

Requirements

Helm v3

Prerequisites

Create the user and password for the exporter in the database:

CREATE USER 'exporter' IDENTIFIED BY 'YOUR-PASSWORD' WITH MAX_USER_CONNECTIONS 3;
GRANT PROCESS, REPLICATION CLIENT, SELECT ON *.* TO 'exporter';

Substitute the user name and the password in the SQL sentence for your custom ones.

Create a mysql-exporter.cnf file with the credentials of the exporter:

[client]
user = exporter
password = "YOUR-PASSWORD"
host=YOUR-DB-IP

In your cluster, create the secret with the mysql-exporter.cnf file. This file will be mounted in the exporter to authenticate with the database:
```
kubectl create secret -n mysql generic mysql-exporter \
  --from-file=.my.cnf=./mysql-exporter.cnf
```

SSL authentication

If your database requires SSL authentication, you need to create the secrets with the certificates: To do so, create the secret with SSL certificates for the exporter:

kubectl create secret generic mysql-exporter-ssl \
  --from-file=ca.pem=./certs/ca.pem \
  --from-file=client-key.pem=./certs/client-key.pem \
  --from-file=client-cert.pem=./certs/client-cert.pem

In the mysql-exporter.cnf file, include the following lines to route to the certificates in the exporter:

[client]
user = exporter
password = "YOUR-PASSWORD"
host=YOUR-DB-IP
ssl-ca=/lib/cert/ca.pem
ssl-key=/lib/cert/client-key.pem
ssl-cert=/lib/cert/client-cert.pem

Usage

Stand-alone MySQL

Use the following command:

helm install my-release ./charts/mysql-exporter/

Attributions

This helm chart is maintained by Sysdig team.

Exporter and user queries: MySQL exporter with Apache v2 license.

This site is open source. Improve this page.