Percona XtraDB Operator with PMM enable - Error on pxc deployment

MySQL & MariaDB Percona Operator for MySQL
1

Hello, I have a question regarding PMM-Client and K8S Percona Operator.

I deployed the Percona XtraDB cluster with pmm setting enable:

cr.yaml pmm part:

pmm:

enabled: true

image: percona/percona-xtradb-cluster-operator:1.6.0-pmm

serverHost: monolith-mysql-monitoring

serverUser: pmm

resources:

  requests:

    memory: 200M

    cpu: 200m

As pmm-server I used container with - image: ‘percona/pmm-server:2.0’.

So after the cluster is deployed and pmm-client also running I start getting monitoring information in Grafana.

But in the Perconaxtradbclusters on the status I see error (the logs are bellow) (Where it tried to find pmmserver user):

image.png

image.png
image.png894×440 12.7 KB

Into percona-xtradb-cluster-operato log file I see this:

{“level”:“error”,“ts”:1607354268.728692,“logger”:“controller-runtime.controller”,“msg”:“Reconciler error”,“controller”:“perconaxtradbcluster-controller”,“request”:“monolith/monolith-mysql”,“error”:“reconcile ││ Users: manage sys users: undefined or not exist user pmmserver”,“errorVerbose”:"undefined or not exist user pmmserver\ngithub.com/percona/percona-xtradb-cluster-operator/pkg/controller/pxc.(*ReconcilePercona ││ XtraDBCluster).manageSysUsers\n\t/go/src/github.com/percona/percona-xtradb-cluster-operator/pkg/controller/pxc/users.go:229.…

Full log attached.

Did someone had the same experience? And already find about what user it talking here?

Also attach pmm-client logs.

percona-xtradb-cluster-operator.log

pmm.log

percona-xtradb-cluster-operator.log (8.01 MB)

pmm.log (62.4 KB)

2

Hi @GedasTSB , the ‘pmmserver’ is a required MySQL user that should exist within your PXC. When you deployed the secrets.yml, this should have included a pmmserver user. You’ll need to create this user manually within PXC, then re-deploy your secrets to include the pmmserver user with the base58 encoded password.