Re: monitoring MySQL Operator for Kubernetes

[Johannes Schlüter]

Hi,

you can use the spec.podSpec property to override things we produce. That way you can add a sidecar.

For instance if you want to use the Prometheus exporter you can do this:

apiVersion: mysql.oracle.com/v2
kind: InnoDBCluster
name: mywithmetrics
spec:
instances: 3
podSpec:
containers:
- env:
- name: DATA_SOURCE_NAME
value: someUserName:@unix(/var/run/mysqld/mysql.sock)/
image: prom/mysqld-exporter
name: metrics
ports:
- metrics: 9104
volumeMounts:
- mountPath: /var/run/mysqld
name: rundir
secretName: mypwds
tlsUseSelfSigned: true

And then create a user with the required grants and for example socket authentication.