---
name: test
task-mode: incremental
is-sharding: true
shard-mode: "optimistic"
meta-schema: "dm_meta"
ignore-checking-items: ["all"]

target-database:
  host: "127.0.0.1"
  port: 4000
  user: "test"
  password: '123456'

mysql-instances:
  - source-id: "mysql-replica-01"
    block-allow-list:  "instance"
    route-rules: ["sharding-table-rules","sharding-schema-rules"]
    mydumper-config-name: "global"
    loader-config-name: "global"
    syncer-config-name: "global"
    meta:
      binlog-pos: pos-holder
      binlog-name: name-holder
  - source-id: "mysql-replica-02"
    block-allow-list:  "instance"
    route-rules: ["sharding-table-rules","sharding-schema-rules"]
    mydumper-config-name: "global"
    loader-config-name: "global"
    syncer-config-name: "global"
    meta:
      binlog-gtid: gtid-holder  

block-allow-list:
  instance:
    do-dbs: ["shardddl1","shardddl2"]

routes:
  sharding-table-rules:
    schema-pattern: "shardddl*"
    target-schema: "shardddl"
    table-pattern: "tb*"
    target-table: "tb"
  sharding-schema-rules:
    schema-pattern: "shardddl*"
    target-schema: "shardddl"

mydumpers:
  global:
    threads: 4
    chunk-filesize: 64
    skip-tz-utc: true
    extra-args: ""

loaders:
  global:
    pool-size: 16
    dir: "./dumped_data"

syncers:
  global:
    worker-count: 16
    batch: 100