GBase8a 备份恢复管理(批量表级)-04

批量表级备份

功能说明

将配置文件 table.list 中指定的表进行批量备。 注意:

 全量备份时可以在table.list中增加新表，增量备份时不可以增加新表。  备份时需保证集群各服务状态和数据状态都正常，无feventlog。

 需提前在各个节点上创建备份目录，且备份用户具有读写权限。

 只能备份express引擎表。

 如果备份的表有写操作，备份程序将等待。

语法格式

backup tables.<table.list> level < 0 | 1 >

table.list 是配置文件名称，可以任意命名。书写时需写绝对路径。
table.list 内容是需要备份的表名称，格式为 vcname.db.table，每行一个表名。如果

有默认 vc，则 vcname 可以省略。

示例

test 库有表 t1、t2、t3 集群各节点上创建备份目录/home/gbase/backup

创建/home/gbase/table.list 文件: vcname000001.test.t1 vcname000001.test.t2 vcname000001.test.t3

[gbase@rhel73-1 ~]$ gcrcman.py -P "******" -p "******" -d "/home/gbase/backup" -R 8
gcrcman>backup tables /home/gbase/table.list level 0
========================BackUpMultiTable=============================
distinct table list ['vcname000001.test.t1', 'vcname000001.test.t2', 'vcname000001.test.t3']
==============BackUp ParallelProcessTable default parallel 8 tablenum 3============= 
========================BackUpOneTable===============================
backup table vcname000001.test.t1 level 0 
========================BackUpOneTable===============================
backup table vcname000001.test.t2 level 0 
========================BackUpOneTable===============================
backup table vcname000001.test.t3 level 0
05.19 13:48:11 BackUp table vcname000001.test.t1 start 
--------------------------------------------
05.19 13:48:12 node(192.168.146.40) backup table begin
05.19 13:48:12 node (192.168.146.41) backup table begin
05.19 13:48:12 node (192.168.146.42) backup table begin
05.19 13:48:16 BackUp table vcname000001.test.t2 start
--------------------------------------------
05.19 13:48:16 node (192.168.146.40) backup table begin
05.19 13:48:16 node (192.168.146.41) backup table begin
05.19 13:48:16 node (192.168.146.42) backup table begin
05.19 13:48:18 BackUp table vcname000001.test.t3 start
--------------------------------------------
05.19 13:48:18 node (192.168.146.40) backup table begin
05.19 13:48:18 node (192.168.146.41) backup table begin
05.19 13:48:18 node (192.168.146.42) backup table begin
05.19 13:48:18 node (192.168.146.40) backup table success
05.19 13:48:18 node (192.168.146.41) backup table success
05.19 13:48:18 node (192.168.146.42) backup table success
--------------------------------------------
05.19 13:48:38 BackUp table vcname000001.test.t1 end
05.19 13:48:40 node (192.168.146.40) backup table success
05.19 13:48:40 node (192.168.146.41) backup table success
05.19 13:48:40 node (192.168.146.42) backup table success
--------------------------------------------
05.19 13:48:40 BackUp table vcname000001.test.t2 end
05.19 13:48:41 node (192.168.146.40) backup table success
05.19 13:48:41 node (192.168.146.41) backup table success
05.19 13:48:41 node (192.168.146.42) backup table success
--------------------------------------------
05.19 13:48:41 BackUp table vcname000001.test.t3 end
===================ParallelProcessTable End============================ 
========================SaveBackUpInfo=================================
gcrcman>backup tables /home/gbase/table.list level 1
========================BackUpMultiTable=============================
distinct table list ['vcname000001.test.t1', 'vcname000001.test.t2', 'vcname000001.test.t3']
==============BackUp ParallelProcessTable default parallel 8 tablenum 3============= 
========================BackUpOneTable===============================
backup table vcname000001.test.t1 level 1 
========================BackUpOneTable===============================
backup table vcname000001.test.t2 level 1 
========================BackUpOneTable===============================
backup table vcname000001.test.t3 level 1
05.19 13:50:41 BackUp table vcname000001.test.t1 start
--------------------------------------------
05.19 13:50:42 node (192.168.146.40) backup table begin
05.19 13:50:42 node (192.168.146.41) backup table begin
05.19 13:50:42 node (192.168.146.42) backup table begin
05.19 13:50:44 BackUp table vcname000001.test.t2 start
--------------------------------------------
05.19 13:50:45 BackUp table vcname000001.test.t3 start
--------------------------------------------
05.19 13:50:45 node (192.168.146.40) backup table begin
05.19 13:50:45 node (192.168.146.41) backup table begin
05.19 13:50:45 node (192.168.146.42) backup table begin
05.19 13:50:45 node (192.168.146.40) backup table begin
05.19 13:50:46 node (192.168.146.41) backup table begin
05.19 13:50:46 node (192.168.146.42) backup table begin
05.19 13:51:11 node (192.168.146.40) backup table success
05.19 13:51:11 node (192.168.146.41) backup table success
05.19 13:51:11 node (192.168.146.42) backup table success
--------------------------------------------
05.19 13:51:11 BackUp table vcname000001.test.t1 end
05.19 13:51:12 node (192.168.146.40) backup table success
05.19 13:51:12 node (192.168.146.41) backup table success
05.19 13:51:12 node (192.168.146.42) backup table success
--------------------------------------------
05.19 13:51:12 BackUp table vcname000001.test.t3 end
05.19 13:51:12 node (192.168.146.40) backup table success
05.19 13:51:12 node (192.168.146.41) backup table success
05.19 13:51:12 node (192.168.146.42) backup table success
--------------------------------------------
05.19 13:51:12 BackUp table vcname000001.test.t2 end
===================ParallelProcessTable End============================ 
========================SaveBackUpInfo=======================
==========

注:如果不加参数-R，则默认并行度为 4。