# PMM-SERVER and RDS

**URL:** <https://forums.percona.com/t/pmm-server-and-rds/5585>\
**Category:** PMM 1.x\
**Created:** [May 8, 2017, 5:20pm UTC](https://forums.percona.com/t/pmm-server-and-rds/5585 "2017-05-08T17:20:57Z")\
**Posts on this page:** 7\
**Page:** 1

<div class="post-metadata">

**Author:** ![erino](https://avatars.discourse-cdn.com/v4/letter/e/ecb155/32.png) [@erino](https://forums.percona.com/u/erino)\
**Post date:** [May 8, 2017, 5:20pm UTC](https://forums.percona.com/t/pmm-server-and-rds/5585/1 "2017-05-08T17:20:57Z")

</div>

I need to use PMM with RDS. I have an image that was created by my devops following the docker instructions (the AMI image would not connect to the RDS).  
Then I go to this page: [url][https://www.percona.com/doc/percona-monitoring-and-management/amazon-rds.html[/url]](https://www.percona.com/doc/percona-monitoring-and-management/amazon-rds.html%5B/url%5D)

I’ve turned on P\_S and I created the pmm mysql user.  
But when I go to the next command:  
sudo pmm-admin add mysql:metrics --host …  
And of course there is no pmm-admin software. I installed it on the host server of the docker container and tried again.  
pmm-admin add …  
I’m told to run pmm-admin config.  
I have verified the server is running and I can see the OS metrics for the pmm-server. But I can not configure the RDS. They are in the same vpc and vpc subnet.

I’ve done from another ec2, pmm-server docker container and pmm-server that holds the docker container:  
curl http:///prometheus/  
[Found](http://disq.us/url?url=%2Fprometheus%2Fgraph%3AUyW1LHbdWX08oRgGK9PmRfu9QSI&cuid=4563557).

It’s just not clear how I tell the pmm-server to take metrics on an RDS server…

---

<div class="post-metadata">

**Author:** ![jrivera](https://sea1.discourse-cdn.com/flex019/user_avatar/forums.percona.com/jrivera/32/13_2.png) [@jrivera](https://forums.percona.com/u/jrivera)\
**Post date:** [May 9, 2017, 2:01am UTC](https://forums.percona.com/t/pmm-server-and-rds/5585/2 "2017-05-09T02:01:39Z")

</div>

Please run

```auto
pmm-admin info

```

and

```auto
pmm-admin check-network

```

on the host you use to connect to the RDS instance and where PMM client is installed.

---

<div class="post-metadata">

**Author:** ![erino](https://avatars.discourse-cdn.com/v4/letter/e/ecb155/32.png) [@erino](https://forums.percona.com/u/erino)\
**Post date:** [May 19, 2017, 4:58pm UTC](https://forums.percona.com/t/pmm-server-and-rds/5585/3 "2017-05-19T16:58:26Z")

</div>

X.X.X.X = PMM server IP  
pmm-admin info:

pmm-admin 1.1.3

PMM Server | X.X.X.X  
Client Name | ip-X-X-X-X  
Client Address | X.X.X.X

Service Manager | linux-systemd

Go Version | 1.8  
Runtime Info | linux/amd64

* * *

PMM Network Status

Server Address | X.X.X.X  
Client Address | X.X.X.X

- System Time  
PMM Server | 2017-05-19 22:16:25 +0000 GMT  
PMM Client | 2017-05-19 22:16:30 +0000 UTC  
PMM Client to PMM Server Time Drift | OK

- Connection: Client → Server

* * *

SERVER SERVICE STATUS

* * *

Consul API OK  
Prometheus API OK  
Query Analytics API OK

Connection duration | 165.281µs  
Request duration | 20.396741ms  
Full round trip | 20.562022ms

- Connection: Client ← Server

* * *

SERVICE TYPE NAME REMOTE ENDPOINT STATUS HTTPS/TLS PASSWORD

* * *

mysql:metrics mydb1.rds X.X.X.X:42002 DOWN YES -  
mysql:metrics mydb2.rds X.X.X.X:42003 DOWN YES -  
mysql:metrics mydb3.rds X.X.X.X:42004 DOWN YES -

When an endpoint is down it may indicate that the corresponding service is stopped (run ‘pmm-admin list’ to verify).

If it’s running, check out the logs /var/log/pmm-\*.log

When all endpoints are down but ‘pmm-admin list’ shows they are up and no errors in the logs,  
check the firewall settings whether this system allows incoming connections from server to address:port in question.

## Also you can check the endpoint status by the URL: [http://X.X.X.X/prometheus/targets](http://X.X.X.X/prometheus/targets)

From the PMM server I can run a mysql -h $HOST to each of the mydb hosts.  
There is data in [https://X.X.X.X:42002/42002/metrics-hr](https://X.X.X.X:42002/42002/metrics-hr) (and lr & mr) and:

mysql\_exporter\_hr\_scrapes\_total = # that increments  
mysql\_exporter\_hr\_last\_scrape\_error 0

[https://X.X.X.X/prometheus/targets](https://X.X.X.X/prometheus/targets) shows EVERYTHING down including the localhost:9100/metrics  
BUT  
[http://localhost:9090/prometheus/metrics](http://localhost:9090/prometheus/metrics) UP

---

<div class="post-metadata">

**Author:** ![erino](https://avatars.discourse-cdn.com/v4/letter/e/ecb155/32.png) [@erino](https://forums.percona.com/u/erino)\
**Post date:** [May 22, 2017, 10:53am UTC](https://forums.percona.com/t/pmm-server-and-rds/5585/4 "2017-05-22T10:53:13Z")

</div>

I came in this am and the prometheus/metrics is down on the local host.

---

<div class="post-metadata">

**Author:** ![erino](https://avatars.discourse-cdn.com/v4/letter/e/ecb155/32.png) [@erino](https://forums.percona.com/u/erino)\
**Post date:** [May 22, 2017, 2:24pm UTC](https://forums.percona.com/t/pmm-server-and-rds/5585/5 "2017-05-22T14:24:34Z")

</div>

and it’s down again… I’m not sure what is going on with PMM ?It’s ONLY the mysql:metrics. The mysql:queries is working.

---

<div class="post-metadata">

**Author:** ![erino](https://avatars.discourse-cdn.com/v4/letter/e/ecb155/32.png) [@erino](https://forums.percona.com/u/erino)\
**Post date:** [May 22, 2017, 3:00pm UTC](https://forums.percona.com/t/pmm-server-and-rds/5585/6 "2017-05-22T15:00:42Z")

</div>

I rebooted the instance, started the docker container and metrics are back. It may be that the instance was too small for 3 RDS servers (two were very small) I removed all but the most important and purged the other data. I did this for BOTH mysql:metrics and mysql:queries. However the queries still show up for the 2 dbs I removed. Now the prometheus/targets are showing up for the one db I want & down for the other two. (not sure how to remove them?)

Turns out the old PC standard worked. REBOOT, restart.

---

<div class="post-metadata">

**Author:** ![erino](https://avatars.discourse-cdn.com/v4/letter/e/ecb155/32.png) [@erino](https://forums.percona.com/u/erino)\
**Post date:** [May 24, 2017, 2:27pm UTC](https://forums.percona.com/t/pmm-server-and-rds/5585/7 "2017-05-24T14:27:50Z")

</div>

Thanks for your all your help. I was able to add a mongodb client (I admit I had to use the forums) and now have both MySQL AND MongoDB. I LOVE PMM!
