MySQL Forums
Forum List  »  NDB clusters

Re: Failed to allocate nodeid, error: 'Error: Could not alloc node id at .. : Connection done from wrong host
Posted by: Lars Holmström
Date: July 11, 2017 05:01AM

Thanks, you reply explained a lot of what I was looking for.

However, after reverting tomy initial configI started two data nodes.

Then I --initialized the mysql database and started the mysqld daemon. It started nicely

$ ps ax | grep mysql
64458 ? S 0:00 /bin/sh /usr/bin/mysqld_safe
64646 ? Sl 0:00 /usr/sbin/mysqld --basedir=/usr --datadir=/var/lib/mysql --plugin-dir=/usr/lib/mysql/plugin --log-error=/var/log/mysql/error.log --pid-file=/var/run/mysqld/mysqld.pid --socket=/var/run/mysqld/mysqld.sock

But it does not show up in the management console
# sudo ndb_mgm -e show
sudo: unable to resolve host vm147slmv
Connected to Management Server at: localhost:1186
Cluster Configuration
---------------------
[ndbd(NDB)] 2 node(s)
id=1 @10.215.2.70 (mysql-5.7.18 ndb-7.5.6, Nodegroup: 0, *)
id=2 @10.215.2.71 (mysql-5.7.18 ndb-7.5.6, Nodegroup: 0)

[ndb_mgmd(MGM)] 1 node(s)
id=5 @10.215.2.74 (mysql-5.7.18 ndb-7.5.6)

[mysqld(API)] 2 node(s)
id=3 (not connected, accepting connect from 10.215.2.72)
id=4 (not connected, accepting connect from 10.215.2.73)

Mgmt #

What have I missed?

Options: ReplyQuote


Subject
Views
Written By
Posted
Re: Failed to allocate nodeid, error: 'Error: Could not alloc node id at .. : Connection done from wrong host
28
July 11, 2017 05:01AM


Sorry, only registered users may post in this forum.

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.