is-sharding = false
shard-mode = "optimistic"
strict-optimistic-shard-mode = true
online-ddl = true
shadow-table-rules = []
trash-table-rules = []
online-ddl-scheme = ""
case-sensitive = false
collation_compatible = "loose"
name = "test"
mode = "all"
ignore-checking-items = []
source-id = "mysql-replica-02"
server-id = 0
flavor = ""
meta-schema = "dm_meta"
heartbeat-update-interval = 0
heartbeat-report-interval = 0
enable-heartbeat = false
timezone = ""
relay-dir = ""
use-relay = false
mydumper-path = "./bin/mydumper"
threads = 4
chunk-filesize = "64"
statement-size = 0
rows = 0
where = ""
skip-tz-utc = true
extra-args = ""
pool-size = 16
dir = "./dumped_data"
import-mode = "logical"
on-duplicate = ""
on-duplicate-logical = "replace"
meta-file = ""
worker-count = 16
batch = 100
queue-size = 1024
checkpoint-flush-interval = 1
compact = true
multiple-rows = true
max-retry = 0
auto-fix-gtid = false
enable-gtid = false
disable-detect = false
safe-mode = false
safe-mode-duration = "60s"
enable-ansi-quotes = false
log-level = ""
log-file = ""
log-format = ""
log-rotate = ""
pprof-addr = ""
status-addr = ""
clean-dump-file = false
ansi-quotes = false

[from]
  host = "127.0.0.1"
  port = 3307
  user = "root"
  password = "******"
  [from.session]

[to]
  host = "127.0.0.1"
  port = 4000
  user = "root"
  password = "******"
  [to.session]
    tidb_txn_mode = "optimistic"

[[route-rules]]
  schema-pattern = "dmctl"
  table-pattern = "t_*"
  target-schema = "dmctl"
  target-table = "t_target"

[[route-rules]]
  schema-pattern = "dmctl"
  table-pattern = ""
  target-schema = "dmctl"
  target-table = ""

[[filter-rules]]
  schema-pattern = "dmctl"
  table-pattern = "t_2"
  events = []
  sql-pattern = ["alter table .* add column aaa int"]
  action = "Ignore"

[[expression-filter]]
  schema = "expr_filter"
  table = "t1"
  insert-value-expr = "c_null IS NOT NULL"
  update-old-value-expr = ""
  update-new-value-expr = ""
  delete-value-expr = ""

[block-allow-list]
  do-dbs = ["dmctl"]
  ignore-tables = []
  ignore-dbs = []

  [[block-allow-list.do-tables]]
    db-name = "dmctl"
    tbl-name = "~^t_[\\d]+"

[ValidatorCfg]
  mode = ""
  worker-count = 0
  row-error-delay = "0s"
  meta-flush-interval = "0s"
  batch-query-size = 0

[experimental]
  async-checkpoint-flush = false