PXC Cluster Is Not Recognized Correctly When MariaDB Nodes Are Monitored

Description

It seems that if we add for example 2 MariaDB nodes which are not part of Galera cluster and 3 nodes for PXC the PXC is not correctly visible in PXC/Galera Cluster Overview dashboard.
The cluster size on top is 0, although the nodes are visible in graphs below.
On PXC/Galera Graphs dashboard MariaDB nodes are seen as being part of the cluster (but they are not) and when selected there's no data but when we select PXC node then data can be seen.
It seems it's picking up pxc/galera cluster size from MariaDB node which is 0 there since galera cluster is not enabled in my setup.

MariaDB:

PXC:

How to test

None

How to document

None

Attachments

5

Smart Checklist

Activity

Hubertus Krogmann [X] May 18, 2018 at 8:19 AM

I have a similar problem,

3 Node PXC (5.7.21 wsrep_cluster_name pxc1) with pmm-client 1.10.0

pmm-server 1.10.0

I added a 3 node mariadb galera cluster (10.2.14wsrep_cluster_name my_wsrep_cluster) with pmm-client 1.10.0

and only the mariadb one is visible in the PXC/Galera * dashboards.

pmm-admin restarts/config/add on pxc node did not help.

Borys Belinsky February 8, 2018 at 12:53 PM

The ticket has been added to the preliminary version of the release notes: https://confluence.percona.com/display/PMM/Release+Notes+1.8.0

Vadim Yalovets February 5, 2018 at 12:44 PM

Fixed calculation of the metric "Percona XtraDB / Galera Cluster Size"
and added an additional filter for hosts

PR -> https://github.com/percona/grafana-dashboards/pull/111

Nailya Kutlubaeva February 5, 2018 at 8:46 AM

the problem is still reproducible

Roma Novikov February 1, 2018 at 3:06 PM

Looks good. merged . but  additional cases for testing - will be good 

Done

Details

Assignee

Reporter

Priority

Components

Labels

Fix versions

Affects versions

Smart Checklist

Created September 25, 2017 at 4:24 PM
Updated July 18, 2024 at 2:22 PM
Resolved February 28, 2018 at 8:55 AM