MySQL Cluster Data node can’t get the node ID?

I have a MySQL Multi Node ( Cluster ) like this

A is ndb_mgmd and also the client

B and C is ndbd

I have successfully set up everything but the Data Node just cant get the Node Id.

In ndb_mgmd server when I use ndb_mgm and show, I got something like this:

Connected to Management Server at: xxxx:1186
Cluster Configuration
[ndbd(NDB)] 2 node(s)
id=2    @xxxxxxxx  (mysql-8.0.21 ndb-8.0.21, Nodegroup: 0)
id=3    @xxxxxxxx (mysql-8.0.21 ndb-8.0.21, Nodegroup: 0, *)

[ndb_mgmd(MGM)] 1 node(s)
id=1    @xxxxxxxx  (mysql-8.0.21 ndb-8.0.21)

[mysqld(API)]   1 node(s)
id=4    @xxxxxxxx  (mysql-8.0.21 ndb-8.0.21)

I even show NodeId=2 status and got this :

ndb_mgm> 2 status
Connected to Management Server at: xxxxxxxx:1186
Node 2: started (mysql-8.0.21 ndb-8.0.21)

The problem is in the Ndbd server somehow it cant get the ID:

2020-09-05 22:51:13 [ndbd] INFO     -- Angel connected to 'xxxxxxx:1186'
2020-09-05 22:51:43 [ndbd] ERROR    -- Failed to allocate nodeid, error: 'Error: Could not alloc node id at xxxxxxxxx port 1186: No free node id found for ndbd(NDB).'

Things i have tried :

  1. See if the config.ini got problem but everthing look fine: ndbd nodeid , etc
  2. Check my.cnf in ndbd server : The ndb-connectstring point to ndb_mgm server .

Thanks for reading this question .

Go to Source
Author: Ta219