GBase 8a
运维管理
文章

GBase8a 备份恢复管理(表级)-03

可口
发表于2025-04-10 17:02:3887次浏览1个评论

表级备份

功能说明

将 GBase 8a MPP Cluster 数据库中的某个表全量备份至指定路径中。

语法格式

backup table [vcname].<dbname>.<tablename> level < 0 | 1 >

示例

示例 1：使用命令行模式进行表级备份。
检查集群状态：
$ gcadmin
CLUSTER STATE: ACTIVE
================================================================
|            GBASE COORDINATOR CLUSTER INFORMATION             |
================================================================
| NodeName     | IpAddress     | gcware | gcluster | DataState |
----------------------------------------------------------------
| coordinator1 | 172.168.83.11 |  OPEN  |   OPEN   |     0     |
----------------------------------------------------------------
| coordinator2 | 172.168.83.12 |  OPEN  |   OPEN   |     0     |
----------------------------------------------------------------
| coordinator3 | 172.168.83.13 |  OPEN  |   OPEN   |     0     |
----------------------------------------------------------------
=====================================================
|         GBASE VIRTUAL CLUSTER INFORMATION         |
=====================================================
| VcName | DistributionId | comment                 |
-----------------------------------------------------
| vc1    |        1       | comment message for vc1 |
-----------------------------------------------------
| vc2    |        2       | comment message for vc2 |
-----------------------------------------------------
2 virtual cluster: vc1, vc2
3 coordinator node
0 free data node
$ gcadmin showcluster vc vc1
CLUSTER STATE: ACTIVE
VIRTUAL CLUSTER MODE: NORMAL
=====================================================
|         GBASE VIRTUAL CLUSTER INFORMATION         |
=====================================================
| VcName | DistributionId | comment                 |
-----------------------------------------------------
| vc1    |        1       | comment message for vc1 |
-----------------------------------------------------
====================================================================
|               VIRTUAL CLUSTER DATA NODE INFORMATION              |
====================================================================
|NodeName| IpAddress    | DistributionId|gnode|syncserver|DataState|
--------------------------------------------------------------------
| node1  | 172.168.83.11|       1       |OPEN |   OPEN   |    0    |
--------------------------------------------------------------------
| node2  | 172.168.83.12|       1       |OPEN |   OPEN   |    0    |
--------------------------------------------------------------------
2 data node
$ gcadmin showcluster vc vc2
CLUSTER STATE: ACTIVE
VIRTUAL CLUSTER MODE: NORMAL
=====================================================
|         GBASE VIRTUAL CLUSTER INFORMATION         |
=====================================================
| VcName | DistributionId | comment                 |
-----------------------------------------------------
| vc2    |        2       | comment message for vc2 |
-----------------------------------------------------
====================================================================
|               VIRTUAL CLUSTER DATA NODE INFORMATION              |
====================================================================
|NodeName| IpAddress    | DistributionId|gnode|syncserver|DataState|
------------------------------------------------------------------
| node1  | 172.168.83.13|       2       |OPEN |   OPEN   |    0    |
--------------------------------------------------------------------
| node2  | 172.168.83.14|       2       |OPEN |   OPEN   |    0    |
--------------------------------------------------------------------
2 data node
使用命令行模式进行全备：
$ python $GCLUSTER_BASE/server/bin/gcrcman.py -d /home/gbase/backupT -P
gbasedba –p ****** -e "backup table vc1.demo.t level 0"
08.08 15:00:35 BackUp table vc1.demo.t start
--------------------------------------------
08.08 15:00:36 node (172.168.83.11) backup table begin
08.08 15:00:36 node (172.168.83.12) backup table begin
08.08 15:00:36 node (172.168.83.13) backup table begin
08.08 15:00:36 node (172.168.83.14) backup table begin
08.08 15:00:59 node (172.168.83.11) backup table success
08.08 15:00:59 node (172.168.83.12) backup table success
08.08 15:00:59 node (172.168.83.13) backup table success
08.08 15:00:59 node (172.168.83.14) backup table success
--------------------------------------------
08.08 15:00:59 BackUp table vc1.demo.t end
使用命令行模式进行增备：
$ python $GCLUSTER_BASE/server/bin/gcrcman.py -d /home/gbase/backupT -P
gbasedba –p ****** -e "backup table vc1.demo.t level 1"
08.08 15:02:49 check cluster topology begin
08.08 15:02:49 node (172.168.83.11) check topology begin
08.08 15:02:51 node (172.168.83.11) check topology success
08.08 15:02:52 check cluster topology end
08.08 15:02:52 BackUp table vc1.demo.t start
--------------------------------------------
08.08 15:02:52 node (172.168.83.11) backup table begin
08.08 15:02:52 node (172.168.83.12) backup table begin
08.08 15:02:52 node (172.168.83.13) backup table begin
08.08 15:02:52 node (172.168.83.14) backup table begin
08.08 15:03:16 node (172.168.83.11) backup table success
08.08 15:03:16 node (172.168.83.12) backup table success
08.08 15:03:16 node (172.168.83.13) backup table success
08.08 15:03:16 node (172.168.83.14) backup table success
--------------------------------------------
08.08 15:03:16 BackUp table vc1.demo.t end

