Hello Experts
Need your help
My cluster version is 8.4.6, ssl is not enabled, firewall is not running , selinux is switched to permissive mode
============= begin node 1 Config file ================================
[mysqld]
server-id=2
datadir=/data/mysql/pmysqlDATA
socket=/data/mysql/sockets/pmySQL84.s0ck
port=1521
innodb_buffer_pool_size=134217728
mysqlx_socket=/data/mysql/sockets/pmySQL84x.s0ck
mysqlx-port=15210
pxc_encrypt_cluster_traffic=‘OFF’
wsrep_on=ON
wsrep_provider=/data/mysql/EE/database/Percona-XtraDB-Cluster_8.4.6-6.1_Linux.x86_64.glibc2.28/lib/libgalera_smm.so
wsrep_cluster_name=“test_cluster”
wsrep_cluster_address=‘gcomm://10.1.0.6:1527,10.1.0.7:1527’
wsrep_provider_options=‘gmcast.listen_addr=tcp://10.1.0.6:1530’
wsrep_node_incoming_address=10.1.0.6
wsrep_node_name=emmbsdb02
wsrep_node_address=10.1.0.6
wsrep_sst_method=clone
wsrep_sst_receive_address=‘10.1.0.6:1532’
wsrep_node_incoming_address=‘10.1.0.6:1540’
[mysqld_safe]
log-error=/var/log/mysql/LOGpmysql846.log
pid_file=/var/run/mysql/pmysql84.pid
I was able to bootstrap node1 with following cmd :
mysqld_safe --defaults-file= --datadir=/data/mysql/pmysqlDATA --user=mysql --wsrep-new-cluster
================= begin node2 config file ================================
[mysqld]
server-id=3
datadir=/data/mysql/pmysqlDATA
socket=/data/mysql/sockets/pmySQL84.s0ck
port=1521
innodb_buffer_pool_size=134217728
mysqlx_socket=/data/mysql/sockets/pmySQL84x.s0ck
mysqlx-port=15210
pxc_encrypt_cluster_traffic=‘OFF’
wsrep_on=ON
wsrep_provider=/data/mysql/EE/database/Percona-XtraDB-Cluster_8.4.6-6.1_Linux.x86_64.glibc2.28/lib/libgalera_smm.so
wsrep_cluster_name=“test_cluster”
wsrep_cluster_address=‘gcomm://10.1.0.6:1527,10.1.0.7:1527’
wsrep_provider_options=‘gmcast.listen_addr=tcp://10.1.0.7:1530’
wsrep_node_incoming_address=10.1.0.7
wsrep_node_name=emmbsdb03
wsrep_node_address=10.1.0.7
wsrep_sst_method=clone
wsrep_sst_receive_address=‘10.1.0.7:1532’
wsrep_node_incoming_address=‘10.1.0.7:1540’
wsrep_debug=1
[mysqld_safe]
log-error=/var/log/mysql/LOGpmysql846.log
pid_file=/var/run/mysql/pmysql84.pid
================= end node2 config file ================================
[root@emmbsdb03 temp]#
Executed following cmd to join node2 to cluster , Couldnt join node2
mysqld_safe --defaults-file= --datadir=/data/mysql/pmysqlDATA --user=mysql
========================== begin node2 Error log =============================
2025-10-31T09:17:32.520213Z 0 [Note] [MY-000000] [Galera] Failed to establish connection: Connection refused
2025-10-31T09:17:33.521597Z 0 [Note] [MY-000000] [Galera] Failed to establish connection: Connection refused
2025-10-31T09:17:34.020603Z 0 [Note] [MY-000000] [Galera] Failed to establish connection: Connection refused
2025-10-31T09:17:35.020439Z 0 [Note] [MY-000000] [Galera] PC protocol downgrade 1 → 0
2025-10-31T09:17:35.020528Z 0 [Note] [MY-000000] [Galera] Current view of cluster as seen by this node
view ((empty))
2025-10-31T09:17:35.020903Z 0 [ERROR] [MY-000000] [Galera] failed to open gcomm backend connection: 110: failed to reach primary view (pc.wait_prim_timeout)
at /mnt/jenkins/workspace/pxc80-autobuild-RELEASE/test/Percona-XtraDB-Cluster-8.4.6-6/percona-xtradb-cluster-galera/gcomm/src/pc.cpp:connect():176
2025-10-31T09:17:35.020951Z 0 [ERROR] [MY-000000] [Galera] /mnt/jenkins/workspace/pxc80-autobuild-RELEASE/test/Percona-XtraDB-Cluster-8.4.6-6/percona-xtradb-cluster-galera/gcs/src/gcs_core.cpp:gcs_core_open():256: Failed to open backend connection: -110 (Connection timed out)
2025-10-31T09:17:36.021156Z 0 [Note] [MY-000000] [Galera] gcomm: terminating thread
2025-10-31T09:17:36.021219Z 0 [Note] [MY-000000] [Galera] gcomm: joining thread
2025-10-31T09:17:36.021290Z 0 [ERROR] [MY-000000] [Galera] /mnt/jenkins/workspace/pxc80-autobuild-RELEASE/test/Percona-XtraDB-Cluster-8.4.6-6/percona-xtradb-cluster-galera/gcs/src/gcs.cpp:gcs_open():1952: Failed to open channel ‘test_cluster’ at ‘gcomm://10.1.0.6:1527,10.1.0.7:1527’: -110 (Connection timed out)
2025-10-31T09:17:36.021311Z 0 [ERROR] [MY-000000] [Galera] gcs connect failed: Operation timed out
2025-10-31T09:17:36.021325Z 0 [ERROR] [MY-000000] [WSREP] Provider/Node (gcomm://10.1.0.6:1527,10.1.0.7:1527) failed to establish connection with cluster (reason: 7)
2025-10-31T09:17:36.021336Z 0 [ERROR] [MY-010119] [Server] Aborting
==========================End node2 Error log =============================