MySQL Forums
Forum List  »  NDB clusters

Error while trying ndb_restore
Posted by: Nisa Apriliyanti
Date: November 28, 2023 03:07AM

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.

Options: ReplyQuote


Subject
Views
Written By
Posted
Error while trying ndb_restore
188
November 28, 2023 03:07AM
125
November 28, 2023 03:57AM
72
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.