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
>
>
>
>