批量表级备份

功能说明

将配置文件 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 tablenum3=============
========================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:38 node (192.168.146.40) backup table success
05.19 13:48:38 node (192.168.146.41) backup table success
05.19 13:48:38 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
===================ParallelProcessTableEnd============================
========================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 tablenum3=============
========================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.40) backup table begin
05.19 13:50:45 node (192.168.146.41) backup table begin
05.19 13:50:46 node (192.168.146.42) 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
===================ParallelProcessTableEnd============================
========================SaveBackUpInfo================================

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

 

评论

登录后才可以发表评论
崔哥发表于 8个月前
汉皇重色思倾国，御宇多年求不得。杨家有女初长成，养在深闺人未识。天生丽质难自弃，一朝选在君王侧。回眸一笑百媚生，六宫粉黛无颜色。春寒赐浴华清池，温泉水滑洗凝脂。侍儿扶起娇无力，始是新承恩泽时。云鬓花颜金步摇，芙蓉帐暖度春宵。春宵苦短日高起，从此君王不早朝。承欢侍宴无闲暇，春从春游夜专夜。后宫佳丽三千人，三千宠爱在一身。金屋妆成娇侍夜，玉楼宴罢醉和春。姊妹弟兄皆列土，可怜光彩生门户。遂令天下父母心，不重生男重生女。骊宫高处入青云，仙乐风飘处处闻。缓歌慢舞凝丝竹，尽日君王看不足。渔阳鼙鼓动地来，惊破霓裳羽衣曲。九重城阙烟尘生，千乘万骑西南行。翠华摇摇行复止，西出都门百余里。六军不发无奈何，宛转蛾眉马前死。花钿委地无人收，翠翘金雀玉搔头。君王掩面救不得，回看血泪相和流。黄埃散漫风萧索，云栈萦纡登剑阁。峨嵋山下少人行，旌旗无光日色薄。蜀江水碧蜀山青，圣主朝朝暮暮情。行宫见月伤心色，夜雨闻铃肠断声。天旋地转回龙驭，到此踌躇不能去。马嵬坡下泥土中，不见玉颜空死处。君臣相顾尽沾衣，东望都门信马归。归来池苑皆依旧，太液芙蓉未央柳。芙蓉如面柳如眉，对此如何不泪垂。春风桃李花开日，秋雨梧桐叶落时。西宫南内多秋草，落叶满阶红不扫。梨园弟子白发新，椒房阿监青娥老。夕殿萤飞思悄然，孤灯挑尽未成眠。迟迟钟鼓初长夜，耿耿星河欲曙天。鸳鸯瓦冷霜华重，翡翠衾寒谁与共。悠悠生死别经年，魂魄不曾来入梦。临邛道士鸿都客，能以精诚致魂魄。为感君王辗转思，遂教方士殷勤觅。排空驭气奔如电，升天入地求之遍。上穷碧落下黄泉，两处茫茫皆不见。忽闻海上有仙山，山在虚无缥渺间。楼阁玲珑五云起，其中绰约多仙子。中有一人字太真，雪肤花貌参差是。金阙西厢叩玉扃，转教小玉报双成。闻道汉家天子使，九华帐里梦魂惊。揽衣推枕起徘徊，珠箔银屏迤逦开。云鬓半偏新睡觉，花冠不整下堂来。风吹仙袂飘飘举，犹似霓裳羽衣舞。玉容寂寞泪阑干，梨花一枝春带雨。含情凝睇谢君王，一别音容两渺茫。昭阳殿里恩爱绝，蓬莱宫中日月长。回头下望人寰处，不见长安见尘雾。惟将旧物表深情，钿合金钗寄将去。钗留一股合一扇，钗擘黄金合分钿。但教心似金钿坚，天上人间会相见。临别殷勤重寄词，词中有誓两心知。七月七日长生殿，夜半无人私语时。在天愿作比翼鸟，在地愿为连理枝。天长地久有时尽，此恨绵绵无绝期。

热门帖子