MySQL Forums
Forum List  »  NDB clusters

Re: Failed to allocate nodeid for mysqld
Posted by: Mauritz Sundell
Date: July 03, 2021 11:20AM

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

Options: ReplyQuote


Subject
Views
Written By
Posted
Re: Failed to allocate nodeid for mysqld
472
July 03, 2021 11:20AM


Sorry, you can't reply to this topic. It has been closed.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.