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
[root@vmhost02 ~]# ndb_mgmd -f /var/lib/mysql/config.ini --reload
MySQL Cluster Management Server mysql-5.5.27 ndb-7.2.8
[root@vmhost02 ~]# ndb_mgm
-- NDB Cluster -- Management Client --
ndb_mgm> show
Connected to Management Server at: 192.168.163.110:1186
Cluster Configuration
---------------------
[ndbd(NDB)] 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)
[ndb_mgmd(MGM)] 1 node(s)
id=1 @192.168.163.110 (mysql-5.5.27 ndb-7.2.8)
[mysqld(API)] 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)
在一个数据节点开始数据恢复
[root@vmhost05 BACKUP-20121019]# ndbd --ndb-connectstring=192.168.163.110:1186 --initial
2012-10-19 10:24:25 [ndbd] INFO -- Angel connected to '192.168.163.110:1186'
2012-10-19 10:24:25 [ndbd] INFO -- Angel allocated nodeid: 2
[root@vmhost05 BACKUP-20121019]# 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 Id = 20121019
backup path = /var/lib/mysql/data/BACKUP/BACKUP-20121019/
Opening file '/var/lib/mysql/data/BACKUP/BACKUP-20121019/BACKUP-20121019.2.ctl'
File size 109284 bytes
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 size 43784 bytes
_____________________________________________________
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 size 52 bytes
Restored 15 tuples and 0 log entries
NDBT_ProgramExit: 0 - OK
[root@vmhost05 BACKUP-20121019]#
在第二个数据节点进行数据恢复
[root@vmhost BACKUP-20121019]# ndbd --ndb-connectstring=192.168.163.110:1186 --initial
2012-10-19 10:24:39 [ndbd] INFO -- Angel connected to '192.168.163.110:1186'
2012-10-19 10:24:39 [ndbd] INFO -- Angel allocated nodeid: 3
[root@vmhost BACKUP-20121019]# 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 Id = 20121019
backup path = /var/lib/mysql/data/BACKUP/BACKUP-20121019/
Opening file '/var/lib/mysql/data/BACKUP/BACKUP-20121019/BACKUP-20121019.3.ctl'
File size 109284 bytes
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
[root@vmhost BACKUP-20121019]# 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 Id = 20121019
backup path = /var/lib/mysql/data/BACKUP/BACKUP-20121019/
Opening file '/var/lib/mysql/data/BACKUP/BACKUP-20121019/BACKUP-20121019.3.ctl'
File size 109284 bytes
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 size 48996 bytes
_____________________________________________________
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 size 52 bytes
Restored 20 tuples and 0 log entries
NDBT_ProgramExit: 0 - OK
[root@vmhost BACKUP-20121019]#
如果用户权限表没有使用NDB数据库引擎的话，这么恢复是没有任何问题的，但是如果把用户权限表转换成NDB存储引擎了的话，在执行恢复的时候用户权限表默认是不恢复的。所以在启动sql节点的时候，会报错
[root@vmhost06 mysql]# service mysql start
Starting MySQL..........The server quit without updating PID file (/var/lib/mysql/vmhost06.pid).[FAILED]
错误日志内容：
121019 11:14:56 [ERROR] /usr/sbin/mysqld: Incorrect information in file: './mysql/host.frm'
121019 11:14:56 [ERROR] Fatal error: Can't open and lock privilege tables: Table 'mysql.host' doesn't exist
如果使用mysqld_safe –skip-grant-tables启动数据库的话，会发现所有的数据都是正常的。所以说数据恢复是没有任何问题的。
但是如果要恢复用户权限表需要在恢复语句加上--restore-privilege-tables，如下
[root@vmhost05 D1]# ndbd --ndb-connectstring=192.168.163.110:1186 --initial
2012-10-19 12:56:58 [ndbd] INFO -- Angel connected to '192.168.163.110:1186'
2012-10-19 12:56:58 [ndbd] INFO -- Angel allocated nodeid: 2
[root@vmhost05 D1]# 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 Id = 20121019
backup path = /var/lib/mysql/data/BACKUP/BACKUP-20121019/
Opening file '/var/lib/mysql/data/BACKUP/BACKUP-20121019/BACKUP-20121019.2.ctl'
File size 109284 bytes
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 size 43784 bytes
_____________________________________________________
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 size 52 bytes
Restored 27 tuples and 0 log entries
NDBT_ProgramExit: 0 – OK
明显看到恢复产生的内容多了一些内容，就是用户权限表。
下面是其他节点的恢复操作了。
[root@vmhost BACKUP-20121019]# ndbd --ndb-connectstring=192.168.163.110:1186 --initial
2012-10-19 12:57:06 [ndbd] INFO -- Angel connected to '192.168.163.110:1186'
2012-10-19 12:57:06 [ndbd] INFO -- Angel allocated nodeid: 3
[root@vmhost BACKUP-20121019]# 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 Id = 20121019
backup path = /var/lib/mysql/data/BACKUP/BACKUP-20121019/
Opening file '/var/lib/mysql/data/BACKUP/BACKUP-20121019/BACKUP-20121019.3.ctl'
File size 109284 bytes
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 size 48996 bytes
_____________________________________________________
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 size 52 bytes
Restored 38 tuples and 0 log entries
NDBT_ProgramExit: 0 - OK
[root@vmhost BACKUP-20121019]#
恢复完成后再启动sql节点一切正常。
转载于:https://blog.51cto.com/itlaowu/1031462
229
被折叠的 条评论
为什么被折叠?
到【灌水乐园】发言
