PMM Not Showing Aurora MySQL Queries in Query Analytics

MySQL & MariaDB
1

Hi all,

I’m trying to monitor an Amazon Aurora MySQL database using Percona PMM 2.44.1. I’ve successfully connected the instance and see basic metrics on the dashboards, but nothing is showing up in Query Analytics.

Here’s what I’ve done so far:

PMM Setup

  • PMM Server: running on EC2
  • PMM Agent: same EC2 instance
  • Aurora MySQL service added via pmm-admin add mysql --query-source=slowlog

Aurora Configuration

  • slow_query_log = ON
  • long_query_time = 0
  • log_output = FILE
  • Slow query log export to CloudWatch is enabled
  • I executed slow queries like SELECT BENCHMARK(...) and SELECT SLEEP(5)

PMM Agent status

  • mysqld_exporter is running
  • No qan-mysql-slowlog-agent appears in pmm-admin status
  • When I try to re-add the service using --query-source=slowlog, I get:
    Unauthorized. Please check username and password.

MySQL user credentials

  • I can manually connect to Aurora with mysql -h <endpoint> -u <user> -p
  • User has: SELECT, PROCESS, REPLICATION CLIENT permissions

The problem:

I’m not seeing any queries in PMM’s Query Analytics tab for this Aurora instance.

What am I missing?

  • Does PMM require local access to slow log files, or is CloudWatch export enough?
  • Is there a way to verify that qan-mysql-slowlog-agent is being launched or failing silently?
  • Is there any other required permission for the PMM user on Aurora?

Any insights would be appreciated!

Thanks

2

Hi,

  • Does PMM require local access to slow log files, or is CloudWatch export enough?

Yes, it requires local access to slowlog, that’s why slowlog data source doesn’t work for AWS, please use perfschema.

3

This is incorrect for anything RDS. You need to use perfschema as the query source. Run pmm-admin remove mysql and re-add using the correct source.

4

Thanks for the response.
When I’m trying to add the DB like this:
pmm-admin add mysql \
--username=pmm \
--password=password \
--host= my-cluster.us-east-1.rds.amazonaws.com \
--port=3306 \
--query-source=perfschema \
MySQL-Primary

I get:

unauthorized. please check username and password.

I try to updade the password in the cli to match the password on the UI, with this command:
sudo pmm-admin config --server-insecure-tls --server-url= https://admin:mypassword@<my-ip>:443 --force

It’s working but it’s breaks my pmm agent.

I try to add the DB, it’s been added successfully (with the pmm-agent still broken) but still no QAN.

I’m really clueless, and I would greatly appreciate any help.

Thanks!

5

If it’s broken, then you need to fix it with the correct usernames/passwords. There are 2 sets. 1) UN/PW for PMM server. This is the https://un:pw@pmmserver/ and 2) is the un/PW for the RDS login.

Remove everything and start over. Do pmm-admin config to register the agent with pmm-server. Verify that works first before anything else. Then add remote mysql rds, and verify.