Missing system level metrics in PMM server for RDS MySQL Community

MySQL & MariaDB Percona Server for MySQL 8.0
1

I have installed PMM server using docker (version 2.23.0).
My RDS engine is MySQL Community and version 8.0.25.

I followed Amazon RDS - Percona Monitoring and Management for setting up RDS instance in PMM.

I am able to see MySQL related metrics but OS metrics are missing.
I have enabled enhanced monitoring for RDS and I have used IAM role with the policy mentioned in the doc.

Node-summary-screenshot-1
Node-summary-screenshot-12864×1446 296 KB

Node-summary-screenshot-2
Node-summary-screenshot-22864×1446 322 KB

What is the issue? Is it because the engine is MySQL Community?

1 Like
2

The issue is that the PMM agent does not run on the same instance as your RDS, thus PMM cannot gather the OS metrics. Compare this to MySQL running on an EC2 instance; The PMM agent runs on that instance and can read OS metrics + MySQL metrics. RDS is a hosted solution and thus you cannot run other programs at the OS level.

1 Like
3

But as suggested in one comment at Missing many system level metrics in PMM server for RDS Aurora MySQL RDS instances can get OS metrics.

I can see OS metrics in Grafana and that also suggests no pmm-agent running on this node in System Summary same as my case.

1 Like
4

The linked post is Aurora and that’s not what you are running. It is possible that RDS MySQL does not expose these metrics but RDS Aurora does. I will see if someone from the PMM team can confirm this.

1 Like
5

The documentation doesn’t mention anything about different behaviour for different engines.

If that is the case then how do I get the OS metrics for RDS MySQL?

1 Like
6

I have attached IAM role on the PMM server host. I had added the first remote RDS instance without passing access-key/secret-access-key. I was missing OS metrics then.

Now I created an IAM user and when I added another remote RDS instance after passing access-key/secret-access-key (same underlying IAM policy as the role) I am able to see OS metrics.

This is a weird behaviour, anyways I am able to get this working.

1 Like
7

Hi, I would love to know if there is a plan on making this work with IAM role and not using secret and access key.
I also opened a jira ticket about this

1 Like