Error while trying ndb_restore

[Nisa Apriliyanti]

Hello,
I am a student and still unfamilliar with mysql cluster. I am trying to do backup and restore.

1. I have config in config.ini for back up as followed:

## BackUp setting
## BackupDataDir automatically follow DataDir /home/user/BACKUP
BackupLogBufferSize=16M
BackupReportFrequency=10

2. This is the cluster that has been configured.

ndb_mgm> show
Cluster Configuration
---------------------
[ndbd(NDB)] 2 node(s)
id=2 @192.168.1.236 (mysql-8.0.35 ndb-8.0.35, Nodegroup: 0, *)
id=3 @192.168.1.237 (mysql-8.0.35 ndb-8.0.35, Nodegroup: 0)

[ndb_mgmd(MGM)] 1 node(s)
id=1 @192.168.1.238 (mysql-8.0.35 ndb-8.0.35)

[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)


3. I have done backup at ndb_mgm

ndb_mgm > start backup
Connected to Management Server at: localhost:1186
Waiting for completed, this may take several minutes
Node 3: Backup 1 started from node 1
Node 2: Local backup status: backup 1 started from node 1
#Records: 14001933 #LogRecords: 243288
Data: 832059592 bytes Log: 21435756 bytes
.
.
.
Node 3: Backup 1 started from node 1 completed
StartGCP: 201318 StopGCP: 201401
#Records: 28027692 #LogRecords: 656042
Data: 1665876984 bytes Log: 55078372 bytes

4. then, I try deleting some tables.

5. after that, I want to try restoring it. However there are some error, that I can't find the solution.

######First error when I shutdown ndb cluster, then only activate ndb_mgmd.

datanode236:/home/user/# ndb_restore -n 2 -b 1 -m --ndb-connectstring=192.168.1.238:1186 --ndb-nodeid=1 --backup-path=BACKUP/BACKUP-1
Nodeid = 2
Backup Id = 1
backup path = BACKUP/BACKUP-1
2023-11-28 08:37:48 [NdbApi] INFO -- Configuration error: Error: Could not alloc node id at 192.168.1.238:1186: Id 1 configured as ndb_mgmd(MGM), connect attempted as mysqld(API).
Could not connect to cluster: '1 - Configuration error: Error: Could not alloc node id at 192.168.1.238:1186: Id 1 configured as ndb_mgmd(MGM), connect attempted as mysqld(API).'


########Second Error when ndb cluster all running. At datanode 192.168.1.236:

datanode236:/home/user/#ndb_restore -n 2 -b 1 -m --ndb-connectstring=192.168.1.238:1186 --backup-path=BACKUP/BACKUP-1
Nodeid = 2
Backup Id = 1
backup path = BACKUP/BACKUP-1
2023-11-28 08:38:06 [NdbApi] INFO -- Configuration error: Error: Could not alloc node id at 192.168.1.238:1186: Connection done from wrong host ip 192.168.1.236.
Could not connect to cluster: '1 - Configuration error: Error: Could not alloc node id at 192.168.1.238:1186: Connection done from wrong host ip 192.168.1.236.'

Please help if you know what I miss.
Thank you.