MySQL RDS graphs are empty & hosts servers have disappeared in grafana

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

It took awhile to get PMM connected to the pmm-server (there was a gap in the documentation for RDS). I installed the pmm client software on the ec2 instance that is hosting the pmm-server. I did not put it in a container. I ran pmm-admin config for the local server. Ran pmm-admin add mysql:metrics for 3 RDS instances. And suddenly there were graphs with data. Great data. Pretty graphs. Useful.

About 24 hours later my graphs disappeared. I have followed a couple of threads in here where people lost their graphs. Here’s what I’ve done:

  1. [URL]https://myserver-ip/prometheus/targets[/URL] Shows they are ALL down (including [URL]http://localhost:9100/metrics[/URL] )

  2. [URL]https://myserver-ip/42002/metrics-mr[/URL] (plus lr & hr) all show data. If I hit refresh the mysql_exporter_hr_scrapes_total number increases

  3. Main page where the v1.1.3 is & hit the blue button which did an update (today May 19, 2017) - nothing changed.

  4. Drop down for the MySQL Host has None & a large blank box. Manually add the aws host ID into the box and a couple of graphs (MySQL Connections but No MySQL Active Threads) have old data.

  5. One of the forum posts talked about changing the scrape_timeout: in prometheus.yml in the docker container. My docker container does not have a prometheus.yml file.

Suggestions?

2

Hi Erino,

Is [URL]http://localhost:9090/prometheus/metrics[/URL] target also down?
in this case please synchronize time (NTP or chrony)

3

Hello! This was fixed by adding resources to the ec2 instance! I found the requirements of PMM that Peter had written (google PMM & blog is how I found it). Thanks so much for your help. I LOVE PMM!