MySQL Forums
Forum List  »  NDB clusters

Re: Failed to allocate nodeid for mysqld
Posted by: Jon Stephens
Date: July 06, 2021 06:34AM

Quote

the data nodes do not show up when I try with - mysql -u root -p (SHOW ENGINE NDB STATUS \G).

Not sure what you mean by this.

(BTW, the correct syntax is mysql -uroot -p 'SHOW ENGINE NDB STATUS', with quotes, not parentheses; also, no statement termination character is needed when you run a statement in this fashion.)

What exactly is missing from your output that is shown at https://dev.mysql.com/doc/refman/8.0/en/show-engine.html#show-engine-ndb-status ? If you mean individual data nodes, they're not shown by this statement--the SQL statement SHOW ENGINE NDB STATUS shows only the number of data nodes connected to the cluster, and in order to provide this information, the SQL node you run it on must be connected to the cluster.

To see the connection status of individual nodes, use SHOW in the ndb_mgm client.

cheers

Jon Stephens
MySQL Documentation Team @ Oracle
Orlando, Florida, USA

MySQL Dev Zone
MySQL Server Documentation
Oracle

Options: ReplyQuote


Subject
Views
Written By
Posted
Re: Failed to allocate nodeid for mysqld
93
July 06, 2021 06:34AM


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.