Pmm, pmm server , pmm client

[Sanjana_Chandrasheka]

Hello! I have configured 3 node galera cluster using mariadb 10.5.15 version and i have installed pmm-clients on all of them , now my pmm-server and pmm-client are also connected, so i want to monitor my galera nodes , but when I try to add the service, i am facing a syntax error. And also i am unsure whether i should be using mysql 8 or 5.7 for creating the database.
this is what i am following : MySQL - Percona Monitoring and Management

Thanks

[Vadim_Yalovets]

Hi @Sanjana_Chandrasheka

You may get the list of system privileges that your MariaDB server version supports by command

SHOW PRIVILEGES;

[Sanjana_Chandrasheka]

I dont seem to understand how to create a database using mariadb , please help me with that!

[matthewb]

The privilege BACKUP_ADMIN does not exist on MariaDB. You simply need to remove that from your GRANT statement.

[Sanjana_Chandrasheka]

Okay thanks @matthewb

[Sanjana_Chandrasheka]

I am getting this error

[Vadim_Yalovets]

@Sanjana_Chandrasheka

I am getting this error

Have you performed FLUSH PRIVILEGES; command?

[Sanjana_Chandrasheka]

@Vadim_Yalovets

FLUSH PRIVILEGES;

yes , i have done it @Vadim_Yalovets

[Vadim_Yalovets]

Could you add an additional database pmm user for your pmm-client ip?

e.g.
❯ docker inspect -f ‘{{range.NetworkSettings.Networks}}{{.IPAddress}}{{end}}’ pmm-client
172.17.0.22

CREATE USER ‘pmm’@‘172.17.0.22’ IDENTIFIED BY ‘pass’

[Sanjana_Chandrasheka]

Did’nt work , maybe the issue is mariadb is installed on my VM and pmm client on a docker , so it is not syncing there.

[matthewb]

Yes, that’s probably not going to work. If MariaDB is inside docker, and pmm-client is in docker, that will work. PMM Client should be as close to the DB as possible.