MySQL Forums
Forum List  »  NDB clusters

Is mysqld connecting?
Posted by: Alex Mace
Date: November 04, 2005 06:15AM

I'm trying to setup a test cluster here to catch any gotchas I might come across in a production environment. At the moment I've got the management server setup and running fine, and I can get data nodes to connect to it fine.

Seemingly though, there is something that mysqld doesn't like because the Management node doesn't seem to show it is connected. This is the output I get from the management client -

-- NDB Cluster -- Management Client --
ndb_mgm> show
Connected to Management Server at: 10.1.1.79:1186
Cluster Configuration
---------------------
[ndbd(NDB)] 2 node(s)
id=2 (not connected, accepting connect from 10.1.1.78)
id=3 @10.1.1.77 (Version: 5.0.15, starting, Nodegroup: 0, Master)

[ndb_mgmd(MGM)] 1 node(s)
id=1 @10.1.1.79 (Version: 5.0.15)

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

ndb_mgm>

No mysqlds. However, when I issue a shutdown command, the .err log for the mysqld server shows that it's lost it's connection to the management server, and is going to try to reconnect. Which would seem to suggest that it is connected. Is there something I'm missing here?

Here's my my.cnf

[mysqld]
ndbcluster
ndb-connectstring=10.1.1.79
[mysql_cluster]
ndb-connectstring=10.1.1.79

and my config.ini

[NDBD DEFAULT]
NoOfReplicas=2
DataMemory=500M
IndexMemory=100M
[MYSQLD DEFAULT]
[NDB_MGMD DEFAULT]
[TCP DEFAULT]
[NDB_MGMD]
HostName=10.1.1.79
[NDBD]
HostName=10.1.1.78
DataDir=/var/lib/mysql-cluster
[NDBD]
HostName=10.1.1.77
DataDir=/var/lib/mysql-cluster
[MYSQLD]
[MYSQLD]

Any ideas please?

Options: ReplyQuote


Subject
Views
Written By
Posted
Is mysqld connecting?
2359
November 04, 2005 06:15AM
1405
November 13, 2005 06:08PM
1619
November 17, 2005 09:51AM
1531
November 15, 2005 04:46PM
1516
November 15, 2005 05:50PM
1525
November 17, 2005 08:49AM
1429
November 17, 2005 09:52AM


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.