Percona XtraDB Cluster Node is not synced or non-PRIM. @ pxc 8.0

MySQL & MariaDB Percona XtraDB Cluster 8.x
,
1

Hi there,
When issuing clustercheck command facing the below error,this error is same for 3 nodes.
but able verify the replication in all the 3 nodes,data is in sync.

root@node2:~# clustercheck
HTTP/1.1 503 Service Unavailable
Content-Type: text/plain
Connection: close
Content-Length: 57

Percona XtraDB Cluster Node is not synced or non-PRIM.
1 Like
2

@AneeshBabu

Do you have haproxy setup on the node your running clustercheck?

The information on the github repo should be able to assist you.

GitHub - olafz/percona-clustercheck: Script to make a proxy (ie HAProxy) capable of monitoring Percona XtraDB Cluster nodes properly. The clustercheck script is distributed under the BSD license..

1 Like
3

@AneeshBabu Did you create the correct user as mentioned in the documentation?

1 Like
4

@matthewb
which user…? Please provide the detailed info.

1 Like
5

The User below:

GRANT PROCESS ON . TO ‘clustercheckuser’@‘localhost’ IDENTIFIED BY ‘clustercheckpassword!’

1 Like
6

The user as mentioned in the documentation. ‘clustercheckuser’. Please read the docs.

1 Like