Percona Xtradb cluster

MySQL & MariaDB Percona XtraDB Cluster 8.x
1

We have implemented Percona XtraDB cluster on 3 nodes ( 3 servers ). The primary is been successfully set, but we are facing issues for reaming 2 nodes.
We are facing the below error
Error - adb-cluster-galera/gcs/src/gcs.cpp:gcs_open():1880: Failed to open channel ‘pxc-cluster’ at ‘gcomm://172.30.25.233,172.30.25.207,172.30.1.161’: -110 (Connection timed out)
2024-02-02T10:18:53.478849Z 0 [ERROR] [MY-000000] [Galera] gcs connect failed: Connection timed out
2024-02-02T10:18:53.478903Z 0 [ERROR] [MY-000000] [WSREP] Provider/Node (gcomm://172.30.25.233,172.30.25.207,172.30.1.161) failed to establish connection with cluster (reason: 7)
2024-02-02T10:18:53.478945Z 0 [ERROR] [MY-010119] [Server] Aborting
2024-02-02T10:18:53.479657Z 0 [System] [MY-010910] [Server] /usr/sbin/mysqld: Shutdown complete (mysqld 8.0.35-27.1) Percona XtraDB Cluster (GPL), Release rel27, Revision 84d9464, WSREP version 26.1.4.3.

2

Ensure ports 4567, 4566, and 4568 are open between all nodes. You might also need to put SELinux into Permissive mode and/or disable apparmor.

1 Like
3

We have started the Primary successfully, but we are not able to start the other 2 nodes.
I am sharing the my.cnf file of second node. Please let me know why I am not able to start the service.

my.cnf

[root@OracleTest ~]# cat /etc/my.cnf
# Template my.cnf for PXC
# Edit to your requirements.
[client]
socket=/var/lib/mysql/mysql.sock

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

# Binary log expiration period is 604800 seconds, which equals 7 days
binlog_expire_logs_seconds=604800

######## wsrep ###############
# Path to Galera library
wsrep_provider=/usr/lib64/galera4/libgalera_smm.so

# 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://172.30.25.233,172.30.25.207,172.30.1.161

# 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=172.30.25.207
# Cluster name
wsrep_cluster_name=pxc-cluster

#If wsrep_node_name is not specified,  then system hostname will be used
wsrep_node_name=pxc-cluster-node-2

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

# SST method
wsrep_sst_method=xtrabackup-v2
4

@Aditya1, please read my previous comment. Also, provide error logs from failed joiners.