Un-synced node help

MySQL & MariaDB Percona XtraDB Cluster 8.x
1

I run
/usr/bin/clustercheck > /dev/null
echo $?
1 un-synced node

I have 3 node all doing this.

# Edit to your requirements.
[client]
socket=/var/run/mysqld/mysqld.sock

[mysqld]
port = 3307
server-id=1
datadir=/var/lib/mysql
socket=/var/run/mysqld/mysqld.sock
log-error=/var/log/mysql/error.log
pid-file=/var/run/mysqld/mysqld.pid

# Binary log expiration period is 604800 seconds, which equals 7 days
binlog_expire_logs_seconds=604800
max_allowed_packet =128M
######## wsrep ###############
# Path to Galera library
wsrep_provider=/usr/lib/galera4/libgalera_smm.so
general_log_file = /var/log/mysql/mysql-1.log
#general_log      = 1
# Cluster connection URL contains IPs of nodes
#If no IP is found, this implies that a new cluster needs to be created,
#in order to do that you need to bootstrap this node
wsrep_cluster_address=gcomm://10.70.1.31,10.70.1.32,10.70.1.33

# In order for Galera to work correctly binlog format should be ROW
binlog_format=ROW

# Slave thread to use
wsrep_slave_threads=8

wsrep_log_conflicts

# This changes how InnoDB autoincrement locks are managed and is a requirement for Galera
innodb_autoinc_lock_mode=2

# Node IP address
wsrep_node_address=10.70.1.31
# Cluster name
wsrep_cluster_name=pxc-cluster

#If wsrep_node_name is not specified,  then system hostname will be used
wsrep_node_name=na7kr-mysql-1

#pxc_strict_mode allowed values: DISABLED,PERMISSIVE,ENFORCING,MASTER
pxc_strict_mode=DISABLED

# SST method
wsrep_sst_method=xtrabackup-v2

pxc-encrypt-cluster-traffic=OFF1

What is my problem?

2

How do I change script port to 3307?

1 Like
3

Hi, you can try running the script with

bash -x /usr/bin/clustercheck

This way it should be easier to debug. To specify a custom port, you can add it to EXTRA_ARGS=“”
section.

1 Like
4

Fixed it thanks -P 3307 in mysql line

1 Like