MySQL Forums
Forum List  »  NDB clusters

Re: Error while trying ndb_restore
Posted by: Magnus Blåudd
Date: November 28, 2023 03:57AM

Hello,

seems like you successfully managed to backup the database.

What you need is to configure at least one API node which can be used by the ndb_restore program to connect to NDB. All binaries prefixed with ndb_ connect as API nodes to the cluster and you have already configured three API nodes used by the MySQL Servers.

[mysqld(API)] 3 node(s)
id=10 @192.168.1.239 (mysql-8.0.35 ndb-8.0.35)
id=11 @192.168.1.240 (mysql-8.0.35 ndb-8.0.35)
id=12 @192.168.1.243 (mysql-8.0.35 ndb-8.0.35)

Adding a node is done by changing your configuration and restarting the system, then you will have API nodes which is available to connect using ndb_restore.

It should then look something like this:
[mysqld(API)] 5 node(s)
id=10 @192.168.1.239 (mysql-8.0.35 ndb-8.0.35)
id=11 @192.168.1.240 (mysql-8.0.35 ndb-8.0.35)
id=12 @192.168.1.243 (mysql-8.0.35 ndb-8.0.35)
id=21 (not connected, accepting connect from localhost)
id=22 (not connected, accepting connect from localhost)

Then connect using --ndb-nodeid=21 or --ndb-nodeid=22

As you seen in the error message in your post, the connect need to be done from correct ip address.

Hope this helps!

Best regards
Magnus

Options: ReplyQuote


Subject
Views
Written By
Posted
265
November 28, 2023 03:07AM
130
November 28, 2023 03:52AM
Re: Error while trying ndb_restore
164
November 28, 2023 03:57AM
113
November 29, 2023 02:12AM


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.