I am a brand new user to the MySQL cluster world (literally hours). I was following a tutorial just to get a simple cluster set up (one management node on one machine, a second machine with a SQL node and a data node). I seem to have a functioning management node and I believe I have a functioning SQL node, but my data node acts like it's connecting, but the management node says it isn't connected.
Management Node Config:
[ndbd default] NoOfReplicas= 1 MaxNoOfConcurrentOperations= 10000 DataMemory= 3072M IndexMemory= 256M TimeBetweenWatchDogCheck= 30000 DataDir= /var/lib/mysql-cluster MaxNoOfOrderedIndexes= 512 [ndb_mgmd default] DataDir= /var/lib/mysql-cluster [ndb_mgmd] NodeId=1 HostName= 192.168.0.5 [ndbd] NodeId= 2 HostName= 192.168.0.6 [mysqld] NodeId= 4 HostName = 192.168.0.6 # choose an unused port number # in this configuration 63132, 63133, and 63134 # will be used [tcp default] PortNumber= 63132
SQL Node Config:
[mysqld] ndbcluster # IP address of the cluster management node ndb-connectstring=192.168.0.5 [mysql_cluster] # IP address of the cluster management node ndb-connectstring=192.168.0.5
Data Node Config:
[mysqld] ndbcluster # IP address of the cluster management node ndb-connectstring=192.168.0.5 [MYSQL_CLUSTER] ndb-connectstring=192.168.0.5
When I run
sudo /usr/local/mysql/bin/ndbd I get:
2012-04-22 22:56:44 [ndbd] INFO -- Angel connected to '192.168.0.5:1186' 2012-04-22 22:56:44 [ndbd] INFO -- Angel allocated nodeid: 2
But when I check its status on the management node, I get:
Node 2: not connected
I'm sure as a total noob I'm just missing something, but I would really appreciate if someone could point me in the right direction.