# Percona Xtradb cluster

**URL:** <https://forums.percona.com/t/percona-xtradb-cluster/28283>\
**Category:** Percona XtraDB Cluster 8.x\
**Created:** [February 6, 2024, 10:18am UTC](https://forums.percona.com/t/percona-xtradb-cluster/28283 "2024-02-06T10:18:53Z")\
**Posts on this page:** 4\
**Page:** 1

<div class="post-metadata">

**Author:** ![Aditya1](https://avatars.discourse-cdn.com/v4/letter/a/ea5d25/32.png) [@Aditya1](https://forums.percona.com/u/Aditya1)\
**Post date:** [February 6, 2024, 10:18am UTC](https://forums.percona.com/t/percona-xtradb-cluster/28283/1 "2024-02-06T10:18:53Z")

</div>

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.

---

<div class="post-metadata">

**Author:** ![matthewb](https://sea1.discourse-cdn.com/flex019/user_avatar/forums.percona.com/matthewb/32/34_2.png) [@matthewb](https://forums.percona.com/u/matthewb)\
**Post date:** [February 6, 2024, 4:58pm UTC](https://forums.percona.com/t/percona-xtradb-cluster/28283/2 "2024-02-06T16:58:48Z")

</div>

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.

---

<div class="post-metadata">

**Author:** ![Aditya1](https://avatars.discourse-cdn.com/v4/letter/a/ea5d25/32.png) [@Aditya1](https://forums.percona.com/u/Aditya1)\
**Post date:** [February 12, 2024, 4:53am UTC](https://forums.percona.com/t/percona-xtradb-cluster/28283/3 "2024-02-12T04:53:30Z")

</div>

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

```auto
[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
```

---

<div class="post-metadata">

**Author:** ![matthewb](https://sea1.discourse-cdn.com/flex019/user_avatar/forums.percona.com/matthewb/32/34_2.png) [@matthewb](https://forums.percona.com/u/matthewb)\
**Post date:** [February 12, 2024, 7:04pm UTC](https://forums.percona.com/t/percona-xtradb-cluster/28283/4 "2024-02-12T19:04:44Z")

</div>

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