I am setting up a 3 node mysql galera cluster lab environment. All 3 nodes are centos 7 and followed the steps in below blog to setup mysql-wsrep-5.7
After setting up i am starting the first node by executing
But mysql service fails to start with below error in log
2019-02-04T13:13:10.053481Z 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 2019-02-04T13:13:10.053494Z 0 [ERROR] WSREP: gcs/src/gcs_core.cpp:gcs_core_open():209: Failed to open backend connection: -110 (Connection timed out) 2019-02-04T13:13:10.053635Z 0 [ERROR] WSREP: gcs/src/gcs.cpp:gcs_open():1458: Failed to open channel 'galera_cluster' at 'gcomm://192.168.50.50:3306,192.168.50.51:3306, 192.168.50.52:3306': -110 (Connection timed out) 2019-02-04T13:13:10.053647Z 0 [ERROR] WSREP: gcs connect failed: Connection timed out 2019-02-04T13:13:10.053652Z 0 [ERROR] WSREP: wsrep::connect(gcomm://192.168.50.50:3306,192.168.50.51:3306,192.168.5.52:3306) failed: 7 2019-02-04T13:13:10.053661Z 0 [ERROR] Aborting
Form the log it is clear that its is not starting up as the first node in cluster as it should do, rather it is trying to establish connection to other nodes.
I also checked
safe_to_bootstrap is already set to 1. But still i dont know why this behavior.
How should i start up the first node in Mysql galera cluster in first node
Thanks in advance.