Re: Second API node is not visible on the cluster.

[Mikael Ronström]

Hi Dmitry,
You need to supply the connectstring also when starting the MySQL Servers.

Rgrds Mikael
PS: See other email response on the forum for more details.

Dmitry Buzolin wrote:
> Hello!
> We set up two node cluster. Both nodes act as DB
> and API nodes, plus one runs MGM.
> We use compiled sources on Fedora Core2 linux for
> 4.1.7 MySQL database. The MGM and db nodes and one
> API node start succesfully however when I start
> second API node it starts but "show" command
> doesn't list it as connected:
>
> NDB> show
> Cluster Configuration
> ---------------------
> 2 node(s)
> id=10 @192.168.20.101 (Version: 3.5.3,
> Nodegroup: 0, Master)
> id=11 @192.168.20.102 (Version: 3.5.3,
> Nodegroup: 0)
>
> 1 node(s)
> id=1 @192.168.20.101 (Version: 3.5.3)
>
> 2 node(s)
> id=5 @127.0.0.1 (Version: 3.5.3)
> id=6 (not connected, accepting connect from
> 192.168.20.102)
>
> We don't have Ndb.cfg files instead we supply
> parameters from command line:
> ./ndbd
> --connect-string="nodeid=10;host=192.168.20.101:22
> 00"
> ./ndbd
> --connect-string="nodeid=11;host=192.168.20.101:22
> 00"
>
> Our config.ini :
>
> NoOfReplicas=2
>
>
>
>
>
>
> Id=1
> HostName=192.168.20.101
> DataDir=/var/log/mysqlmgm
>
>
> Id=10
> HostName=192.168.20.101
> DataDir=/mysqlndb
>
>
> Id=11
> HostName=192.168.20.102
> DataDir=/mysqlndb
>
>
> Id=5
> HostName=192.168.20.101
>
>
> Id=6
> HostName=192.168.20.102
>
>
> Please advise what is wrong in our configuration.
> Thanks!