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

     1  ---
     2  name: test
     3  task-mode: "full"
     4  is-sharding: false
     5  meta-schema: "dm_meta"
     6  # enable-heartbeat: true
     7  heartbeat-update-interval: 1
     8  heartbeat-report-interval: 1
     9  clean-dump-file: false
    10  
    11  target-database:
    12    host: "127.0.0.1"
    13    port: 4000
    14    user: "test"
    15    password: '123456'
    16  
    17  mysql-instances:
    18    - source-id: "mysql-replica-01"
    19      meta:
    20        binlog-name: binlog-name-placeholder-1
    21        binlog-pos: 4
    22      block-allow-list:  "instance"
    23      mydumper-config-name: "global"
    24      loader-config-name: "global"
    25      syncer-config-name: "global"
    26  
    27    - source-id: "mysql-replica-02"
    28      meta:
    29        binlog-name: binlog-name-placeholder-2
    30        binlog-pos: 4
    31      block-allow-list:  "instance"
    32      route-rules: ["route-rule"]
    33      mydumper-config-name: "global"
    34      loader-config-name: "global"
    35      syncer-config-name: "global"
    36  
    37  block-allow-list:
    38    instance:
    39      do-dbs: ["dm_syncer", "dm_syncer_do_db"]
    40      ignore-dbs: ["~^dm_syncer_ignore_"]
    41      do-tables:
    42        - db-name: "dm_syncer"
    43          tbl-name: "~t.*"
    44        - db-name: "dm_syncer_do_db"
    45          tbl-name: "~^dm_syncer_do_db_."
    46        - db-name: "dm_syncer"
    47          tbl-name: "~^dm_syncer_route_rules_."
    48      ignore-tables:
    49        - db-name: "~^dm_syncer_ignore_"
    50          tbl-name: "~^dm_syncer_ignore_db_."
    51  
    52  mydumpers:
    53    global:
    54      threads: 4
    55      chunk-filesize: 64
    56      skip-tz-utc: true
    57      extra-args: ""
    58  
    59  loaders:
    60    global:
    61      pool-size: 16
    62      dir: "./dumped_data"
    63  
    64  syncers:
    65    global:
    66      worker-count: 16
    67      batch: 100
    68  
    69  routes:
    70    route-rule:
    71      schema-pattern: "dm_syncer"
    72      table-pattern: "dm_syncer_route_rules_*"
    73      target-schema: "dm_syncer"
    74      target-table: "dm_syncer_route_rule"