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 it is not starting up as the first node in the 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 don't know why I get this behaviour?
How should I start up the first node in my MySQL Galera Cluster?