---
name: test
task-mode: all
is-sharding: false
meta-schema: "dm_meta"

target-database:
  host: "127.0.0.1"
  port: 4000
  user: "root"
  password: ""

mysql-instances:
  - source-id: "mysql-replica-01"
    block-allow-list:  "instance"
    route-rules: [ "extend-column-table-rules", "extend-column-table-source-schema-rules" ]
    mydumper-config-name: "global"
    loader-config-name: "global"
    syncer-config-name: "global"
  - source-id: "mysql-replica-02"
    block-allow-list:  "instance"
    route-rules: [ "extend-column-table-source-schema-rules" ]
    mydumper-config-name: "global"
    loader-config-name: "global"
    syncer-config-name: "global"

block-allow-list:
  instance:
    do-dbs: ["extend_column*"]

routes:
  extend-column-table-rules:
    schema-pattern: "extend_column*"
    target-schema: "extend_column"
    table-pattern: "y*"
    target-table: "y"
    extract-table:
      table-regexp: "y([0-9a-zA-Z]+)"
      target-column: "c_table"
  extend-column-table-source-schema-rules:
    schema-pattern: "extend_column*"
    target-schema: "extend_column"
    table-pattern: "t*"
    target-table: "t"
    extract-table:
      table-regexp: "t(.*)"
      target-column: "c_table"
    extract-schema:
      schema-regexp: "(.*)"
      target-column: "c_schema"
    extract-source:
      source-regexp: "mysql-(.*)-([0-9]+)"
      target-column: "c_source"

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

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

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