<\/span><\/h2>\n\n\n\n\u73b0\u6709\u7248\u672c\u4e0d\u652f\u6301\u81ea\u52a8\u5efa\u5e93\uff0c\u6240\u6709\u5907\u5e93\u8981\u624b\u5de5\u521b\u5efa\u3002\u6240\u4ee5\u9996\u6b21\u4f7f\u7528\uff0c\u8981\u521b\u5efatestdb\u5e93\u3002 <\/p>\n\n\n\n
\u8bf7\u6ce8\u610f\u6570\u636e\u5e93\u7528\u6237\uff0c\u4ee5\u53ca\u5bf9\u5e94\u5e93\u7684\u6743\u9650\uff0c\u907f\u514d\u8868\u65e0\u6cd5\u8bbf\u95ee\u3002<\/p>\n\n\n\n
[gbase@localhost gcinstall_9.5.2.44.10]$ gccli\n\nGBase client 9.5.2.44.1045e3118. Copyright (c) 2004-2022, GBase. All Rights Reserved.\n\ngbase> create database testdb;\nQuery OK, 1 row affected (Elapsed: 00:00:00.01)\n<\/code><\/pre>\n\n\n\n<\/span>\u540c\u6b65\u5de5\u5177\u53c2\u6570<\/span><\/h2>\n\n\n\n- --master_mpp_ip \u4e3b\u96c6\u7fa4IP\uff0c\u5f53\u524d\u7248\u672c\u53ea\u652f\u6301ipv4,\u4e14\u5355\u4e2aIP<\/li>
- --slave_mpp_ip \u5907\u96c6\u7fa4IP\uff0c\u5f53\u524d\u7248\u672c\u53ea\u652f\u6301ipv4,\u4e14\u5355\u4e2aIP<\/li>
- --master_mpp_ip_mapping_file \u6307\u5b9a\u4e3b\u96c6\u7fa4\u7684IP\u6620\u5c04<\/mark>\u6587\u4ef6<\/li>
- --slave_mpp_ip_mapping_file \u6307\u5b9a\u4ece\u96c6\u7fa4\u7684IP\u6620\u5c04<\/mark>\u6587\u4ef6<\/li>
- --table_list_filet \u88ab\u540c\u6b65\u7684\u8868\u5217\u8868\u6587\u4ef6<\/li>
- --log_level \u65e5\u5fd7\u7ea7\u522b
- 0: nolog level<\/li>
- 1: critical level<\/li>
- 2: error level<\/li>
- 3: warning level<\/li>
- 4: info level<\/li>
- 5: debug level<\/li><\/ul><\/li>
- --rsync_mode \u540c\u6b65\u6a21\u5f0f
- 0\uff1a\u4e3b\u5206\u7247\u540c\u6b65\uff0c\u5907\u5206\u7247\u8bbe\u5b9a\u72b6\u6001\uff0c\u901a\u8fc7\u96c6\u7fa4\u5185\u90e8\u7684\u81ea\u52a8\u6062\u590d\u673a\u5236\u8fdb\u884c\u6062\u590d\u3002\u8be5\u53c2\u6570\u503c\u4e0d\u5efa\u8bae\u4f7f\u7528\uff0c\u4ec5\u4ec5\u4e3a\u4e86\u7248\u672c\u517c\u5bb9\u4fdd\u7559\u3002<\/li>
- 1\uff1a\u540c\u65f6\u540c\u6b65\u5907\u96c6\u7fa4\u7684\u4e3b\u3001\u5907\u5206\u7247\uff0c\u5355\u8868\u540c\u6b65\u7684\u6027\u80fd\u80fd\u591f\u8fbe\u5230\u6700\u5927\u5316\u3002\u8be5\u53c2\u6570\u503c\u4e0d\u5efa\u8bae\u4f7f\u7528\uff0c\u5b58\u5728\u4e00\u4e2a\u5206\u7247\u7684\u4e3b\u5907\u90fd\u540c\u6b65\u5931\u8d25\uff0c\u8868\u4e0d\u53ef\u7528\u7684\u60c5\u51b5\uff0c\u8be5\u53c2\u6570\u662f\u5f53\u521d\u8bbe\u8ba1\u662f\u4e3a\u4e86\u6570\u636e\u5b89\u5168\u6027\u4e0d\u9ad8\u7684\u573a\u666f\u3002<\/li>
- 2\uff1a\u5148\u4e3b\u540e\u5907\u540c\u6b65\u65b9\u5f0f\u3002\u5148\u540c\u6b65\u5907\u96c6\u7fa4\u8868\u7684\u4e3b\u5206\u7247\uff0c\u4e3b\u5206\u7247\u540c\u6b65\u6210\u529f\u540e\u518d\u540c\u6b65\u5907\u5206\u7247\uff0c\u786e\u4fdd\u5907\u96c6\u7fa4\u7684\u8868\u5728\u540c\u6b65\u5931\u8d25\u540e\u5b58\u5728\u4e00\u7ec4\u53ef\u7528\u5206\u7247\uff0c\u7528\u6765\u56de\u6eda\u540c\u6b65\u64cd\u4f5c\u3002<\/li><\/ul><\/li>
- --master_mpp_gc_pw \u4e3b\u96c6\u7fa4\u7684\u6570\u636e\u5e93\u7528\u6237\u5bc6\u7801<\/li>
- --slave_mpp_gc_pw \u5907\u96c6\u7fa4\u7684\u6570\u636e\u5e93\u7528\u6237\u5bc6\u7801<\/li>
- --database_user \u540c\u6b65\u4f7f\u7528\u7684\u6570\u636e\u5e93\u7528\u6237\uff0c\u4e24\u9762\u5fc5\u987b\u76f8\u540c\uff0c\u6240\u6709\u53ea\u67091\u4e2a\u53c2\u6570<\/li>
- --slave_create_table_if_not_exists \u5982\u679c\u5907\u96c6\u7fa4\u8868\u4e0d\u5b58\u5728\uff0c\u5219\u81ea\u52a8\u6839\u636e\u4e3b\u96c6\u7fa4\u521b\u5efa<\/li><\/ul>\n\n\n\n
\u5176\u5b83\u53c2\u6570\u8bf7\u770b--help\u7684\u4fe1\u606f<\/p>\n\n\n\n
[gbase@gbase_rh7_001 gcluster_rsynctool]$ .\/gcluster_rsynctool.py --help\nUsage: gcluster_rsynctool.py [optinos]\n\nOptions:\n -h, --help show this help message and exit\n -v, --version output version information and exit\n --master_mpp_ip=MASTER_MPP_IP\n The ipaddress of master mpp gcluster,only support IPV4\n --master_mpp_ip_mapping_file=MASTER_MPP_IP_MAPPING_FILE\n The file for master mpp gcluster ipaddress transform\n file format is json,only support IPV4\n --master_mpp_gc_port=MASTER_MPP_GC_PORT\n The port of master mpp gcluster[default:5258]\n --master_mpp_gn_port=MASTER_MPP_GN_PORT\n The port of master mpp gcluster's gnode[default:5050]\n --slave_mpp_ip=SLAVE_MPP_IP\n The ipaddress of slave mpp gcluster,only support IPV4\n --slave_mpp_ip_mapping_file=SLAVE_MPP_IP_MAPPING_FILE\n The file for slave mpp gcluster ipaddress transform\n file format is json,only support IPV4\n --slave_mpp_gc_port=SLAVE_MPP_GC_PORT\n The port of slave mpp gcluster[default:5258]\n --slave_mpp_gn_port=SLAVE_MPP_GN_PORT\n The port of slave mpp gcluster's gnode[default:5050]\n --master_mpp_gc_pw=MASTER_MPP_GC_PW\n The password of master mpp gcluster's database\n user[default:000000]\n --slave_mpp_gc_pw=SLAVE_MPP_GC_PW\n The password of slave mpp gcluster's database\n user[default:000000]\n --sync_vc_name=SYNC_VC_NAME\n The name of vc that will be sync,only support one vc\n per time[default:vcname000001]\n --database_user=DATABASE_USER\n A database user having rights to access tables defined\n in 'table_list_file', this user\n should exist in both master gcluster and slave\n gcluster[default:gbase]\n --table_list_file=TABLE_LIST_FILE\n The file which contain the table list should be synced\n --table_parallel_degree=TABLE_PARALLEL_DEGREE\n The parallel degree for how many tables should be\n synced [default:1, min:1, max:128]\n --lock_table_timeout=LOCK_TABLE_TIMEOUT\n The timeout use by gcluster locking table\n [default:600,min:1,max:3600,unit:second]\n --retry_times=RETRY_TIMES\n Synctool retry times[default:1, min:1,\n max:10,unit:times]\n --retry_interval=RETRY_INTERVAL\n The interval time between synctool retry [default:10,\n min:1, max:1800,unit:second]\n --sync_mode=SYNC_MODE\n The synctool mode [default:2, min:1, max:3];\n 1: do table level scn check; 2:\n not to do table level scn check,just check each column\n scn; 3: not to do scn check\n ,just sync whole table data;\n --error_table_list_file=ERROR_TABLE_LIST_FILE\n The file output for failed table list[default:{$table_\n list_file}_error_table_list_{%Y_%m_%d-%H:%M:%S}.log]\n --log_name=LOG_NAME The log file\n name[default:{$table_list_file}_{%Y_%m_%d}.log]\n --log_level=LOG_LEVEL\n The gcluster_rsynctool's log level [default:3, min:0,\n max:5]; 0: nolog level;\n 1: critical level 2: error level\n 3: warning level 4: info level\n 5: debug level\n --rsync_mode=RSYNC_MODE\n The gcluster_rsynctool's rsync_mode [default:2, min:0,\n max:2]; 0: sync major slice and\n set status on backup slice; 1:\n sync major slice and backup slice at the same;\n 2: sync major slice first and then sync the backup\n slice if major slice sync success\n .\n --double_check check data that already write on disk.[default:false]\n --slave_create_table_if_not_exists\n create table if not exists on slave\n mpp.[default:false]\n --cleanup_uncontrolled_data=CLEANUP_UNCONTROLLED_DATA\n whether clean up uncontrolled data on target table\n [default:0, min:0, max:1]; 0:\n not clean up uncontrolled data on target data;\n 1: clean up uncontrolled data on target data;<\/code><\/pre>\n\n\n\n<\/span>\u540c\u6b65\u5355\u4e2a\u8868<\/span><\/h2>\n\n\n\n\u6211\u4eec\u5148\u6d4b\u8bd5\u540c\u6b65\u4e00\u5f20\u8868\uff0c\u591a\u5f20\u7684\u770b\u540e\u9762\u4f8b\u5b50<\/p>\n\n\n\n
<\/span>\u540c\u6b65\u8868\u7684\u5217\u8868\u6587\u4ef6<\/span><\/h3>\n\n\n\n[gbase@gbase_rh7_001 gcluster_rsynctool]$ cat test.list\ntestdb.t2<\/code><\/pre>\n\n\n\n<\/span>\u540c\u6b65\u64cd\u4f5c<\/span><\/h3>\n\n\n\n[gbase@gbase_rh7_001 gcluster_rsynctool]$ .\/gcluster_rsynctool.py --master_mpp_ip=10.0.2.101 --slave_mpp_ip=10.0.2.102 --table_list_file=test.list --log_level=5 --rsync_mode=1 --master_mpp_gc_pw=gbase20110531 --slave_mpp_gc_pw=gbase20110531 --database_user=gbase --slave_create_table_if_not_exists\n*************Gcluster Sync Tool Start*************************\nTable [ vcname000001: testdb: t2] Sync Start\nTable [ vcname000001 testdb: t2] Sync End cost : <0 s,142 ms>\n*************Gcluster Sync Tool End With Success**************\n[gbase@gbase_rh7_001 gcluster_rsynctool]$<\/code><\/pre>\n\n\n\n<\/span>\u540c\u6b65\u7ed3\u679c<\/span><\/h3>\n\n\n\n\u5907\u7528\u96c6\u7fa4\u7684testdb.t2\u8868\u81ea\u52a8\u521b\u5efa\u5e76\u540c\u6b65\u4e86\u6570\u636e\u3002<\/p>\n\n\n\n
[gbase@gbase_rh7_001 gcluster_rsynctool]$ gccli -h10.0.2.102 -e\"select * from testdb.t2\"\n+------+\n| id |\n+------+\n| 1000 |\n+------+\n[gbase@gbase_rh7_001 gcluster_rsynctool]$ gccli -h10.0.2.101 -e\"select * from testdb.t2\"\n+------+\n| id |\n+------+\n| 1000 |\n+------+\n<\/code><\/pre>\n\n\n\n<\/span>\u591a\u8868\u540c\u6b65<\/span><\/h2>\n\n\n\n\u540c\u6b65\u547d\u4ee4\u53ef\u4ee5\u589e\u52a0\u5e76\u884c\u53c2\u6570<\/p>\n\n\n\n
--table_parallel_degree \u540c\u65f6\u505a\u540c\u6b65\u7684\u4efb\u52a1\u6570\u91cf<\/code><\/pre>\n\n\n\n<\/span>\u540c\u6b65\u8868\u7684\u5217\u8868<\/span><\/h3>\n\n\n\n[gbase@gbase_rh7_001 gcluster_rsynctool]$ cat test.list\ntestdb.t1\ntestdb.t2\ntestdb.t2_inc\ntestdb.t3_inc\ntestdb.t_inc\ntestdb.t_pid\ntestdb.tidname\ntestdb.tmp2\ntestdb.tmp3\ntestdb.tt\ntestdb.tt2<\/code><\/pre>\n\n\n\n<\/span>\u540c\u6b65\u64cd\u4f5c<\/span><\/h3>\n\n\n\n[gbase@gbase_rh7_001 gcluster_rsynctool]$ .\/gcluster_rsynctool.py --master_mpp_ip=10.0.2.101 --slave_mpp_ip=10.0.2.102 --table_list_file=test.list --log_level=5 --rsync_mode=1 --master_mpp_gc_pw=gbase20110531 --slave_mpp_gc_pw=gbase20110531 --database_user=gbase --slave_create_table_if_not_exists --table_parallel_degree=2\n*************Gcluster Sync Tool Start*************************\nTable [ vcname000001: testdb: t1] Sync Start\nTable [ vcname000001: testdb: t2] Sync Start\nTable [ vcname000001 testdb: t1] Sync End cost : <0 s,400 ms>\nTable [ vcname000001 testdb: t2] Sync End cost : <0 s,362 ms>\nTable [ vcname000001: testdb: t2_inc] Sync Start\nTable [ vcname000001: testdb: t3_inc] Sync Start\nTable [ vcname000001 testdb: t2_inc] Sync End cost : <0 s,370 ms>\nTable [ vcname000001: testdb: t_inc] Sync Start\nTable [ vcname000001 testdb: t3_inc] Sync End cost : <0 s,369 ms>\nTable [ vcname000001: testdb: t_pid] Sync Start\nTable [ vcname000001 testdb: t_inc] Sync End cost : <0 s,336 ms>\nTable [ vcname000001: testdb: tidname] Sync Start\nTable [ vcname000001 testdb: t_pid] Sync End cost : <0 s,384 ms>\nTable [ vcname000001 testdb: tidname] Sync End cost : <0 s,125 ms>\nTable [ vcname000001: testdb: tmp2] Sync Start\nTable [ vcname000001: testdb: tmp3] Sync Start\nTable [ vcname000001 testdb: tmp2] Sync End cost : <0 s,372 ms>\nTable [ vcname000001: testdb: tt] Sync Start\nTable [ vcname000001 testdb: tmp3] Sync End cost : <0 s,388 ms>\nTable [ vcname000001 testdb: tt] Sync End cost : <0 s,114 ms>\nTable [ vcname000001: testdb: tt2] Sync Start\nTable [ vcname000001 testdb: tt2] Sync End cost : <0 s,145 ms>\n*************Gcluster Sync Tool End With Success**************\n[gbase@gbase_rh7_001 gcluster_rsynctool]$<\/code><\/pre>\n\n\n\n<\/span>\u540c\u6b65\u7ed3\u679c<\/span><\/h3>\n\n\n\n[gbase@gbase_rh7_001 gcluster_rsynctool]$ gccli -h10.0.2.102 -e\"show tables\" -Dtestdb\n+------------------+\n| Tables_in_testdb |\n+------------------+\n| t1 |\n| t2 |\n| t2_inc |\n| t3_inc |\n| t_inc |\n| t_pid |\n| tidname |\n| tmp2 |\n| tmp3 |\n| tt |\n| tt2 |\n+------------------+\n[gbase@gbase_rh7_001 gcluster_rsynctool]$ gccli -h10.0.2.102 -e\"select count(*) from t1\" -Dtestdb\n+----------+\n| count(*) |\n+----------+\n| 590000 |\n+----------+\n[gbase@gbase_rh7_001 gcluster_rsynctool]$\n<\/code><\/pre>\n\n\n\n<\/span>\u5f71\u54cd<\/span><\/h2>\n\n\n\n\u6839\u636e\u547d\u4ee4\u53c2\u6570\uff0c\u53ef\u4ee5\u770b\u5230\u5bf9\u8868\u662f\u6709\u9501\u7684(meta_lock\u7684\u72ec\u5360\u9501)\uff0c\u9ed8\u8ba4\u662f600\u79d2\u3002<\/p>\n\n\n\n
--lock_table_timeout=LOCK_TABLE_TIMEOUT\n The timeout use by gcluster locking table\n [default:600,min:1,max:3600,unit:second]<\/code><\/pre>\n\n\n\n\u6240\u4ee5\u65e0\u8bba\u662f\u4e3b\u5e93\u8fd8\u662f\u5907\u5e93\uff0c\u90fd\u4e0d\u5efa\u8bae\u5728\u4e1a\u52a1\u9ad8\u5cf0\u671f\u505a\u540c\u6b65\uff0c\u9664\u975e\u540c\u6b65\u7684\u662f\u5f53\u524d\u4e0d\u5e38\u7528\u7684\u5386\u53f2\u8868\u3002<\/p>\n\n\n\n
\u4e3b\u96c6\u7fa4\u9501<\/p>\n\n\n\n
Total : 1\n +====================================================================================+\n | GCLUSTER LOCK |\n +====================================================================================+\n +-------------------------------+----------+--------------+--------------+------+----+\n | Lock name | owner | content | create time |locked|type|\n +-------------------------------+----------+--------------+--------------+------+----+\n | gc-event-lock |10.0.2.101|global master |20220822112351| TRUE | E |\n +-------------------------------+----------+--------------+--------------+------+----+\n | vc00001.hashmap_lock |10.0.2.101|416(LWP:21132)|20220822154731| TRUE | S |\n +-------------------------------+----------+--------------+--------------+------+----+\n | vc00001.testdb.db_lock |10.0.2.101|416(LWP:21132)|20220822154731| TRUE | S |\n +-------------------------------+----------+--------------+--------------+------+----+\n | vc00001.testdb.t1.meta_lock |10.0.2.101|416(LWP:21132)|20220822154731| TRUE | E |\n +-------------------------------+----------+--------------+--------------+------+----+\n |vc00001.testdb.table_space_lock|10.0.2.101|416(LWP:21132)|20220822154731| TRUE | S |\n +-------------------------------+----------+--------------+--------------+------+----+\n<\/code><\/pre>\n\n\n\n\u5907\u96c6\u7fa4\u9501<\/p>\n\n\n\n
+====================================================================================+\n | GCLUSTER LOCK |\n +====================================================================================+\n +-------------------------------+----------+--------------+--------------+------+----+\n | Lock name | owner | content | create time |locked|type|\n +-------------------------------+----------+--------------+--------------+------+----+\n | gc-event-lock |10.0.2.102|global master |20220822141805| TRUE | E |\n +-------------------------------+----------+--------------+--------------+------+----+\n | vc00001.hashmap_lock |10.0.2.102|339(LWP:11140)|20220822154608| TRUE | S |\n +-------------------------------+----------+--------------+--------------+------+----+\n | vc00001.testdb.db_lock |10.0.2.102|339(LWP:11140)|20220822154608| TRUE | S |\n +-------------------------------+----------+--------------+--------------+------+----+\n | vc00001.testdb.t1.meta_lock |10.0.2.102|339(LWP:11140)|20220822154608| TRUE | E |\n +-------------------------------+----------+--------------+--------------+------+----+\n |vc00001.testdb.table_space_lock|10.0.2.102|339(LWP:11140)|20220822154608| TRUE | S |\n +-------------------------------+----------+--------------+--------------+------+----+\n<\/code><\/pre>","protected":false},"excerpt":{"rendered":"\u5357\u5927\u901a\u7528GBase 8a\u652f\u63012\u4e2a\u7ed3\u6784\u76f8\u540c\uff08\u4e3b\u5206\u7247\u6570\u4e00\u6837)\u7684\u96c6\u7fa4\u95f4\uff0c\u901a\u8fc7gcluster_rsynctool\u5de5\u5177\u505a\u8868\u7ea7\u7684\u6570\u636e\u540c\u6b65\uff0c\u5e38\u7528\u4e8e\u8de8\u96c6\u7fa4\u7684\u8868\u6570\u636e\u8fc1\u79fb\uff0c\u4e3b\u5907\u96c6\u7fa4\u7684\u6570\u636e\u540c\u6b65\u7b49\u3002\u672c\u6587\u4ecb\u7ecd\u8be5\u5de5\u5177\u7684\u4e00\u4e2a\u4f7f\u7528\u6837\u4f8b\u3002<\/p>","protected":false},"author":1,"featured_media":0,"comment_status":"closed","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[3],"tags":[],"class_list":["post-10284","post","type-post","status-publish","format-standard","hentry","category-gbase8a"],"_links":{"self":[{"href":"https:\/\/www.gbase8.cn\/en\/wp-json\/wp\/v2\/posts\/10284","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/www.gbase8.cn\/en\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.gbase8.cn\/en\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.gbase8.cn\/en\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/www.gbase8.cn\/en\/wp-json\/wp\/v2\/comments?post=10284"}],"version-history":[{"count":25,"href":"https:\/\/www.gbase8.cn\/en\/wp-json\/wp\/v2\/posts\/10284\/revisions"}],"predecessor-version":[{"id":12044,"href":"https:\/\/www.gbase8.cn\/en\/wp-json\/wp\/v2\/posts\/10284\/revisions\/12044"}],"wp:attachment":[{"href":"https:\/\/www.gbase8.cn\/en\/wp-json\/wp\/v2\/media?parent=10284"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.gbase8.cn\/en\/wp-json\/wp\/v2\/categories?post=10284"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.gbase8.cn\/en\/wp-json\/wp\/v2\/tags?post=10284"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}