Setting up MySQL-Cluster
1 Management Node (Linode 512) also does nameserver and monitoring
2 Data Nodes (Linode 1024)
2 API Nodes (reside on Linode 768 aka web servers)
Here is the config on the management node
[NDBD DEFAULT] NoOfReplicas=2 #LockPagesInMainMemory=1 DataMemory=10M IndexMemory=5M ODirect=1 #NoOfFragmentLogFiles=300 #MaxNoOfConcurrentOperations=100000 #TimeBetweenGlobalCheckpoints=1000 #TimeBetweenEpochs=200 #DiskCheckpointSpeed=10M #DiskCheckpointSpeedInRestart=100M #RedoBuffer=32M # MaxNoOfLocalScans=64 #MaxNoOfTables=1024 #MaxNofOfOrderedIndexes=256 [MYSQLD DEFAULT] [NDB_MGMD DEFAULT] [TCP DEFAULT] # Managment Server #SendBufferMemory=8M #ReceiveBufferMemory=8M [NDB_MGMD] # Phoenix NodeId=1 HostName=192.168.129.23 [NDBD] # Vulcan NodeId=2 HostName=192.168.182.46 DataDir= /var/lib/mysql-cluster [NDBD] # Magneto NodeId=3 HostName=192.168.180.87 DataDir=/var/lib/mysql-cluster [MYSQLD] [MYSQLD]
Here is the data node config
[client] port=3306 socket=/var/lib/mysql/mysql.sock [mysqld] ndbcluster # IP address of the cluster management node ndb-connectstring=192.168.129.23 default-storage-engine=NDBCLUSTER #max_connections=341 #query_cache_size=16M #thread_concurrency = 4 [mysql_cluster] # IP address of the cluster management node ndb-connectstring=192.168.129.23
My Problem is when trying to launch the data node I get the following
On the data node
> [root@magneto mysql-cluster]# ndbd
2012-03-10 21:21:50 [ndbd] INFO – Angel connected to '192.168.129.23:1186'
2012-03-10 21:21:50 [ndbd] INFO – Angel allocated nodeid: 3
On the Management node
> ndb_mgm> show
[ndbd(NDB)] 2 node(s)
id=2 (not connected, accepting connect from 192.168.182.46)
id=3 @192.168.180.87 (mysql-5.5.19 ndb-7.2.4, starting, Nodegroup: 0)
[ndb_mgmd(MGM)] 1 node(s)
id=1 @192.168.129.23 (mysql-5.5.19 ndb-7.2.4)
[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> Node 3: Forced node shutdown completed. Occured during startphase 0. Initiated by signal 9.
Ive tried adjusting the memory levels but nothing that ive done has fixed this issue. I know mysql cluster uses memory, but I have no data setup yet. Our database im trying to setup is 160MB so I figure setting memory to 200MB should be good.
Any ideas, or things I should be looking at?
Check out his doc, I know it's from DO, but I have used it to setup a cluster and it does work