override_to: boolean
override_tables:
- "*"
specify the compress properties when creating tables
compress_properties:
compresstype: 0
compress_level: 0
compress_chunk_size: 4096
compress_prealloc_chunks: 0
compress_byte_convert: false
compress_diff_convert: false

postgres destination connection
pg_conn:
host: "127.0.0.1"
port: "5432"
user: "opengauss_test"
password: "Sample@123"
database: "opengauss_database"
charset: "utf8"

sources:
mysql:
readers: 4
writers: 4
retry: 3
db_conn:
host: "127.0.0.1"
port: "3306"
user: "root"
password: "1234qwer"
charset: 'utf8'
connect_timeout: 10
schema_mappings:
test: public
limit_tables:
- delphis_mediterranea.foo
skip_tables:
- delphis_mediterranea.bar
enable_compress: No
compress_tables:
- delphis_mediterranea.foo
grant_select_to:
- usr_readonly
lock_timeout: "120s"
my_server_id: 100
replica_batch_size: 10000
replay_max_rows: 10000
batch_retention: '1 day'
copy_max_memory: "300M"
copy_mode: 'file'
out_dir: /tmp
csv_dir: /tmp
contain_columns: No
column_split: ','
sleep_loop: 1
on_error_replay: continue
on_error_read: continue
auto_maintenance: "disabled"
index_parallel_workers: 2
gtid_enable: false
type: mysql
skip_events:
insert:
- delphis_mediterranea.foo # skips inserts on delphis_mediterranea.foo
delete:
- delphis_mediterranea # skips deletes on schema delphis_mediterranea
update:
keep_existing_schema: No