List:Cluster« Previous MessageNext Message »
From:Alpesh Date:December 9 2004 12:44pm
Subject:ndbd automaticaly shutdown after creating 31 tables
View as plain text  
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
Thread
ndbd automaticaly shutdown after creating 31 tablesAlpesh9 Dec
  • Re: ndbd automaticaly shutdown after creating 31 tablesOlivier Kaloudoff9 Dec
  • Re: ndbd automaticaly shutdown after creating 31 tablesAlpesh10 Dec
    • Re: ndbd automaticaly shutdown after creating 31 tablesOlivier Kaloudoff10 Dec
  • Re: ndbd automaticaly shutdown after creating 31 tablesAlpesh17 Dec
    • Re: ndbd automaticaly shutdown after creating 31 tablesJonas Oreland17 Dec
  • Re: ndbd automaticaly shutdown after creating 31 tablesAlpesh17 Dec