MySQL Forums
Forum List  »  NDB clusters

Testing mysql 5.1.14 and cluster
Posted by: Lasse Christiansen
Date: December 13, 2006 04:41AM

Hi there
I am testing a mysql cluster on currently 2 machines and now cant connect with any mysqld-clients? The mysqld doesn't give any errors in the logs or reasons why it dosn't show up in the below output from ndb_mgm with "show".


ndb_mgm> show
Cluster Configuration
---------------------
[ndbd(NDB)] 2 node(s)
id=2 @127.0.0.1 (Version: 5.1.14, starting, Nodegroup: 0, Master)
id=3 @192.168.150.50 (Version: 5.1.14, starting, Nodegroup: 0)

[ndb_mgmd(MGM)] 1 node(s)
id=1 (Version: 5.1.14)

[mysqld(API)] 2 node(s)
id=4 (not connected, accepting connect from any host)
id=5 (not connected, accepting connect from any host)

Could it be firewall issues?
I have opened the ports 1186 and 3306?


When I disabled the firewall, the following happend:

ndb_mgm> Node 2: Started (version 5.1.14)
Node 3: Started (version 5.1.14)

ndb_mgm> show
Cluster Configuration
---------------------
[ndbd(NDB)] 2 node(s)
id=2 @127.0.0.1 (Version: 5.1.14, Nodegroup: 0, Master)
id=3 @192.168.150.50 (Version: 5.1.14, Nodegroup: 0)

[ndb_mgmd(MGM)] 1 node(s)
id=1 @127.0.0.1 (Version: 5.1.14)

[mysqld(API)] 2 node(s)
id=4 @127.0.0.1 (Version: 5.1.14)
id=5 @192.168.150.50 (Version: 5.1.14)

What happened?
What ports need to be opened?

Options: ReplyQuote


Subject
Views
Written By
Posted
Testing mysql 5.1.14 and cluster
1448
December 13, 2006 04:41AM
895
December 13, 2006 01:57PM
858
December 14, 2006 05:02AM


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.