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

PXC Galera cluster not showed in pmm 1.12.0

fbejaranofbejarano EntrantCurrent User Role Beginner
Hi

I have a cluster pxc 5.6.39 and other cluster pxc 5.7.21 in Ubuntu 14.04.

I have updated pmm to 1.12.0 and all clientes to the same versión.

Data of mysqls and systems are showed but pmm only shows galera data of cluster 5.6.39, not 5.7.21.

1 example node of 5.7.21 shows status ok
sudo pmm-admin check-network
PMM Network Status

Server Address | ubudocker00001:80
Client Address | 172.21.0.13 

* System Time
NTP Server (0.pool.ntp.org)         | 2018-07-02 07:59:23 +0000 UTC
PMM Server                          | 2018-07-02 07:59:23 +0000 GMT
PMM Client                          | 2018-07-02 07:59:23 +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 | 944.41µs
Request duration    | 2.267224ms
Full round trip     | 3.211634ms


* Connection: Client <-- Server
-------------- --------------- ------------------ ------- ---------- ---------
SERVICE TYPE   NAME            REMOTE ENDPOINT    STATUS  HTTPS/TLS  PASSWORD 
-------------- --------------- ------------------ ------- ---------- ---------
linux:metrics  ubuprepxc01000  172.21.0.13:42000  OK      YES        -        
mysql:metrics  ubuprepxc01000  172.21.0.13:42002  OK      YES        -

1 example node of 5.6.39 shows status ok
sudo pmm-admin check-network
PMM Network Status

Server Address | ubudocker00001:80
Client Address | 172.20.10.14 

* System Time
NTP Server (0.pool.ntp.org)         | 2018-07-02 08:00:53 +0000 UTC
PMM Server                          | 2018-07-02 08:00:53 +0000 GMT
PMM Client                          | 2018-07-02 08:00:53 +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 | 2.831805ms
Request duration    | 2.250704ms
Full round trip     | 5.082509ms


* Connection: Client <-- Server
-------------- ------------ ------------------- ------- ---------- ---------
SERVICE TYPE   NAME         REMOTE ENDPOINT     STATUS  HTTPS/TLS  PASSWORD 
-------------- ------------ ------------------- ------- ---------- ---------
linux:metrics  ubupxc01000  172.20.10.14:42000  OK      YES        -        
mysql:metrics  ubupxc01000  172.20.10.14:42002  OK      YES        -

All nodes in two clusters shows same results. So I don't know why galera metrics of cluster 5.7.21 is not showed in pmm. Could you help me to solve this?

Regards

Comments

  • fbejaranofbejarano Entrant Current User Role Beginner
    Hi

    All metrics are running ok now. I have reviewed prometheus endpoints and I have seen that mysql metrics-lr in all nodes of cluster prepxc01 had DOWN state

    https://node_ip:42002/metrics-lr

    I don't know why but I have completily uninstalled and installed the pmm-client with --client-address and --bind-address options in all nodes of cluster 5.7 and nodes go UP... pmm-admin check-network showed everything ok so... but well, All is ok now
  • lorraine.pocklingtonlorraine.pocklington Percona Community Manager Legacy User Role Patron
    Thanks for letting us know that it's running now fbejarano, I hate when that happens! :)

    We appreciate the update, as it means the team can spend the time to help someone else, and your update might in itself help someone with the same symptoms too.

    Don't hesitate to create a new post if you encounter a new issue.
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.