[
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
成功!