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

     1  ---
     2  name: test_incremental_no_source_meta
     3  task-mode: incremental
     4  is-sharding: true
     5  meta-schema: "dm_meta"
     6  enable-heartbeat: false
     7  ignore-checking-items: ["version"]
     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      meta:
    26        binlog-gtid: ""
    27  
    28    - source-id: "mysql-replica-02"
    29      block-allow-list:  "instance"
    30      route-rules: ["sharding-route-rules-table", "sharding-route-rules-schema"]
    31      mydumper-config-name: "global"
    32      loader-config-name: "global"
    33      syncer-config-name: "global"
    34      # ignore t_2's alter event by task config
    35      filter-rules: ["user-filter-2"]
    36      meta:
    37        binlog-gtid: ""
    38  
    39  block-allow-list:
    40    instance:
    41      do-dbs: ["dmctl"]
    42      do-tables:
    43        -  db-name: "dmctl"
    44           tbl-name: "~^t_[\\d]+"
    45        -  db-name: "dmctl"
    46           tbl-name: "flush_trigger"
    47  
    48  routes:
    49    sharding-route-rules-table:
    50      schema-pattern: dmctl
    51      table-pattern: t_*
    52      target-schema: dmctl
    53      target-table: t_target
    54  
    55    sharding-route-rules-schema:
    56      schema-pattern: dmctl
    57      target-schema: dmctl
    58  
    59  mydumpers:
    60    global:
    61      threads: 4
    62      chunk-filesize: 64
    63      skip-tz-utc: true
    64      extra-args: ""
    65  
    66  loaders:
    67    global:
    68      pool-size: 16
    69      dir: "./dumped_data"
    70  
    71  syncers:
    72    global:
    73      worker-count: 16
    74      batch: 100
    75      checkpoint-flush-interval: 1
    76      compact: true
    77      multiple-rows: true
    78  
    79  filters:
    80    user-filter-1:
    81      schema-pattern: "dmctl"
    82      table-pattern: "t_1"
    83      events: ["all"]
    84      action: Do
    85    user-filter-2:
    86      schema-pattern: "dmctl"
    87      table-pattern: "t_2"
    88      sql-pattern: ["alter table .* add column aaa int"]
    89      action: Ignore