Failure to bootstrap node in cluster

2024-03-07T05:49:07.558915Z 0 [ERROR] WSREP: failed to open gcomm backend connection: 110: failed to reach primary view: 110 (Connection timed out)
at gcomm/src/pc.cpp:connect():158
2024-03-07T05:49:07.558943Z 0 [ERROR] WSREP: gcs/src/gcs_core.cpp:gcs_core_open():208: Failed to open backend connection: -110 (Connection timed out)
2024-03-07T05:49:07.559101Z 0 [ERROR] WSREP: gcs connect failed: Connection timed out

@Mathava_Selvan HI Selvan… Welcome to the Percona Community.

As per the error log, I see "Connection timed out” is the main error. So, Check firewall connections, se-linux or other networking access.

Also, Please verify that the following ports are open: 3306, 4444, and 4567 which are required for MySQL and PXC cluster connections.

Finally make sure to keep your wsrep parameters / wsrep.cnf to use by PXC.

Refer for similar PXC errors Getting error after configuration Percona Xtradb 8.0? - #13 by matthewb

@Mathava_Selvan, please show us how you started this node. If this is the first node, did you bootstrap it? The error you showed indicates you did not bootstrap the node.

systemctl start mysql@bootstrap