Not the answer you need?
Register and ask your own question!

PMM not picking MongoDB

Hello, I installed PMM Server from AWS Marketplace on a separate EC2 (PMM-EC2). I am trying to monitor mySQL and MongoDB that are installed on the same EC2 (DB-EC2). I installed PMM client on the DB-EC2 and ran the list command for which the output is below. In the Grafana dashboard the MySQL shows up but MongoDB does not. It shows 'Monitered DB Instances' as only 1 ... it should be 2 including MongoDB and MySQL.


SERVICE TYPE NAME LOCAL PORT RUNNING DATA SOURCE OPTIONS






mongodb:queries ip-173.XXX.81.XXX - YES localhost:27017 query_examples=true
mysql:queries ip-173.XXX.81.XXX - YES root:***@unix(/var/run/mysqld/mysqld.sock) query_source=slowlog, query_examples=true, s low_log_rotation=true, retain_slow_logs=1
linux:metrics ip-173.XXX.81.XXX 42000 YES -
mysql:metrics ip-173.XXX.81.XXX 42002 YES root:***@unix(/var/run/mysqld/mysqld.sock)
mongodb:metrics ip-173.XXX.81.XXX 42003 YES localhost:27017




PMM Network Status

Server Address | 13.232.233.21
Client Address | 13.XXX.XXX.XXX (173.XXX.81.XXX)

* System Time
NTP Server (0.pool.ntp.org) | 2018-08-28 00:15:11 +0000 UTC
PMM Server | 2018-08-28 00:15:09 +0000 GMT
PMM Client | 2018-08-28 00:15:11 +0000 UTC
PMM Server Time Drift | OK
PMM Client Time Drift | OK
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 | 1.092747ms
Request duration | -177.204µs
Full round trip | 915.543µs


* Connection: Client <-- Server





SERVICE TYPE NAME REMOTE ENDPOINT STATUS HTTPS/TLS PASSWORD





linux:metrics ip-173.XXX.81.XXX 13.XXX.XXX.XXX-->173.XXX.81.XXX:42000 OK YES YES
mysql:metrics ip-173.XXX.81.XXX 13.XXX.XXX.XXX-->173.XXX.81.XXX:42002 OK YES YES
mongodb:metrics ip-173.XXX.81.XXX 13.XXX.XXX.XXX-->173.XXX.81.XXX:42003 OK YES YES

Comments

  • lorraine.pocklingtonlorraine.pocklington Percona Community Manager Legacy User Role Patron
    Hello there, I've asked the team if they've any advice for you on this, just wondering if you could confirm the version of PMM you have installed?
    Did you try to set the connections to MySQL and MongoDB at the same time or has the MySQL one been running for a while?

    I'll pass you this link 'just in case' it helps, but I think that there might be some new tips and tricks for your environment ... https://www.percona.com/blog/2018/01/17/troubleshooting-percona-monitoring-and-management-pmm-metrics/
  • Michael CoburnMichael Coburn Principal Architect, Percona Percona Staff Role
    Hi mr.debater
    Can you please share (from DB-EC2 client) the contents of
    /var/log/pmm-mongodb-metrics*.log
    
    Also can you share the commands you ran to set up the MongoDB instance? It will be the
    pmm-admin add mongodb ...
    
Sign In or Register to comment.

MySQL, InnoDB, MariaDB and MongoDB are trademarks of their respective owners.
Copyright ©2005 - 2020 Percona LLC. All rights reserved.