# Node not able to join the cluster - PXC 8.0.27 **URL:** \ **Category:** Percona XtraDB Cluster 8.x\ **Tags:** mysql, percona\ **Created:** [May 26, 2022, 7:43am UTC](https://forums.percona.com/t/node-not-able-to-join-the-cluster-pxc-8-0-27/15838 "2022-05-26T07:43:47Z")\ **Posts on this page:** 9\ **Page:** 1
**Author:** ![AneeshBabu](https://sea1.discourse-cdn.com/flex019/user_avatar/forums.percona.com/aneeshbabu/32/1393_2.png) [@AneeshBabu](https://forums.percona.com/u/AneeshBabu)\ **Post date:** [May 26, 2022, 7:43am UTC](https://forums.percona.com/t/node-not-able-to-join-the-cluster-pxc-8-0-27/15838/1 "2022-05-26T07:43:47Z")
# Use case : Node not able to join the cluster ,Percona XtraDB Cluster 8.0.27 Hi there, I configured 3 node(n1,n2 & n3) cluster ,all the three nodes are online. Due to huge connections ,the ‘node n3’ is down.In the meantime n1 and n2 nodes are processing the workloads. When iam trying to add the ‘node-n3’ to cluster , iam facing the below error. Please let me know how do i bring the ‘node-n3’ online. ```auto 2022-05-26T17:22:58.778759+05:30 0 [Note] [MY-000000] [Galera] (b5351f19-a07a, 'ssl://0.0.0.0:4567') connection to peer 00000000-0000 with addr ssl://192.168.1.2:4567 timed out, no messages seen in PT3S, socket stats: rtt: 132 rttvar: 66 rto: 3216000 lost: 1 last_data_recv: 26619706 cwnd: 1 last_queued_since: 26919705827915 last_delivered_since: 26919705827915 send_queue_length: 0 send_queue_bytes: 0 (gmcast.peer_timeout) 2022-05-26T17:23:02.279023+05:30 0 [Note] [MY-000000] [Galera] (b5351f19-a07a, 'ssl://0.0.0.0:4567') connection to peer 00000000-0000 with addr ssl://192.168.1.1:4567 timed out, no messages seen in PT3S, socket stats: rtt: 137 rttvar: 68 rto: 3216000 lost: 1 last_data_recv: 26623207 cwnd: 1 last_queued_since: 26923206088048 last_delivered_since: 26923206088048 send_queue_length: 0 send_queue_bytes: 0 (gmcast.peer_timeout) ``` ---
**Author:** ![A\_Niu](https://sea1.discourse-cdn.com/flex019/user_avatar/forums.percona.com/a_niu/32/5518_2.png) [@A\_Niu](https://forums.percona.com/u/A_Niu)\ **Post date:** [May 26, 2022, 11:06am UTC](https://forums.percona.com/t/node-not-able-to-join-the-cluster-pxc-8-0-27/15838/2 "2022-05-26T11:06:26Z")
@AneeshBabu what is your k8s node version? ---
**Author:** ![AneeshBabu](https://sea1.discourse-cdn.com/flex019/user_avatar/forums.percona.com/aneeshbabu/32/1393_2.png) [@AneeshBabu](https://forums.percona.com/u/AneeshBabu)\ **Post date:** [May 26, 2022, 11:12am UTC](https://forums.percona.com/t/node-not-able-to-join-the-cluster-pxc-8-0-27/15838/3 "2022-05-26T11:12:07Z")
@A_Niu Iam not using k8s. ---
**Author:** ![Wayne\_Leutwyler](https://sea1.discourse-cdn.com/flex019/user_avatar/forums.percona.com/wayne_leutwyler/32/20829_2.png) [@Wayne\_Leutwyler](https://forums.percona.com/u/Wayne_Leutwyler)\ **Post date:** [May 26, 2022, 12:02pm UTC](https://forums.percona.com/t/node-not-able-to-join-the-cluster-pxc-8-0-27/15838/4 "2022-05-26T12:02:02Z")
There are very few details of the issue for anyone to try and help you. Please provide more details of how your cluster is setup, samples of the my.cnf from the nodes pay special attention to the cluster settings. ---
**Author:** ![AneeshBabu](https://sea1.discourse-cdn.com/flex019/user_avatar/forums.percona.com/aneeshbabu/32/1393_2.png) [@AneeshBabu](https://forums.percona.com/u/AneeshBabu)\ **Post date:** [May 26, 2022, 12:14pm UTC](https://forums.percona.com/t/node-not-able-to-join-the-cluster-pxc-8-0-27/15838/5 "2022-05-26T12:14:50Z")
@Wayne_Leutwyler below are the config files of three nodes. ```auto # Config file for PXC 8.0.27 Node 1 [client] socket=/var/lib/mysql/mysql.sock [mysqld] wsrep_provider_options=”socket.ssl_key=server-key.pem;socket.ssl_cert=server-cert.pem;socket.ssl_ca=ca.pem” server-id=1 datadir =/var/lib/mysql socket=/var/lib/mysql/mysql.sock log-error=/var/log/mysqld.log pid-file=/var/run/mysqld/mysqld.pid log_timestamps = system # Binary log expiration period is 604800 seconds, which equals 7 days binlog_expire_logs_seconds=604800 wsrep_provider=/usr/lib64/galera4/libgalera_smm.so # IP address wsrep_node_address=192.168.1.1 wsrep_cluster_address=gcomm://192.168.1.1,192.168.1.2,192.168.1.3 binlog_format=row wsrep_applier_threads=64 wsrep_log_conflicts innodb_autoinc_lock_mode=2 # MySQL parameters default_storage_engine=InnoDB lower_case_table_names=1 innodb_buffer_pool_size=8G # Node IP address wsrep_cluster_name=dev-cluster wsrep_node_name=pxc1 pxc_strict_mode=ENFORCING wsrep_sst_method=xtrabackup-v2 pxc-encrypt-cluster-traffic=on [sst] encrypt = 4 ssl-ca=/etc/mysql/certs/ca.pem ssl-cert=/etc/mysql/certs/server-cert.pem ssl-key=/etc/mysql/certs/server-key.pem ``` ```auto # Config file for PXC 8.0.27 Node 2 [client] socket=/var/lib/mysql/mysql.sock [mysqld] wsrep_provider_options=”socket.ssl_key=server-key.pem;socket.ssl_cert=server-cert.pem;socket.ssl_ca=ca.pem” 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 log_timestamps = system # Binary log expiration period is 604800 seconds, which equals 7 days binlog_expire_logs_seconds=604800 wsrep_provider=/usr/lib64/galera4/libgalera_smm.so # IP address wsrep_cluster_address=gcomm://192.168.1.1,192.168.1.2,192.168.1.3 binlog_format=row wsrep_applier_threads=64 wsrep_log_conflicts innodb_autoinc_lock_mode=2 # Node IP address wsrep_node_address=192.168.1.2 wsrep_cluster_name=dev-cluster wsrep_node_name=pxc2 pxc_strict_mode=ENFORCING wsrep_sst_method=xtrabackup-v2 pxc-encrypt-cluster-traffic=ON # MySQL parameters default_storage_engine=InnoDB lower_case_table_names=1 innodb_buffer_pool_size=8G [sst] encrypt = 4 ssl-ca=/var/lib/mysql/ca.pem ssl-cert=/var/lib/mysql/server-cert.pem ssl-key=/var/lib/mysql/server-key.pem ``` ```auto # Config file for PXC 8.0.27 Node 3 [client] socket=/var/lib/mysql/mysql.sock [mysqld] wsrep_provider_options=”socket.ssl_key=server-key.pem;socket.ssl_cert=server-cert.pem;socket.ssl_ca=ca.pem” server-id=3 datadir=/var/lib/mysql socket=/var/lib/mysql/mysql.sock log-error=/var/log/mysqld.log pid-file=/var/run/mysqld/mysqld.pid log_timestamps = system # Binary log expiration period is 604800 seconds, which equals 7 days binlog_expire_logs_seconds=604800 wsrep_provider=/usr/lib64/galera4/libgalera_smm.so # IP address wsrep_node_address=192.168.1.3 wsrep_cluster_address=gcomm://192.168.1.1,192.168.1.2,192.168.1.3 binlog_format=row wsrep_applier_threads=64 wsrep_log_conflicts innodb_autoinc_lock_mode=2 #MySQL parameters default_storage_engine=InnoDB lower_case_table_names=1 innodb_buffer_pool_size=8G wsrep_log_conflicts innodb_autoinc_lock_mode=2 # Node IP address wsrep_cluster_name=dev-cluster wsrep_node_name=pxc3 pxc_strict_mode=ENFORCING wsrep_sst_method=xtrabackup-v2 pxc-encrypt-cluster-traffic=on [sst] encrypt = 4 ssl-ca=/etc/mysql/certs/ca.pem ssl-cert=/etc/mysql/certs/server-cert.pem ssl-key=/etc/mysql/certs/server-key.pem ``` ---
**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:** [May 26, 2022, 12:42pm UTC](https://forums.percona.com/t/node-not-able-to-join-the-cluster-pxc-8-0-27/15838/6 "2022-05-26T12:42:19Z")
From node3 can you ping node2? From node2 can you ping node3? ---
**Author:** ![AneeshBabu](https://sea1.discourse-cdn.com/flex019/user_avatar/forums.percona.com/aneeshbabu/32/1393_2.png) [@AneeshBabu](https://forums.percona.com/u/AneeshBabu)\ **Post date:** [May 27, 2022, 6:13am UTC](https://forums.percona.com/t/node-not-able-to-join-the-cluster-pxc-8-0-27/15838/7 "2022-05-27T06:13:17Z")
@matthewb Iam able to ping from `node3` to `node2`.But not not able to ping from `node2` to `node3`. mysql service is not running on `node3`,Please let me know how to bring the `node3` online. ---
**Author:** ![Wayne\_Leutwyler](https://sea1.discourse-cdn.com/flex019/user_avatar/forums.percona.com/wayne_leutwyler/32/20829_2.png) [@Wayne\_Leutwyler](https://forums.percona.com/u/Wayne_Leutwyler)\ **Post date:** [May 27, 2022, 11:31am UTC](https://forums.percona.com/t/node-not-able-to-join-the-cluster-pxc-8-0-27/15838/8 "2022-05-27T11:31:58Z")
Fix node2 and node3 so they can ping both ways. Once you have the networking issues sorted out, then you can try to start node3 like you started node2. ---
**Author:** ![AneeshBabu](https://sea1.discourse-cdn.com/flex019/user_avatar/forums.percona.com/aneeshbabu/32/1393_2.png) [@AneeshBabu](https://forums.percona.com/u/AneeshBabu)\ **Post date:** [May 27, 2022, 11:36am UTC](https://forums.percona.com/t/node-not-able-to-join-the-cluster-pxc-8-0-27/15838/9 "2022-05-27T11:36:03Z")
@Wayne_Leutwyler Thanks …🙂