---
name: test
task-mode: all
is-sharding: false
meta-schema: "dm_meta"
heartbeat-update-interval: 1
heartbeat-report-interval: 1
case-sensitive: true

target-database:
  host: "127.0.0.1"
  port: 4000
  user: "root"
  password: ""
  session:
    tidb_skip_utf8_check: 1
    tidb_disable_txn_auto_retry: off
    tidb_retry_limit: "10"

mysql-instances:
  - source-id: "mysql-replica-01"
    black-white-list:  "instance" # compatible with deprecated config
    mydumper-config-name: "global"
    loader-config-name: "global"
    syncer-config-name: "global"
    route-rules: ["global"]
    filter-rules: ["global"]

  - source-id: "mysql-replica-02"
    block-allow-list:  "instance"
    mydumper-config-name: "global"
    loader-config-name: "global"
    syncer-config-name: "global"
    route-rules: ["global"]
    filter-rules: ["global"]

black-white-list: # compatible with deprecated config
  instance:
    do-dbs: ["Upper_DB*", "lower_db"]
    do-tables:
      - db-name: "Upper_DB*"
        tbl-name: "Do_Table*"
      - db-name: "Upper_DB"
        tbl-name: "lower_table*"
      - db-name: "lower_db"
        tbl-name: "Upper_Table*"

routes:
  global:
    schema-pattern: "Upper_DB"
    table-pattern: "Do_Table"
    target-schema: "UPPER_DB_ROUTE"
    target-table: "do_table_route"

filters:
  global:
    schema-pattern: "Upper_DB*"
    table-pattern: "Do_Table*"
    events: ["truncate table"]
    action: Ignore

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
    enable-ansi-quotes: false  # compatible with deprecated config