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

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