Re: Failed to allocate nodeid for mysqld

[Mauritz Sundell]

Hi Deepak

You have ndb_cluster_connection_pool=16, this means that the mysql server will connect to cluster using 16 connections, and by that also need 16 node ids.
You need lots of more [API] sections in config.ini, at least 16 per mysqld, and a few more to be able to run arbitrarily ndb command line tool.


But first thing to try would be to revert that settings and keep the default (1) for ndb_cluster_connection_pool. Only raise it in small steps if there are reason to believe it is needed and make sure to follow up with measurements.


In later releases (8.0) the default setting is good, in a few cases using 2 has given some improvement but this is not the first parameter to change.



Also if you set ndb_cluster_connection_pool to more than 1 it is recommended to also set the node id to use for each connection with ndb-cluster-connection-pool-nodeids, else there may be issues when a mysql server want to reconnect to a cluster while other programs, other mysqld or ndb command line tools, starting or reconnecting without explicit node id to use since they then may compete to reuse same node ids.

Regards,
Mauritz