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 :
- See if the
config.ini
got problem but everthing look fine: ndbd nodeid , etc - Check
my.cnf
in ndbd server : The ndb-connectstring point to ndb_mgm server .
Thanks for reading this question .
Go to Source
Author: Ta219