New MySQL node not showing up in QAN

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

Interestingly enough, I added a MySQL RDS node. The performance_schema is turned on, on the instance. However, it does not show up in the QAN. It does show up in the general dashboard showing CPU usage etc. What else could I be missing?

Thanks in advance!
Venkat

1 Like
2

Hi Venkatesh,

Could verify that the pmm user was created?

CREATE USER 'pmm'@'%' IDENTIFIED BY 'pass';
GRANT SELECT, PROCESS, REPLICATION CLIENT ON *.* TO 'pmm'@'%';
ALTER USER 'pmm'@'%' WITH MAX_USER_CONNECTIONS 10;
GRANT SELECT, UPDATE, DELETE, DROP ON performance_schema.* TO 'pmm'@'%';
1 Like
3

Hi Vadim,
Thanks for your response. I do have those. Also the max_conections is 10 for pmm_ro. The issue is only with QAN. QAN shows other nodes but for this. The node shows up on all other pages. Could it be something to do with aurora version? Currently the node is on 5.7.mysql_aurora.2.04.6.

show grants for pmm_ro;

1 Like