github.com/pingcap/tiflow@v0.0.0-20240520035814-5bf52d54e205/dm/tests/online_ddl/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  online-ddl: 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: ["gho-sharding-route-rules-table", "pt-sharding-route-rules-table", "sharding-route-rules-schema"]
    19      mydumper-config-name: "global"
    20      loader-config-name: "global"
    21      syncer-config-name: "global"
    22      filter-rules: ["filter-rule-index"]
    23  
    24    - source-id: "mysql-replica-02"
    25      meta:
    26        binlog-name: binlog.000001
    27        binlog-pos: 4
    28      block-allow-list:  "instance"
    29      route-rules: ["gho-sharding-route-rules-table", "pt-sharding-route-rules-table", "sharding-route-rules-schema"]
    30      mydumper-config-name: "global"
    31      loader-config-name: "global"
    32      syncer-config-name: "global"
    33      filter-rules: ["filter-rule-index"]
    34  
    35  block-allow-list:
    36    instance:
    37      do-dbs: ["online_ddl"]
    38      do-tables:
    39      -  db-name: "online_ddl"
    40         tbl-name: "~^((pt)|(gho))_t[1-3]$"
    41  
    42  routes:
    43    gho-sharding-route-rules-table:
    44      schema-pattern: online_ddl
    45      table-pattern: gho_t*
    46      target-schema: online_ddl
    47      target-table: gho_t_target
    48  
    49    pt-sharding-route-rules-table:
    50      schema-pattern: online_ddl
    51      table-pattern: pt_t*
    52      target-schema: online_ddl
    53      target-table: pt_t_target
    54  
    55    sharding-route-rules-schema:
    56      schema-pattern: online_ddl
    57      target-schema: online_ddl
    58    
    59  filters:
    60    filter-rule-index:
    61      schema-pattern: "*"
    62      table-pattern: "*"
    63      events: ["create index","drop index"]
    64      sql-pattern: ["ALTER\\s.*TABLE[\\s\\S]*ADD\\s+KEY\\s+NAME", "ALTER\\s.*TABLE[\\s\\S]*DROP\\s+KEY"]
    65      action: Ignore
    66  
    67  mydumpers:
    68    global:
    69      threads: 4
    70      chunk-filesize: 64
    71      skip-tz-utc: true
    72      extra-args: ""
    73  
    74  loaders:
    75    global:
    76      pool-size: 16
    77      dir: "./dumped_data"
    78  
    79  syncers:
    80    global:
    81      worker-count: 16
    82      batch: 100