I am researching MySQL cluster. For the purpose, I do a demo with 4 virtual machines. I have some problems in practice.


My topology contains four nodes Node 1: management node, ip address Node 2: sql node, ip address Node 3: data node 1, ip address Node 4: data node 2, ip address

Other information

  • Linux OS: Centos 6.4, 32 bits
  • Linux kernel: 2.6.32-358.el6.i686
  • MySQL Cluster version: MySQL-Cluster-gpl-7.3.6-2.el6.i686.rpm-bundle.tar
  • RAM 128MB
  • Turned off firewall iptables
  • Disabled selinux


  • On all four nodes, I install MySQL-Cluster-server-gpl-7.3.6-2.el6.i686.rpm and MySQL-Cluster-shared-compat-gpl-7.3.6-2.el6.i686.rpm
  • Except Node 2 - sql node, I install more MySQL-Cluster-client-gpl-7.3.6-2.el6.i686.rpm


On node 1 - management node

  • Make directory /var/lib/mysql-cluster, assign owner:group is mysql:mysql
  • Make /var/lib/mysql-cluster/config.ini:

    [ndbd default]

    [tcp default]





On node 2 - sql node

datadir = /var/lib/mysql
port = 3306


On node 3 and node 4 - data nodes

  • Make directory /usr/local/mysql/data, assign owner:group is mysql:mysql
  • Config /etc/my.cnf:

    [mysqld] ndbcluster

    [mysql_cluster] ndb-connectstring=

Start up

On management node, I run: ndb_mgmd -f /var/lib/mysql-cluster/config.ini On data node 1 và 2, I run: ndbd Finally, on sql node, I run: mysqld_safe &


ndb_mgm> show
Connected to Management Server at: localhost:1186
Cluster Configuration
[ndbd(NDB)]     2 node(s)
id=2 (not connected, accepting connect from
id=3    @  (mysql-5.6.19 ndb-7.3.6, starting, Nodegroup: 0)

[ndb_mgmd(MGM)] 1 node(s)
id=1    @  (mysql-5.6.19 ndb-7.3.6)

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


Node 2: Forced node shutdown completed. Occured during startphase 0. Initiated by signal 11.

There is ndb_2_error.log in /usr/local/mysql/data of node 2

The content of ndb_2_error.log:

Time: Monday 28 July 2014 - 09:45:01
Status: Temporary error, restart node
Message: WatchDog terminate, internal error or massive overload on the machine running this node (Internal error, programming error or missing error message, please report a bug)
Error: 6050
Error data: Job Handling
Error object: /export/home/pb2/build/sb_0-12598553-1404293345.9/rpm/BUILD/mysql-cluster-gpl-7.3.6/mysql-cluster-gpl-7.3.6/storage/ndb/src/kernel/vm/WatchDog.cpp
Program: ndbd
Pid: 1709
Version: mysql-5.6.19

Warning for three nodes: node 2, node 3 and node 4

2014-07-28 09:47:23 [MgmtSrvr] WARNING  -- Failed to allocate nodeid for API at Returned error: 'No free node id found for mysqld(API).'
2014-07-28 09:47:23 [MgmtSrvr] WARNING  -- Failed to allocate nodeid for API at Returned error: 'No free node id found for mysqld(API).'
2014-07-28 09:47:23 [MgmtSrvr] WARNING  -- Failed to allocate nodeid for API at Returned error: 'No free node id found for mysqld(API).'

Thanks for your time.

1 Answer 1


Without looking in detail to your configuration, I would bet that your problem is the kernel doing an Out of memory (OOM) kill: killing some of your ndbd, etc. processes. Those are usually logged to /var/log/messages, so you can confirm it easily.

128MB of ram, 32-bits

I am not 100% sure if you can run an NDB cluster with those spects, but I can tell you that, in practice, you do not want. Here it is a guide on how much memory consumption you can more or less expect from NDB. Remember that NDB preallocates most of its memory at first execution, ant that it is a memory-focused transactional engine. Increase its available ram and/or reduce some of its configuration parameters.

  • Thanks for your answer. I have deployed MySQL cluster on more powerful machines (Each one has 6GB Ram, 4CPUs, Centos 64 bits ) MySQL cluster works very well. You are right. The cause of problem is limited resources. 128MB is very little. Commented Jul 31, 2014 at 7:40

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service and acknowledge you have read our privacy policy.

Not the answer you're looking for? Browse other questions tagged or ask your own question.