[gbase@xdw0 gcluster_rsynctool]$ python gcluster_rsynctool.py -h
Usage: gcluster_rsynctool.py [optinos]
Options:
-h, --help show this help message and exit
-v, --version output version information and exit--master_mpp_ip=MASTER_MPP_IP
The ipaddress of master mpp gcluster,only support IPV4
--master_mpp_ip_mapping_file=MASTER_MPP_IP_MAPPING_FILE
The filefor master mpp gcluster ipaddress transform
fileformat is json,only support IPV4
--master_mpp_gc_port=MASTER_MPP_GC_PORT
The port of master mpp gcluster[default:5258]--master_mpp_gn_port=MASTER_MPP_GN_PORT
The port of master mpp gcluster's gnode[default:5050]
--slave_mpp_ip=SLAVE_MPP_IP
The ipaddress of slave mpp gcluster,only support IPV4
--slave_mpp_ip_mapping_file=SLAVE_MPP_IP_MAPPING_FILE
The file for slave mpp gcluster ipaddress transform
file format is json,only support IPV4
--slave_mpp_gc_port=SLAVE_MPP_GC_PORT
The port of slave mpp gcluster[default:5258]
--slave_mpp_gn_port=SLAVE_MPP_GN_PORT
The port of slave mpp gcluster's gnode[default:5050]--master_mpp_gc_pw=MASTER_MPP_GC_PW
The password of master mpp gcluster's database
user[default:gbase20110531]
--slave_mpp_gc_pw=SLAVE_MPP_GC_PW
The password of slave mpp gcluster's database
user[default:gbase20110531]--database_user=DATABASE_USER
A database user having rights to access tables defined
in'table_list_file', this user
should exist in both master gcluster and slave
gcluster[default:gbase]--table_list_file=TABLE_LIST_FILE
The filewhich contain the table list should be synced
--table_parallel_degree=TABLE_PARALLEL_DEGREE
The parallel degree for how many tables should be
synced [default:1, min:1, max:128]--lock_table_timeout=LOCK_TABLE_TIMEOUT
The timeout use by gcluster locking table
[default:600,min:1,max:3600,unit:second]--retry_times=RETRY_TIMES
Synctool retry times[default:1, min:1,
max:10,unit:times]--retry_interval=RETRY_INTERVAL
The interval time between synctool retry [default:10,
min:1, max:1800,unit:second]--sync_mode=SYNC_MODE
The synctool mode [default:2, min:1, max:3];1: do table level scn check;2:
not to do table level scn check,just check each column
scn;3: not to do scn check
,just sync whole table data;--error_table_list_file=ERROR_TABLE_LIST_FILE
The file output for failed table list[default:{$table_
list_file}_error_table_list_{%Y_%m_%d-%H:%M:%S}.log]--log_name=LOG_NAME The log file
name[default:{$table_list_file}_{%Y_%m_%d}.log]--log_level=LOG_LEVEL
The gcluster_rsynctool's log level [default:3, min:0,
max:5]; 0: nolog level;
1: critical level 2: error level
3: warning level 4: info level
5: debug level
--rsync_mode=RSYNC_MODE
The gcluster_rsynctool's rsync_mode [default:2, min:0,
max:2];0: sync major slice and
set status on backup slice;1:
sync major slice and backup slice at the same;2: sync major slice first and thensync the backup
slice if major slice sync success
.--double_check check data that already write on disk.[default:false]--slave_create_table_if_not_exists
create table if not exists on slave
mpp.[default:false]--cleanup_uncontrolled_data=CLEANUP_UNCONTROLLED_DATA
whether clean up uncontrolled data on target table
[default:0, min:0, max:1];0:
not clean up uncontrolled data on target data;1: clean up uncontrolled data on target data;
gbase>desc sun;+-------+--------------+------+-----+-------------------+-----------------------------+| Field |Type|Null|Key|Default| Extra |+-------+--------------+------+-----+-------------------+-----------------------------+| a |int(11)| YES ||NULL||| b |double| YES ||NULL||| c |varchar(100)| YES ||NULL||| d |text| YES ||NULL||| e |blob| YES ||NULL||| f |longblob| YES ||NULL||| g |date| YES ||NULL||| h |timestamp|NO||CURRENT_TIMESTAMP|onupdateCURRENT_TIMESTAMP|+-------+--------------+------+-----+-------------------+-----------------------------+8rowsinset(Elapsed: 00:00:00.00)