Re: monitoring MySQL Operator for Kubernetes

[sujit agarwal]

HI, I tried the option you suggested but now I am facing with permission issues,

error:

ts=2023-04-18T06:11:42.556Z caller=main.go:572 level=info vm_limits="(soft=unlimited, hard=unlimited)"
ts=2023-04-18T06:11:42.556Z caller=query_logger.go:91 level=error component=activeQueryTracker msg="Error opening query log file" file=/prometheus/queries.active err="open /prometheus/queries.active: permission denied"
panic: Unable to create mmap-ed active query log

goroutine 1 [running]:
github.com/prometheus/prometheus/promql.NewActiveQueryTracker({0xffffcf333853, 0xb}, 0x14, {0x3774980, 0x400064ae60})
/app/promql/query_logger.go:121 +0x2ec
main.main()
/app/cmd/prometheus/main.go:626 +0x6654
LM0005409:final sujit.agarwal$




Below is my configuration:

apiVersion: mysql.oracle.com/v2
kind: InnoDBCluster
metadata:
name: mycluster
spec:
secretName: mycluster-user
instances: 3
tlsUseSelfSigned: true
router:
instances: 1
podSpec:
containers:
- name: metrics
image: prom/prometheus:latest
ports:
- containerPort: 9104
env:
- name: DATA_SOURCE_NAME
value: localroot:@unix(/var/run/mysqld/mysql.sock)/
- name: collect.global_status
value: 'true'
- name: collect.info_schema.innodb_metrics
value: 'true'
volumeMounts:
- mountPath: /var/run/mysqld
name: rundir