PXC Galera cluster not showed in pmm 1.12.0

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

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

2

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

3

Thanks for letting us know that it’s running now fbejarano, I hate when that happens! :slight_smile:

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.