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


Subject
Views
Written By
Posted
37
May 07, 2018 09:50AM
Re: Cluster SQL Nodes Not connecting
14
May 10, 2018 02:11AM


Sorry, only registered users may post in this forum.

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.