I installed PMM 2.30.0 from AWS AMI and configured IAM policy and IAM role. Also attached IAM role to the PMM EC2 instance but still unable to discover the RDS instances within the same region.
The PMM EC2 is having SG group with ports 80, 443 and 22 from 0.0.0.0/0. Moreover, performace_schema=1 and Enhanced Monitoring too is enabled for all RDS
Thanks a lot for the response Micheal. Yes i have used the same IAM policy. Moreover i had multiple times repeated the steps as described in below link but same issue.
However, one strange thing i m noticing it is able to discover 2 RDS instance from another region(us-east-1) but PMM EC2 is running on sa-east-1. I have even tried different versions of PMM from 2.29,2.30 and 2.31 and used different instance type as well. Also, tried using IAM user and attaching it to the above IAM policy, still no luck and unable to discover the RDS in sa-east-1 region.