From: Olivier Kaloudoff
Date: October 19 2004 9:39am
Subject: Re: why the 7th node(API) does not start ? thanks
List-Archive: http://lists.mysql.com/cluster/918
Message-Id: <Pine.LNX.4.61.0410190936000.5328@nec>
MIME-Version: 1.0
Content-Type: MULTIPART/MIXED; BOUNDARY="-1463800832-2105229515-1098178790=:5328"

---1463800832-2105229515-1098178790=:5328
Content-Type: TEXT/PLAIN; charset=ISO-8859-1; format=flowed
Content-Transfer-Encoding: 8BIT

Hi,


 	I presume the second mysql API node is requesting access to port 
3306 that has already been taken by API node 6.

 	(lsof -i is your friend).

 	When starting the API node, you should be able to get the error
messages inside the <hostname>.err file next to the pid file and data 
files for this server.

 	You can tell mysqld to listen to port 3307 for example with the 
command line argument --port=3307 .


Regards,


Olivier Kaloudoff
CKR Solutions Open Source
http://www.ckr-solutions.com


On Tue, 19 Oct 2004, [gb2312] 刘兰增 wrote:

>
>
> The config.ini
>
>
>
> #config.ini" - showing minimal setup with 4 DB node
>
> # This file is placed in the start directory of ndb_mgmd,
>
> # the management server.
>
>
>
> [COMPUTER DEFAULT]
>
>
>
> [DB DEFAULT]
>
> NoOfReplicas: 4
>
>
>
> [API DEFAULT]
>
> ArbitrationRank: 2
>
>
>
> [MGM DEFAULT]
>
> ArbitrationRank: 1
>
>
>
> [TCP DEFAULT]
>
> PortNumber: 28002
>
>
>
> [COMPUTER]
>
> Id:1
>
> HostName: localhost
>
>
>
> [MGM]
>
> Id:1
>
> ExecuteOnComputer: 1
>
> PortNumber: 2200
>
>
>
> [DB]
>
> Id: 2
>
> ExecuteOnComputer: 1
>
> FileSystemPath: /home/liulz/local/mysql416/mysql-cluster/node2/
>
>
>
> [DB]
>
> Id: 3
>
> ExecuteOnComputer: 1
>
> FileSystemPath: /home/liulz/local/mysql416/mysql-cluster/node3/
>
>
>
> [DB]
>
> Id: 4
>
> ExecuteOnComputer: 1
>
> FileSystemPath: /home/liulz/local/mysql416/mysql-cluster/node4/
>
>
>
> [DB]
>
> Id: 5
>
> ExecuteOnComputer: 1
>
> FileSystemPath: /home/liulz/local/mysql416/mysql-cluster/node5/
>
>
>
> [API]
>
> Id: 6
>
> ExecuteOnComputer: 1
>
>
>
> [API]
>
> Id: 7
>
> ExecuteOnComputer: 1
>
>
>
> After start up all the mgm node and db node
>
>
>
> NDB> show
>
> Cluster Configuration
>
> ---------------------
>
> [ndbd(NDB)]     4 node(s)
>
> id=2    @127.0.0.1  (Version: 3.5.2, Nodegroup: 0, Master)
>
> id=3    @127.0.0.1  (Version: 3.5.2, Nodegroup: 0)
>
> id=4    @127.0.0.1  (Version: 3.5.2, Nodegroup: 0)
>
> id=5    @127.0.0.1  (Version: 3.5.2, Nodegroup: 0)
>
>
>
> [ndb_mgmd(MGM)] 1 node(s)
>
> id=1    @127.0.0.1  (Version: 3.5.2)
>
>
>
> [mysqld(API)]   2 node(s)
>
> id=6   (Version: 3.5.2)
>
> id=7 (not connected, accepting connect from localhost)
>
>
>
> NDB>
>
>
>
> Why that? Something must be wrong
>
>
>
>       Yours
>
> --
>
>
>
> 刘 兰 增
> -----------------------------------------------
> 电子商务组
> 软件工程师 （Software Engineer）
> 百度在线网络技术（北京）有限公司
> 北京市中关村广场理想国际大厦12层
> 手机：13910272431
> 电话：010-82621188-605
> E-mail: liulanzeng@stripped
> ----------------------------------------------
> <http://www.baidu.com/> http://www.baidu.com
>
>
>
>
---1463800832-2105229515-1098178790=:5328--