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
Cluster Configuration
–-------------------
[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?
1 Reply
Check out his doc, I know it's from DO, but I have used it to setup a cluster and it does work