ndb cluster集群备份恢复报错NDBT_ProgramExit

[ root@T2 BACKUP]# ndb_restore -n2 -b1 -r -m --backup_path=/var/mysql/data/BACKUP/BACKUP-1

Nodeid = 2

Backup Id = 1

backup path = /var/mysql/data/BACKUP/BACKUP-1

Opening file '/var/mysql/data/BACKUP/BACKUP-1/BACKUP-1.2.ctl'

File size 21368 bytes

Backup version in files: ndb-6.3.11 ndb version: mysql-5.6.29 ndb-7.4.11

Stop GCP of Backup: 11440

Failed to initialize consumers

NDBT_ProgramExit: 1 - Failed

解决办法

[ root@T4 mysql-cluster]# ndb_mgm -e shutdown

Connected to Management Server at: localhost:1186

3 NDB Cluster node(s) have shutdown.

Disconnecting to allow management server to shutdown.

[ root@T4 mysql-cluster]# ls

ndb_1_config.bin.1

[ root@T4 mysql-cluster]#  rm ndb_1_config.bin.1 

rm: remove regular file `ndb_1_config.bin.1'? y

[ root@T4 mysql-cluster]# vi /var/lib/mysql-cluster/config.ini

添加

[MYSQLD]

其余为空

[root@T2 BACKUP]# service mysql stop 

在重启集群

1. 启动管理节点：ndb_mgmd -f /var/lib/mysql-cluster/config.ini

2. 启动存储节点：ndbd --initial

   初次启动时需要加--initial参数，以后只需要执行ndbd即可；

3. 启动SQL节点：service mysql start

继续开始恢复

[ root@T2 BACKUP]# ndb_restore -n2 -b1 -r -m --backup_path=/var/mysql/data/BACKUP/BACKUP-1

Nodeid = 2

Backup Id = 1

backup path = /var/mysql/data/BACKUP/BACKUP-1

Opening file '/var/mysql/data/BACKUP/BACKUP-1/BACKUP-1.2.ctl'

File size 21368 bytes

Backup version in files: ndb-6.3.11 ndb version: mysql-5.6.29 ndb-7.4.11

Stop GCP of Backup: 11440

Connected to ndb!!

Successfully restored table `test/def/fafa`

Successfully restored table event REPL$test/fafa

Create foreign keys

Create foreign keys done

Opening file '/var/mysql/data/BACKUP/BACKUP-1/BACKUP-1-0.2.Data'

File size 26088 bytes

_____________________________________________________

Processing data in table: test/def/fafa(10) fragment 0

_____________________________________________________

Processing data in table: mysql/def/NDB$BLOB_7_3(8) fragment 0

_____________________________________________________

Processing data in table: mysql/def/ndb_index_stat_sample(5) fragment 0

_____________________________________________________

Processing data in table: sys/def/NDB$EVENTS_0(3) fragment 0

_____________________________________________________

Processing data in table: mysql/def/ndb_apply_status(9) fragment 0

_____________________________________________________

Processing data in table: mysql/def/ndb_index_stat_head(4) fragment 0

_____________________________________________________

Processing data in table: sys/def/SYSTAB_0(2) fragment 0

_____________________________________________________

Processing data in table: mysql/def/ndb_schema(7) fragment 0

Opening file '/var/mysql/data/BACKUP/BACKUP-1/BACKUP-1.2.log'

File size 52 bytes

Restored 0 tuples and 0 log entries

NDBT_ProgramExit: 0 - OK

成功！