Mysql cluster数据备份和恢复

jmton

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>　　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
　　[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>　　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
　　[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>　　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
　　[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>　　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
　　明显看到恢复产生的内容多了一些内容，就是用户权限表。
　　下面是其他节点的恢复操作了。
　　[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>　　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
　　[root@vmhost BACKUP-20121019]#
　　恢复完成后再启动sql节点一切正常。