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

     1  name: test
     2  task-mode: all
     3  is-sharding: true
     4  shard-mode: pessimistic
     5  strict-optimistic-shard-mode: false
     6  ignore-checking-items: []
     7  meta-schema: dm_meta
     8  enable-heartbeat: false
     9  heartbeat-update-interval: 1
    10  heartbeat-report-interval: 10
    11  timezone: ""
    12  case-sensitive: false
    13  collation_compatible: loose
    14  target-database:
    15    host: 127.0.0.1
    16    port: 4000
    17    user: root
    18    password: '******'
    19    max-allowed-packet: null
    20    session:
    21      tidb_txn_mode: optimistic
    22    security: null
    23  mysql-instances:
    24  - source-id: mysql-replica-01
    25    meta: null
    26    filter-rules:
    27    - filter-01
    28    column-mapping-rules: []
    29    route-rules:
    30    - route-01
    31    - route-02
    32    expression-filters: []
    33    black-white-list: ""
    34    block-allow-list: balist-01
    35    mydumper-config-name: dump-01
    36    mydumper: null
    37    mydumper-thread: 0
    38    loader-config-name: load-01
    39    loader: null
    40    loader-thread: 0
    41    syncer-config-name: sync-01
    42    syncer: null
    43    syncer-thread: 0
    44    validator-config-name: validator-01
    45  - source-id: mysql-replica-02
    46    meta: null
    47    filter-rules:
    48    - filter-02
    49    column-mapping-rules: []
    50    route-rules:
    51    - route-01
    52    - route-02
    53    expression-filters: []
    54    black-white-list: ""
    55    block-allow-list: balist-01
    56    mydumper-config-name: dump-01
    57    mydumper: null
    58    mydumper-thread: 0
    59    loader-config-name: load-01
    60    loader: null
    61    loader-thread: 0
    62    syncer-config-name: sync-01
    63    syncer: null
    64    syncer-thread: 0
    65    validator-config-name: validator-01
    66  online-ddl: true
    67  shadow-table-rules: []
    68  trash-table-rules: []
    69  online-ddl-scheme: ""
    70  routes:
    71    route-01:
    72      schema-pattern: dmctl
    73      table-pattern: t_*
    74      target-schema: dmctl
    75      target-table: t_target
    76    route-02:
    77      schema-pattern: dmctl
    78      table-pattern: ""
    79      target-schema: dmctl
    80      target-table: ""
    81  filters:
    82    filter-01:
    83      schema-pattern: dmctl
    84      table-pattern: t_1
    85      events:
    86      - all
    87      sql-pattern: []
    88      action: Do
    89    filter-02:
    90      schema-pattern: dmctl
    91      table-pattern: t_2
    92      events: []
    93      sql-pattern:
    94      - alter table .* add column aaa int
    95      action: Ignore
    96  column-mappings: {}
    97  expression-filter: {}
    98  black-white-list: {}
    99  block-allow-list:
   100    balist-01:
   101      do-tables:
   102      - db-name: dmctl
   103        tbl-name: ~^t_[\d]+
   104      - db-name: dmctl
   105        tbl-name: flush_trigger
   106      do-dbs:
   107      - dmctl
   108      ignore-tables: []
   109      ignore-dbs: []
   110  mydumpers:
   111    dump-01:
   112      mydumper-path: ./bin/mydumper
   113      threads: 4
   114      chunk-filesize: "64"
   115      statement-size: 0
   116      rows: 0
   117      where: ""
   118      skip-tz-utc: true
   119      extra-args: ""
   120  loaders:
   121    load-01:
   122      pool-size: 16
   123      dir: ./dumped_data
   124      sorting-dir-physical: ./dumped_data.test.sorting
   125      import-mode: logical
   126      on-duplicate: ""
   127      on-duplicate-logical: replace
   128      on-duplicate-physical: none
   129      disk-quota-physical: 0
   130      checksum-physical: required
   131      analyze: optional
   132      range-concurrency: 0
   133      compress-kv-pairs: ""
   134      pd-addr: ""
   135  syncers:
   136    sync-01:
   137      meta-file: ""
   138      worker-count: 16
   139      batch: 100
   140      queue-size: 1024
   141      checkpoint-flush-interval: 1
   142      compact: true
   143      multiple-rows: true
   144      max-retry: 0
   145      auto-fix-gtid: false
   146      enable-gtid: false
   147      disable-detect: false
   148      safe-mode: false
   149      safe-mode-duration: 60s
   150      enable-ansi-quotes: false
   151  validators:
   152    validator-01:
   153      mode: none
   154      worker-count: 4
   155      validate-interval: 10s
   156      check-interval: 5s
   157      row-error-delay: 30m0s
   158      meta-flush-interval: 5m0s
   159      batch-query-size: 100
   160      max-pending-row-size: 500m
   161      max-pending-row-count: 2147483647
   162  clean-dump-file: true
   163  ansi-quotes: false
   164  remove-meta: false
   165  experimental:
   166    async-checkpoint-flush: false