github.com/pingcap/tiflow@v0.0.0-20240520035814-5bf52d54e205/dm/tests/dmctl_basic/conf/dm-task.yaml (about)

     1  ---
     2  name: test
     3  task-mode: all
     4  is-sharding: true
     5  meta-schema: "dm_meta"
     6  enable-heartbeat: false
     7  
     8  target-database:
     9    host: "127.0.0.1"
    10    port: 4000
    11    user: "root"
    12    password: ""
    13  
    14  mysql-instances:
    15    - source-id: "mysql-replica-01"
    16      block-allow-list:  "instance"
    17      route-rules: ["sharding-route-rules-table", "sharding-route-rules-schema"]
    18      mydumper-config-name: "global"
    19      loader-config-name: "global"
    20      syncer-config-name: "global"
    21      # sync t_1's alter event by task config(overwrite)
    22      # ignore t_2's alter event by source config
    23      filter-rules: ["user-filter-1"]
    24  
    25    - source-id: "mysql-replica-02"
    26      block-allow-list:  "instance"
    27      route-rules: ["sharding-route-rules-table", "sharding-route-rules-schema"]
    28      mydumper-config-name: "global"
    29      loader-config-name: "global"
    30      syncer-config-name: "global"
    31      # ignore t_2's alter event by task config
    32      filter-rules: ["user-filter-2"]
    33  
    34  block-allow-list:
    35    instance:
    36      do-dbs: ["dmctl"]
    37      do-tables:
    38      -  db-name: "dmctl"
    39         tbl-name: "~^t_[\\d]+"
    40      -  db-name: "dmctl"
    41         tbl-name: "flush_trigger"
    42  
    43  routes:
    44    sharding-route-rules-table:
    45      schema-pattern: dmctl
    46      table-pattern: t_*
    47      target-schema: dmctl
    48      target-table: t_target
    49  
    50    sharding-route-rules-schema:
    51      schema-pattern: dmctl
    52      target-schema: dmctl
    53  
    54  mydumpers:
    55    global:
    56      threads: 4
    57      chunk-filesize: 64
    58      skip-tz-utc: true
    59      extra-args: ""
    60  
    61  loaders:
    62    global:
    63      pool-size: 16
    64      dir: "./dumped_data"
    65  
    66  syncers:
    67    global:
    68      worker-count: 16
    69      batch: 100
    70      checkpoint-flush-interval: 1
    71      compact: true
    72      multiple-rows: true
    73  
    74  filters:
    75    user-filter-1:
    76      schema-pattern: "dmctl"
    77      table-pattern: "t_1"
    78      events: ["all"]
    79      action: Do
    80    user-filter-2:
    81      schema-pattern: "dmctl"
    82      table-pattern: "t_2"
    83      sql-pattern: ["alter table .* add column aaa int"]
    84      action: Ignore