Re: Error while trying ndb_restore

[Magnus Blåudd]

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