Hello everyone

I am trying to make a cluster on tow computers. This is my config.ini

# This file is placed in the start directory of ndb_mgmd,

# the management server.

[COMPUTER DEFAULT]

[DB DEFAULT]

NoOfReplicas:2

[API DEFAULT]

[MGM DEFAULT]

ArbitrationRank:1

[TCP DEFAULT]

PortNumber:28002

[COMPUTER]

Id:1

HostName:ecom.baidu.com

[COMPUTER]

Id:2

HostName:huimin.baidu.com

[MGM]

Id:1

ExecuteOnComputer:1

PortNumber:2200

[DB]

Id: 2

ExecuteOnComputer:1

FileSystemPath:/home/liulz/local/mysql416/mysql-cluster/node2/

[DB]

Id: 3

ExecuteOnComputer:2

FileSystemPath:/rd0/chenqy/local/mysql416/mysql-cluster/node3/

[API]

Id: 4

ExecuteOnComputer:1

[API]

Id: 5

ExecuteOnComputer:2

I have start all the mgm node and db node but I got this:

NDB> show

Cluster Configuration

---------------------

[ndbd(NDB)] 2 node(s)

id=2 @127.0.0.1 (Version: 3.5.2, starting, Nodegroup: 0)

id=3 (not connected, accepting connect from huimin.baidu.com)

[ndb_mgmd(MGM)] 1 node(s)

id=1 @127.0.0.1 (Version: 3.5.2)

[mysqld(API)] 2 node(s)

id=4 (not connected, accepting connect from ecom.baidu.com)

id=5 (not connected, accepting connect from huimin.baidu.com)

NDB>

Here are the logs:

ndb_1_cluster.log:

2004-10-20 15:19:58 [MgmSrvr] INFO -- NDB Cluster Management Server. Version 3.5.2

2004-10-20 15:19:58 [MgmSrvr] INFO -- Id: 1, Command port: 2200

2004-10-20 15:20:35 [MgmSrvr] INFO -- Node 2: Start phase 1 completed

ndb_2_out.log:

2004-10-20 15:20:02 [NDB] INFO -- Angel pid: 7536 ndb pid: 7537

2004-10-20 15:20:02 [NDB] INFO -- NDB Cluster -- DB node 2

2004-10-20 15:20:02 [NDB] INFO -- Version 3.5.2 --

2004-10-20 15:20:02 [NDB] INFO -- Configuration fetched at ecom.baidu.com port 2200

ecom.baidu.com.err:

041020 15:25:18 mysqld started

041020 15:25:18 InnoDB: Started; log sequence number 0 44044

/home/liulz/local/mysql416/bin/mysqld: ready for connections.

Version: '4.1.6-gamma-max-log' socket: '/home/liulz/tmp/mysql416.sock' port: 1978 Official MySQL-

max binary

ndb_3_out.log:

2004-10-20 15:06:18 [NDB] INFO -- Angel pid: 18969 ndb pid: 18970

2004-10-20 15:06:18 [NDB] INFO -- NDB Cluster -- DB node 3

2004-10-20 15:06:18 [NDB] INFO -- Version 3.5.2 --

2004-10-20 15:06:18 [NDB] INFO -- Configuration fetched at ecom.baidu.com port 2200

huimin.baidu.com.err:

041020 15:07:04 mysqld started

041020 15:07:04 InnoDB: Started; log sequence number 0 43780

/rd0/chenqy/local/mysql416/bin/mysqld: ready for connections.

Version: '4.1.6-gamma-max-log' socket: '/rd0/chenqy/tmp/mysql416.sock' port: 1978 Official MySQL-

max binary

I have checked the logs few times, but I can’t find anything abnormal. In the ndb_3_out.log,it seems to be start up successfully,but I didn’t see the node 3 in ndb_mgm.

Anyone can tell me what wrong? Thanks!

I appreciate your offering me an example. I only want to make a cluster on tow computers, NoOfReplicas can be 2 or 4. thank you very much!

Yours