1 我先在sql节点建表,增加数据:
mysql> create table test1(age int) engine=ndbcluster default charset=utf8;
Query OK, 0 rows affected (0.26 sec)
mysql> insert into test1 values(88);
Query OK, 1 row affected (0.01 sec)
mysql> insert into test1 values(99988);
Query OK, 1 row affected (0.00 sec)
mysql> commit;
Query OK, 0 rows affected (0.00 sec)
2 在管理节点 ndb_mgm>start backup 在存储节点看到备份信息
3 sql节点删除test1 mysql> drop table test1;
4 在data节点进行恢复报错:
[root@localhost BACKUP-5]#db_restore -n 10 -b 5 -c 192.168.107.129:1186 -m --backup_path=/usr/local/mysql/data/BACKUP/BACKUP-5/
Nodeid = 10
Backup Id = 5
backup path = /usr/local/mysql/data/BACKUP/BACKUP-5/
Opening file '/usr/local/mysql/data/BACKUP/BACKUP-5/BACKUP-5.10.ctl'
File size 28896 bytes
Backup version in files: ndb-6.3.11 ndb version: mysql-5.6.28 ndb-7.4.10
Stop GCP of Backup: 207517
Failed to initialize consumers
NDBT_ProgramExit: 1 - Failed 请问为什么错误?如何解决?
下面是我config.ini的部分配置
[mysqld]
SQL node options:
id=20
hostname=192.168.107.130
[mysqld]