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

     1  ---
     2  name: upgrade_via_tiup_pessimistic
     3  task-mode: all
     4  is-sharding: true
     5  shard-mode: pessimistic
     6  enable-heartbeat: true
     7  case-sensitive: true
     8  
     9  target-database:
    10    host: tidb
    11    port: 4000
    12    user: "root"
    13    password: ""
    14  
    15  mysql-instances:
    16    - source-id: "mysql-replica-01"
    17      black-white-list:  "instance"
    18      route-rules: ["sharding-route-rules-table", "sharding-route-rules-schema"]
    19  
    20    - source-id: "mariadb-replica-02"
    21      black-white-list:  "instance"
    22      route-rules: ["sharding-route-rules-table", "sharding-route-rules-schema"]
    23  
    24  black-white-list:
    25    instance:
    26      do-dbs: ["~^pes_[Ss]harding[\\d]+"]
    27      do-tables:
    28      -  db-name: "~^pes_[sS]harding[\\d]+"
    29         tbl-name: "~^[Tt][\\d]+"
    30  
    31  routes:
    32    sharding-route-rules-table:
    33      schema-pattern: "pes_[sS]harding*"
    34      table-pattern: "[tT]*"
    35      target-schema: pes_db_target
    36      target-table: t_target
    37  
    38    sharding-route-rules-schema:
    39      schema-pattern: "pes_[sS]harding*"
    40      target-schema: pes_db_target