Thanks for moving this thread to "NDB" forum.
The CREATE TABLE for all the tables are in
http://forums.mysql.com/read.php?25,618468,618470#msg-618470
the prefix to the table name is "pre_", so common_task is actually "pre_common_task".
NDB system layout I have is like this:
server1 --> ndb mgmt node
server2 --> ndb sql node + ndb data node
server3 --> ndb sql node + ndb data node
The output of "ndb_mgm -e show" is as follows:
# ndb_mgm -e show
Connected to Management Server at: 10.60.149.25:1186
Cluster Configuration
---------------------
[ndbd(NDB)] 2 node(s)
id=11 @10.62.51.72 (mysql-5.6.15 ndb-7.3.4, Nodegroup: 0, *)
id=12 @10.62.51.74 (mysql-5.6.15 ndb-7.3.4, Nodegroup: 0)
[ndb_mgmd(MGM)] 1 node(s)
id=1 @10.60.149.25 (mysql-5.6.15 ndb-7.3.4)
[mysqld(API)] 4 node(s)
id=21 (not connected, accepting connect from 10.62.51.72)
id=31 @10.62.51.74 (mysql-5.6.15 ndb-7.3.4)
id=91 (not connected, accepting connect from any host)
id=92 @10.62.51.72 (mysql-5.6.15 ndb-7.3.4)
The config.ini :
[TCP DEFAULT]
SendBufferMemory=8M
ReceiveBufferMemory=8M
[ndbd default]
NoOfReplicas=2
DataMemory=40000M
IndexMemory=10000M
MaxNoOfOrderedIndexes=500000
MaxNoOfUniqueHashIndexes=500000
MaxNoOfAttributes=500000
MaxNoOfExecutionThreads=10
BackupDataDir=/ndbdatabk/NDB_BACKUP
MaxNoOfConcurrentOperations=32000
[ndb_mgmd]
nodeid=1
hostname=10.60.149.25
datadir=/var/lib/mysql-cluster
[ndbd]
nodeid=12
hostname=10.62.51.74
datadir=/usr/local/mysql/data
[ndbd]
nodeid=11
hostname=10.62.51.72
datadir=/usr/local/mysql/data
[mysqld]
nodeid=31
hostname=10.62.51.74
[mysqld]
nodeid=21
hostname=10.62.51.72
[mysqld]
nodeid=91
[mysqld]
nodeid=92
The my.cnf :
# cat /etc/my.cnf
[mysqld]
ndbcluster
ndb-connectstring=10.60.149.25
character-set-server = utf8
init_connect='SET NAMES utf8'
bind-address=0.0.0.0
query_cache_type = 1
query_cache_size = 2048M
query_cache_limit = 256M
ndb-wait-setup=30
max_connections=3000
ndb-log-apply-status
connect-timeout=180
[mysql_cluster]
ndb-connectstring=10.60.149.25
[client]
default-character-set=utf8