Hello All,
Can some one help...please...
I created mysql_cluster with two db nodes and one API node.Config.ini is given below...
I can create about 30 tables and then both the nodes are automaticaly shutdown...
and also API status shows not connected...
show command displays ....
[ndbd(NDB)] 2 node(s)
id=2 (not connected, accepting connect from 192.168.2.247)
id=3 (not connected, accepting connect from 192.168.2.246)
[ndb_mgmd(MGM)] 1 node(s)
id=1 @192.168.2.247 (Version: 3.5.3)
[mysqld(API)] 1 node(s)
id=5 (not connected, accepting connect from 192.168.2.248)
# config.ini" - showing minimal setup consisting of 1 DB node,
# 1 management server, and 3 MySQL servers.
# The empty default sections are not needed, and are shown only for clarity.
# Storage nodes are required to provide a host name but MySQL Servers
# are not. Thus the configuration can be dynamic as to setting up the
# MySQL Servers.
# If you don't know the host name of your machine, use localhost.
# The DataDir parameter also has a default value, but it is recommended to
# set it explicitly.
# NDBD, MYSQLD, and NDB_MGMD are aliases for DB, API, and MGM respectively
#
[DB DEFAULT]
NoOfReplicas=2
MaxNoOfOrderedIndexes=1000
DataDir=/usr/local/mysql/mysql-cluster
[COMPUTER]
Id:47
HostName: 192.168.2.247
[COMPUTER]
Id: 48
HostName: 192.168.2.248
[COMPUTER]
Id: 46
HostName: 192.168.2.246
[MGM]
Id:1
ExecuteOnComputer:47
ArbitrationRank: 1
DataDir = /usr/local/mysql/mysql-cluster
[DB]
Id:2
ExecuteOnComputer: 47
FileSystemPath: /usr/local/mysql/mysql-cluster
[DB]
Id:3
ExecuteOnComputer: 46
FileSystemPath: /usr/local/mysql/mysql-cluster
[API]
Id:5
ExecuteOnComputer:48
Regards,
Alpesh