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

     1  ---
     2  name: sequence_sharding_optimistic
     3  task-mode: all
     4  is-sharding: true
     5  shard-mode: "optimistic"
     6  meta-schema: "dm_meta"
     7  # enable-heartbeat: true
     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  
    23    - source-id: "mysql-replica-02"
    24      block-allow-list:  "instance"
    25      route-rules: ["sharding-route-rules-table", "sharding-route-rules-schema"]
    26      mydumper-config-name: "global"
    27      loader-config-name: "global"
    28      syncer-config-name: "global"
    29  
    30  block-allow-list:
    31    instance:
    32      do-dbs: ["sharding_seq_opt", "sharding_seq_tmp"]
    33      do-tables:
    34      -  db-name: "sharding_seq_opt"
    35         tbl-name: "~^t[\\d]+"
    36      -  db-name: "sharding_seq_tmp"
    37         tbl-name: "~^t[\\d]+"
    38  
    39  routes:
    40    sharding-route-rules-table:
    41      schema-pattern: sharding_seq_opt*
    42      table-pattern: t*
    43      target-schema: sharding_target_opt
    44      target-table: t_target
    45  
    46    sharding-route-rules-schema:
    47      schema-pattern: sharding_seq_opt*
    48      target-schema: sharding_target_opt
    49  
    50  mydumpers:
    51    global:
    52      threads: 4
    53      chunk-filesize: 64
    54      skip-tz-utc: true
    55      extra-args: ""
    56  
    57  loaders:
    58    global:
    59      pool-size: 16
    60      dir: "./dumped_data"
    61  
    62  syncers:
    63    global:
    64      worker-count: 16
    65      batch: 100