MySQL Forums
Forum List  »  NDB clusters

Re: Cluster SQL Nodes Not connecting
Posted by: Mikael Ronström
Date: May 10, 2018 02:11AM

The MySQL Server is not starting since it tries to connect to
the cluster. The cluster is in the state "starting", so it cannot
connect to it.

So the real problem is why the data nodes aren't starting. Check
the cluster log and data node logs to find out some more about this.

I can almost bet on that the problem is in the firewall.

Set ServerPort in the NDBD section to e.g. 11860 and open this port
in your firewall and you should be fine. The data node needs a port
that other data nodes and MySQL servers can connect to.

If ServerPort isn't set it is going to use a dynamic port number
and this is hard to use if you have a firewall between the machines.

Options: ReplyQuote

Written By
May 07, 2018 09:50AM
Re: Cluster SQL Nodes Not connecting
May 10, 2018 02:11AM

Sorry, you can't reply to this topic. It has been closed.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.