Mysql cluster数据备份和恢复
Mysql cluster数据备份和恢复首先在管理节点备份数据，备份数据存放在每个数据节点$datadir/BACKUP目录下：
ndb_mgm> start backup 20121019 nowait;
ndb_mgm> Node 2: Backup 20121019 started from node 1
Node 2: Backup 20121019 started from node 1 completed
StartGCP: 25569 StopGCP: 25572
#Records: 2155 #LogRecords: 0
Data: 90892 bytes Log: 0 bytes
ndb_mgm> shutdown
Node 2: Cluster shutdown initiated
Node 3: Cluster shutdown initiated
3 NDB Cluster node(s) have shutdown.
Disconnecting to allow management server to shutdown.
Node 3: Node shutdown completed.
ndb_mgm> quit
# ndb_mgmd -f /var/lib/mysql/config.ini --reload
MySQL Cluster Management Server mysql-5.5.27 ndb-7.2.8
# ndb_mgm
-- NDB Cluster -- Management Client --
ndb_mgm> show
Connected to Management Server at: 192.168.163.110:1186
Cluster Configuration
---------------------
2 node(s)
id=2 @192.168.163.140(mysql-5.5.27 ndb-7.2.8, Nodegroup: 0, Master)
id=3 @192.168.163.170(mysql-5.5.27 ndb-7.2.8, Nodegroup: 0)
1 node(s)
id=1 @192.168.163.110(mysql-5.5.27 ndb-7.2.8)
3 node(s)
id=4 (not connected, accepting connect from 192.168.163.160)
id=5 (not connected, accepting connect from 192.168.163.110)
id=6 (not connected, accepting connect from any host)
id=7 (not connected, accepting connect from any host)
在一个数据节点开始数据恢复
# ndbd --ndb-connectstring=192.168.163.110:1186 --initial
2012-10-19 10:24:25 INFO -- Angel connected to '192.168.163.110:1186'
2012-10-19 10:24:25 INFO -- Angel allocated nodeid: 2
# ndb_restore -c 192.168.163.110:1186 -n 2 -b 20121019 -m -r --backup-path=/var/lib/mysql/data/BACKUP/BACKUP-20121019/
Nodeid = 2
Backup> backup path = /var/lib/mysql/data/BACKUP/BACKUP-20121019/
Opening file '/var/lib/mysql/data/BACKUP/BACKUP-20121019/BACKUP-20121019.2.ctl'
File> Backup version in files: ndb-6.3.11 ndb version: mysql-5.5.27 ndb-7.2.8
Stop GCP of Backup: 25571
Connected to ndb!!
Successfully restored table `mysql/def/ndb_db_backup`
Successfully restored table event REPL$mysql/ndb_db_backup
Successfully restored table `mysql/def/ndb_user_backup`
Successfully restored table event REPL$mysql/ndb_user_backup
Successfully restored table `jiqun2/def/tb1`
Successfully restored table event REPL$jiqun2/tb1
Successfully restored table `mysql/def/ndb_procs_priv_backup`
Successfully restored table event REPL$mysql/ndb_procs_priv_backup
Successfully restored table `mysql/def/ndb_columns_priv_backup`
Successfully restored table event REPL$mysql/ndb_columns_priv_backup
Successfully restored table `mysql/def/ndb_apply_status`
Successfully restored table event REPL$mysql/ndb_apply_status
Successfully restored table `mysql/def/ndb_tables_priv_backup`
Successfully restored table event REPL$mysql/ndb_tables_priv_backup
Successfully restored table `jiqun/def/tb1`
Successfully restored table event REPL$jiqun/tb1
Successfully restored table `jiqun/def/tb2`
Successfully restored table event REPL$jiqun/tb2
Successfully restored table `mysql/def/ndb_host_backup`
Successfully restored table event REPL$mysql/ndb_host_backup
Successfully restored table `mysql/def/ndb_schema`
Successfully restored table event REPL$mysql/ndb_schema
Successfully restored table `mysql/def/ndb_proxies_priv_backup`
Successfully restored table event REPL$mysql/ndb_proxies_priv_backup
Successfully created index `PRIMARY` on `ndb_columns_priv_backup`
Successfully created index `Grantor` on `ndb_procs_priv_backup`
Successfully created index `PRIMARY` on `ndb_user_backup`
Successfully created index `PRIMARY` on `ndb_tables_priv_backup`
Successfully created index `PRIMARY` on `ndb_host_backup`
Successfully created index `PRIMARY` on `ndb_proxies_priv_backup`
Successfully created index `PRIMARY` on `ndb_procs_priv_backup`
Successfully created index `Grantor` on `ndb_tables_priv_backup`
Successfully created index `User` on `ndb_db_backup`
Successfully created index `PRIMARY` on `ndb_db_backup`
Successfully created index `Grantor` on `ndb_proxies_priv_backup`
Opening file '/var/lib/mysql/data/BACKUP/BACKUP-20121019/BACKUP-20121019-0.2.Data'
File> _____________________________________________________
Processing data in table: mysql/def/user(34) fragment 0
_____________________________________________________
Processing data in table: mysql/def/ndb_db_backup(18) fragment 0
_____________________________________________________
Processing data in table: mysql/def/NDB$BLOB_34_41(38) fragment 0
_____________________________________________________
Processing data in table: mysql/def/NDB$BLOB_34_33(35) fragment 0
_____________________________________________________
Processing data in table: mysql/def/ndb_index_stat_sample(8) fragment 0
_____________________________________________________
Processing data in table: mysql/def/NDB$BLOB_34_34(36) fragment 0
_____________________________________________________
Processing data in table: mysql/def/ndb_user_backup(12) fragment 0
_____________________________________________________
Processing data in table: jiqun2/def/tb1(56) fragment 0
_____________________________________________________
Processing data in table: mysql/def/NDB$BLOB_34_35(37) fragment 0
_____________________________________________________
Processing data in table: mysql/def/ndb_procs_priv_backup(26) fragment 0
_____________________________________________________
Processing data in table: mysql/def/tables_priv(43) fragment 0
_____________________________________________________
Processing data in table: sys/def/NDB$EVENTS_0(3) fragment 0
_____________________________________________________
Processing data in table: mysql/def/ndb_columns_priv_backup(24) fragment 0
_____________________________________________________
Processing data in table: mysql/def/ndb_apply_status(6) fragment 0
_____________________________________________________
Processing data in table: mysql/def/ndb_index_stat_head(7) fragment 0
_____________________________________________________
Processing data in table: mysql/def/NDB$BLOB_12_41(16) fragment 0
_____________________________________________________
Processing data in table: mysql/def/NDB$BLOB_12_33(13) fragment 0
_____________________________________________________
Processing data in table: mysql/def/db(40) fragment 0
_____________________________________________________
Processing data in table: mysql/def/NDB$BLOB_12_34(14) fragment 0
_____________________________________________________
Processing data in table: mysql/def/proxies_priv(53) fragment 0
_____________________________________________________
Processing data in table: mysql/def/NDB$BLOB_12_35(15) fragment 0
_____________________________________________________
Processing data in table: mysql/def/procs_priv(48) fragment 0
_____________________________________________________
Processing data in table: mysql/def/NDB$BLOB_4_3(5) fragment 0
_____________________________________________________
Processing data in table: mysql/def/ndb_tables_priv_backup(21) fragment 0
_____________________________________________________
Processing data in table: jiqun/def/tb1(10) fragment 0
_____________________________________________________
Processing data in table: jiqun/def/tb2(11) fragment 0
_____________________________________________________
Processing data in table: mysql/def/columns_priv(46) fragment 0
_____________________________________________________
Processing data in table: mysql/def/ndb_host_backup(29) fragment 0
_____________________________________________________
Processing data in table: sys/def/SYSTAB_0(2) fragment 0
_____________________________________________________
Processing data in table: mysql/def/host(51) fragment 0
_____________________________________________________
Processing data in table: mysql/def/ndb_schema(4) fragment 0
_____________________________________________________
Processing data in table: mysql/def/ndb_proxies_priv_backup(31) fragment 0
Opening file '/var/lib/mysql/data/BACKUP/BACKUP-20121019/BACKUP-20121019.2.log'
File> Restored 15 tuples and 0 log entries
NDBT_ProgramExit: 0 - OK
#
在第二个数据节点进行数据恢复
# ndbd --ndb-connectstring=192.168.163.110:1186 --initial
2012-10-19 10:24:39 INFO -- Angel connected to '192.168.163.110:1186'
2012-10-19 10:24:39 INFO -- Angel allocated nodeid: 3
# ndb_restore -c 192.168.163.110:1186 -n 3 -b 20121019 -m -r --backup-path=/var/lib/mysql/data/BACKUP/BACKUP-20121019/
Nodeid = 3
Backup> backup path = /var/lib/mysql/data/BACKUP/BACKUP-20121019/
Opening file '/var/lib/mysql/data/BACKUP/BACKUP-20121019/BACKUP-20121019.3.ctl'
File> Backup version in files: ndb-6.3.11 ndb version: mysql-5.5.27 ndb-7.2.8
Stop GCP of Backup: 25571
Connected to ndb!!
Create table `mysql/def/ndb_db_backup` failed: 721: Schema object with given name already exists
Restore: Failed to restore table: `mysql/def/ndb_db_backup` ... Exiting
NDBT_ProgramExit: 1 - Failed
# ndb_restore -c 192.168.163.110:1186 -n 3 -b 20121019-r --backup-path=/var/lib/mysql/data/BACKUP/BACKUP-20121019/
Nodeid = 3
Backup> backup path = /var/lib/mysql/data/BACKUP/BACKUP-20121019/
Opening file '/var/lib/mysql/data/BACKUP/BACKUP-20121019/BACKUP-20121019.3.ctl'
File> Backup version in files: ndb-6.3.11 ndb version: mysql-5.5.27 ndb-7.2.8
Stop GCP of Backup: 25571
Connected to ndb!!
Opening file '/var/lib/mysql/data/BACKUP/BACKUP-20121019/BACKUP-20121019-0.3.Data'
File> _____________________________________________________
Processing data in table: mysql/def/user(34) fragment 1
_____________________________________________________
Processing data in table: mysql/def/ndb_db_backup(18) fragment 1
_____________________________________________________
Processing data in table: mysql/def/NDB$BLOB_34_41(38) fragment 1
_____________________________________________________
Processing data in table: mysql/def/NDB$BLOB_34_33(35) fragment 1
_____________________________________________________
Processing data in table: mysql/def/ndb_index_stat_sample(8) fragment 1
_____________________________________________________
Processing data in table: mysql/def/NDB$BLOB_34_34(36) fragment 1
_____________________________________________________
Processing data in table: mysql/def/ndb_user_backup(12) fragment 1
_____________________________________________________
Processing data in table: jiqun2/def/tb1(56) fragment 1
_____________________________________________________
Processing data in table: mysql/def/NDB$BLOB_34_35(37) fragment 1
_____________________________________________________
Processing data in table: mysql/def/ndb_procs_priv_backup(26) fragment 1
_____________________________________________________
Processing data in table: mysql/def/tables_priv(43) fragment 1
_____________________________________________________
Processing data in table: sys/def/NDB$EVENTS_0(3) fragment 1
_____________________________________________________
Processing data in table: mysql/def/ndb_columns_priv_backup(24) fragment 1
_____________________________________________________
Processing data in table: mysql/def/ndb_apply_status(6) fragment 1
_____________________________________________________
Processing data in table: mysql/def/ndb_index_stat_head(7) fragment 1
_____________________________________________________
Processing data in table: mysql/def/NDB$BLOB_12_41(16) fragment 1
_____________________________________________________
Processing data in table: mysql/def/NDB$BLOB_12_33(13) fragment 1
_____________________________________________________
Processing data in table: mysql/def/db(40) fragment 1
_____________________________________________________
Processing data in table: mysql/def/NDB$BLOB_12_34(14) fragment 1
_____________________________________________________
Processing data in table: mysql/def/proxies_priv(53) fragment 1
_____________________________________________________
Processing data in table: mysql/def/NDB$BLOB_12_35(15) fragment 1
_____________________________________________________
Processing data in table: mysql/def/procs_priv(48) fragment 1
_____________________________________________________
Processing data in table: mysql/def/NDB$BLOB_4_3(5) fragment 1
_____________________________________________________
Processing data in table: mysql/def/ndb_tables_priv_backup(21) fragment 1
_____________________________________________________
Processing data in table: jiqun/def/tb1(10) fragment 1
_____________________________________________________
Processing data in table: jiqun/def/tb2(11) fragment 1
_____________________________________________________
Processing data in table: mysql/def/columns_priv(46) fragment 1
_____________________________________________________
Processing data in table: mysql/def/ndb_host_backup(29) fragment 1
_____________________________________________________
Processing data in table: sys/def/SYSTAB_0(2) fragment 1
_____________________________________________________
Processing data in table: mysql/def/host(51) fragment 1
_____________________________________________________
Processing data in table: mysql/def/ndb_schema(4) fragment 1
_____________________________________________________
Processing data in table: mysql/def/ndb_proxies_priv_backup(31) fragment 1
Opening file '/var/lib/mysql/data/BACKUP/BACKUP-20121019/BACKUP-20121019.3.log'
File> Restored 20 tuples and 0 log entries
NDBT_ProgramExit: 0 - OK
#
如果用户权限表没有使用NDB数据库引擎的话，这么恢复是没有任何问题的，但是如果把用户权限表转换成NDB存储引擎了的话，在执行恢复的时候用户权限表默认是不恢复的。所以在启动sql节点的时候，会报错
# service mysql start
Starting MySQL..........The server quit without updating PID file (/var/lib/mysql/vmhost06.pid).
错误日志内容：
121019 11:14:56 /usr/sbin/mysqld: Incorrect information in file: './mysql/host.frm'
121019 11:14:56 Fatal error: Can't open and lock privilege tables: Table 'mysql.host' doesn't exist
如果使用mysqld_safe –skip-grant-tables启动数据库的话，会发现所有的数据都是正常的。所以说数据恢复是没有任何问题的。
但是如果要恢复用户权限表需要在恢复语句加上--restore-privilege-tables，如下
# ndbd --ndb-connectstring=192.168.163.110:1186 --initial
2012-10-19 12:56:58 INFO -- Angel connected to '192.168.163.110:1186'
2012-10-19 12:56:58 INFO -- Angel allocated nodeid: 2
# ndb_restore -c 192.168.163.110:1186 -n 2 -b 20121019 -m -r --backup-path=/var/lib/mysql/data/BACKUP/BACKUP-20121019/ --restore-privilege-tables
Nodeid = 2
Backup> backup path = /var/lib/mysql/data/BACKUP/BACKUP-20121019/
Opening file '/var/lib/mysql/data/BACKUP/BACKUP-20121019/BACKUP-20121019.2.ctl'
File> Backup version in files: ndb-6.3.11 ndb version: mysql-5.5.27 ndb-7.2.8
Stop GCP of Backup: 25571
Connected to ndb!!
Successfully restored table `mysql/def/user`
Successfully restored table event REPL$mysql/user
Successfully restored table `mysql/def/ndb_db_backup`
Successfully restored table event REPL$mysql/ndb_db_backup
Successfully restored table `mysql/def/ndb_user_backup`
Successfully restored table event REPL$mysql/ndb_user_backup
Successfully restored table `jiqun2/def/tb1`
Successfully restored table event REPL$jiqun2/tb1
Successfully restored table `mysql/def/ndb_procs_priv_backup`
Successfully restored table event REPL$mysql/ndb_procs_priv_backup
Successfully restored table `mysql/def/tables_priv`
Successfully restored table event REPL$mysql/tables_priv
Successfully restored table `mysql/def/ndb_columns_priv_backup`
Successfully restored table event REPL$mysql/ndb_columns_priv_backup
Successfully restored table `mysql/def/ndb_apply_status`
Successfully restored table event REPL$mysql/ndb_apply_status
Successfully restored table `mysql/def/db`
Successfully restored table event REPL$mysql/db
Successfully restored table `mysql/def/proxies_priv`
Successfully restored table event REPL$mysql/proxies_priv
Successfully restored table `mysql/def/procs_priv`
Successfully restored table event REPL$mysql/procs_priv
Successfully restored table `mysql/def/ndb_tables_priv_backup`
Successfully restored table event REPL$mysql/ndb_tables_priv_backup
Successfully restored table `jiqun/def/tb1`
Successfully restored table event REPL$jiqun/tb1
Successfully restored table `jiqun/def/tb2`
Successfully restored table event REPL$jiqun/tb2
Successfully restored table `mysql/def/columns_priv`
Successfully restored table event REPL$mysql/columns_priv
Successfully restored table `mysql/def/ndb_host_backup`
Successfully restored table event REPL$mysql/ndb_host_backup
Successfully restored table `mysql/def/host`
Successfully restored table event REPL$mysql/host
Successfully restored table `mysql/def/ndb_schema`
Successfully restored table event REPL$mysql/ndb_schema
Successfully restored table `mysql/def/ndb_proxies_priv_backup`
Successfully restored table event REPL$mysql/ndb_proxies_priv_backup
Successfully created index `PRIMARY` on `ndb_columns_priv_backup`
Successfully created index `Grantor` on `ndb_procs_priv_backup`
Successfully created index `PRIMARY` on `host`
Successfully created index `Grantor` on `proxies_priv`
Successfully created index `PRIMARY` on `ndb_user_backup`
Successfully created index `PRIMARY` on `ndb_tables_priv_backup`
Successfully created index `PRIMARY` on `columns_priv`
Successfully created index `Grantor` on `procs_priv`
Successfully created index `PRIMARY` on `user`
Successfully created index `PRIMARY` on `tables_priv`
Successfully created index `PRIMARY` on `ndb_host_backup`
Successfully created index `PRIMARY` on `ndb_proxies_priv_backup`
Successfully created index `PRIMARY` on `db`
Successfully created index `PRIMARY` on `ndb_procs_priv_backup`
Successfully created index `Grantor` on `ndb_tables_priv_backup`
Successfully created index `PRIMARY` on `proxies_priv`
Successfully created index `User` on `ndb_db_backup`
Successfully created index `PRIMARY` on `procs_priv`
Successfully created index `Grantor` on `tables_priv`
Successfully created index `PRIMARY` on `ndb_db_backup`
Successfully created index `User` on `db`
Successfully created index `Grantor` on `ndb_proxies_priv_backup`
Opening file '/var/lib/mysql/data/BACKUP/BACKUP-20121019/BACKUP-20121019-0.2.Data'
File> _____________________________________________________
Processing data in table: mysql/def/user(34) fragment 0
_____________________________________________________
Processing data in table: mysql/def/ndb_db_backup(18) fragment 0
_____________________________________________________
Processing data in table: mysql/def/NDB$BLOB_34_41(38) fragment 0
_____________________________________________________
Processing data in table: mysql/def/NDB$BLOB_34_33(35) fragment 0
_____________________________________________________
Processing data in table: mysql/def/ndb_index_stat_sample(8) fragment 0
_____________________________________________________
Processing data in table: mysql/def/NDB$BLOB_34_34(36) fragment 0
_____________________________________________________
Processing data in table: mysql/def/ndb_user_backup(12) fragment 0
_____________________________________________________
Processing data in table: jiqun2/def/tb1(56) fragment 0
_____________________________________________________
Processing data in table: mysql/def/NDB$BLOB_34_35(37) fragment 0
_____________________________________________________
Processing data in table: mysql/def/ndb_procs_priv_backup(26) fragment 0
_____________________________________________________
Processing data in table: mysql/def/tables_priv(43) fragment 0
_____________________________________________________
Processing data in table: sys/def/NDB$EVENTS_0(3) fragment 0
_____________________________________________________
Processing data in table: mysql/def/ndb_columns_priv_backup(24) fragment 0
_____________________________________________________
Processing data in table: mysql/def/ndb_apply_status(6) fragment 0
_____________________________________________________
Processing data in table: mysql/def/ndb_index_stat_head(7) fragment 0
_____________________________________________________
Processing data in table: mysql/def/NDB$BLOB_12_41(16) fragment 0
_____________________________________________________
Processing data in table: mysql/def/NDB$BLOB_12_33(13) fragment 0
_____________________________________________________
Processing data in table: mysql/def/db(40) fragment 0
_____________________________________________________
Processing data in table: mysql/def/NDB$BLOB_12_34(14) fragment 0
_____________________________________________________
Processing data in table: mysql/def/proxies_priv(53) fragment 0
_____________________________________________________
Processing data in table: mysql/def/NDB$BLOB_12_35(15) fragment 0
_____________________________________________________
Processing data in table: mysql/def/procs_priv(48) fragment 0
_____________________________________________________
Processing data in table: mysql/def/NDB$BLOB_4_3(5) fragment 0
_____________________________________________________
Processing data in table: mysql/def/ndb_tables_priv_backup(21) fragment 0
_____________________________________________________
Processing data in table: jiqun/def/tb1(10) fragment 0
_____________________________________________________
Processing data in table: jiqun/def/tb2(11) fragment 0
_____________________________________________________
Processing data in table: mysql/def/columns_priv(46) fragment 0
_____________________________________________________
Processing data in table: mysql/def/ndb_host_backup(29) fragment 0
_____________________________________________________
Processing data in table: sys/def/SYSTAB_0(2) fragment 0
_____________________________________________________
Processing data in table: mysql/def/host(51) fragment 0
_____________________________________________________
Processing data in table: mysql/def/ndb_schema(4) fragment 0
_____________________________________________________
Processing data in table: mysql/def/ndb_proxies_priv_backup(31) fragment 0
Opening file '/var/lib/mysql/data/BACKUP/BACKUP-20121019/BACKUP-20121019.2.log'
File> Restored 27 tuples and 0 log entries
NDBT_ProgramExit: 0 – OK
明显看到恢复产生的内容多了一些内容，就是用户权限表。
下面是其他节点的恢复操作了。
# ndbd --ndb-connectstring=192.168.163.110:1186 --initial
2012-10-19 12:57:06 INFO -- Angel connected to '192.168.163.110:1186'
2012-10-19 12:57:06 INFO -- Angel allocated nodeid: 3
# ndb_restore -c 192.168.163.110:1186 -n 3 -b 20121019-r --backup-path=/var/lib/mysql/data/BACKUP/BACKUP-20121019/ --restore-privilege-tables
Nodeid = 3
Backup> backup path = /var/lib/mysql/data/BACKUP/BACKUP-20121019/
Opening file '/var/lib/mysql/data/BACKUP/BACKUP-20121019/BACKUP-20121019.3.ctl'
File> Backup version in files: ndb-6.3.11 ndb version: mysql-5.5.27 ndb-7.2.8
Stop GCP of Backup: 25571
Connected to ndb!!
Opening file '/var/lib/mysql/data/BACKUP/BACKUP-20121019/BACKUP-20121019-0.3.Data'
File> _____________________________________________________
Processing data in table: mysql/def/user(34) fragment 1
_____________________________________________________
Processing data in table: mysql/def/ndb_db_backup(18) fragment 1
_____________________________________________________
Processing data in table: mysql/def/NDB$BLOB_34_41(38) fragment 1
_____________________________________________________
Processing data in table: mysql/def/NDB$BLOB_34_33(35) fragment 1
_____________________________________________________
Processing data in table: mysql/def/ndb_index_stat_sample(8) fragment 1
_____________________________________________________
Processing data in table: mysql/def/NDB$BLOB_34_34(36) fragment 1
_____________________________________________________
Processing data in table: mysql/def/ndb_user_backup(12) fragment 1
_____________________________________________________
Processing data in table: jiqun2/def/tb1(56) fragment 1
_____________________________________________________
Processing data in table: mysql/def/NDB$BLOB_34_35(37) fragment 1
_____________________________________________________
Processing data in table: mysql/def/ndb_procs_priv_backup(26) fragment 1
_____________________________________________________
Processing data in table: mysql/def/tables_priv(43) fragment 1
_____________________________________________________
Processing data in table: sys/def/NDB$EVENTS_0(3) fragment 1
_____________________________________________________
Processing data in table: mysql/def/ndb_columns_priv_backup(24) fragment 1
_____________________________________________________
Processing data in table: mysql/def/ndb_apply_status(6) fragment 1
_____________________________________________________
Processing data in table: mysql/def/ndb_index_stat_head(7) fragment 1
_____________________________________________________
Processing data in table: mysql/def/NDB$BLOB_12_41(16) fragment 1
_____________________________________________________
Processing data in table: mysql/def/NDB$BLOB_12_33(13) fragment 1
_____________________________________________________
Processing data in table: mysql/def/db(40) fragment 1
_____________________________________________________
Processing data in table: mysql/def/NDB$BLOB_12_34(14) fragment 1
_____________________________________________________
Processing data in table: mysql/def/proxies_priv(53) fragment 1
_____________________________________________________
Processing data in table: mysql/def/NDB$BLOB_12_35(15) fragment 1
_____________________________________________________
Processing data in table: mysql/def/procs_priv(48) fragment 1
_____________________________________________________
Processing data in table: mysql/def/NDB$BLOB_4_3(5) fragment 1
_____________________________________________________
Processing data in table: mysql/def/ndb_tables_priv_backup(21) fragment 1
_____________________________________________________
Processing data in table: jiqun/def/tb1(10) fragment 1
_____________________________________________________
Processing data in table: jiqun/def/tb2(11) fragment 1
_____________________________________________________
Processing data in table: mysql/def/columns_priv(46) fragment 1
_____________________________________________________
Processing data in table: mysql/def/ndb_host_backup(29) fragment 1
_____________________________________________________
Processing data in table: sys/def/SYSTAB_0(2) fragment 1
_____________________________________________________
Processing data in table: mysql/def/host(51) fragment 1
_____________________________________________________
Processing data in table: mysql/def/ndb_schema(4) fragment 1
_____________________________________________________
Processing data in table: mysql/def/ndb_proxies_priv_backup(31) fragment 1
Opening file '/var/lib/mysql/data/BACKUP/BACKUP-20121019/BACKUP-20121019.3.log'
File> Restored 38 tuples and 0 log entries
NDBT_ProgramExit: 0 - OK
#
恢复完成后再启动sql节点一切正常。
页:
[1]