Re: Cluster SQL Nodes Not connecting

[Mikael Ronström]

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.