Add new mysql service from server (agentless)

Percona Monitoring and Management (PMM) PMM 2.x
,
1

Hello there,
I’ve deployed pmm on Kub with helm.
I’ve successfuly add a first mysql db with pmm agent.
Now, I would like to add new mysql db from server (pmm gui) or from API.
Unfortunately, when I tried to add it by GUI, it’s failed (1/2) with QAN agent in waiting status

Also, documentation on API is very limited, have you some links to share ?
Thanks in advance.
J

2

Hi, @Jeromed what about mysqld_exporter? does MySQL related dashboards show anything? Can you make sure that performance schema is accessable with credentials passed to PMM?

3

Hi Nurlan,

My issue has been resolved with answers on my other topic.
my DB refused external access.

May be interesting to add an example rather than localhost ?

CREATE USER ‘pmm’@‘127.0.0.1’ IDENTIFIED BY ‘pass’ WITH MAX_USER_CONNECTIONS 10;
GRANT SELECT, PROCESS, REPLICATION CLIENT, RELOAD ON . TO ‘pmm’@‘localhost’;

Thanks for your help.