Setting up MySQL-Cluster

Ok so ive installed MySQL cluster with the following.

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

https://www.digitalocean.com/community/tutorials/how-to-create-a-multi-node-mysql-cluster-on-ubuntu-18-04

Reply

Please enter an answer
Tips:

You can mention users to notify them: @username

You can use Markdown to format your question. For more examples see the Markdown Cheatsheet.

> I’m a blockquote.

I’m a blockquote.

[I'm a link] (https://www.google.com)

I'm a link

**I am bold** I am bold

*I am italicized* I am italicized

Community Code of Conduct