为提高效率,提问时请提供以下信息,问题描述清晰可优先响应。
- dm2.0rc版本,任务得yam文件内容如:
name: mergetable917 # 任务名称,需要全局唯一
is-sharding: true
task-mode: all # 任务模式,可设为 “full”、“incremental”、“all”
shard-mode: “pessimistic” # 如果为分库分表"
meta-schema: “dm_meta” # 下游储存meta
信息的数据库
timezone: “Asia/Shanghai” # 时区
case-sensitive: false # schema/table 是否大小写敏感
online-ddl-scheme: “pt” # 目前仅支持 “gh-ost” 、“pt”
clean-dump-file: true
target-database:
host: “xx.xx.6.12”
port: 4000
user: “mysql2tidb”
password: “*****234”
routes:
user-route-tab1-schema:
schema-pattern: “testdb1”
target-schema: “testdb1”
user-tab11-rules:
schema-pattern: “testdb1”
table-pattern: “~^tab1_adjustment_header_view[1-9][0-5]?”
target-schema: “testdb1”
target-table: “tab1_adjustment_header_view”
user-tab12-rules:
schema-pattern: “testdb1”
table-pattern: “~^tab1_adjustment_header[1-9][0-5]?”
target-schema: “testdb1”
target-table: “tab1_adjustment_header”
user-tab13-rules:
schema-pattern: “testdb1”
table-pattern: “tab1_batch_create_log”
target-schema: “testdb1”
target-table: “tab1_batch_create_log”
user-tab14-rules:
schema-pattern: “testdb1”
table-pattern: “tab1_last_in_stock”
target-schema: “testdb1”
target-table: “tab1_last_in_stock”
user-route-tab2-schema:
schema-pattern: “testdb2”
target-schema: “testdb2”
user-tab2-rules:
schema-pattern: “testdb2”
table-pattern: “tab2_wave”
target-schema: “testdb2”
target-table: “tab2_wave”
block-allow-list:
bw-rule-1:
do-dbs: [ “testdb1”,“testdb2” ]
do-tables:- db-name: “testdb1”
tbl-name: “~^tab1_adjustment_(header|header_view)[1-9][0-5]?” , “tab1_batch_create_log”, “tab1_last_in_stock” - db-name: “testdb2”
tbl-name: “tab2_wave”
- db-name: “testdb1”
mydumpers: # mydumper process unit specific configs, mysql instance can ref one config in it
global:
threads: 2
chunk-filesize: 64
skip-tz-utc: true
loaders: # loader process unit specific configs, mysql instance can ref one config in it
global:
pool-size: 2
dir: “./dumped_data”
syncers: # syncer process unit specific configs, mysql instance can ref one config in it
global:
worker-count: 2
batch: 100
mysql-instances: # one or more source database, config more source database for sharding merge
source-id: "mysql-28" # unique in all instances, used as id when save checkpoints, configs, etc.
route-rules: ["user-route-tab1-schema","user-tab11-rules","user-tab12-rules","user-tab13-rules","user-tab14-rules","user-route-tab2-schema","user-tab2-rules"]
block-allow-list: "bw-rule-1"
mydumper-config-name: "global"
loader-config-name: "global"
syncer-config-name: "global"
- 【问题描述】:按照上面得配置,启动任务报错,报语法错误,1,一个表中有分表、也有部分不是分表得表怎么配置路由同步规则、以及黑白名单过滤。2、此任务是分库分表合表同步到tidb中,但是到tidb中还是tidb中。这个配置有什么问题
若提问为性能优化、故障排查类问题,请下载脚本运行。终端输出的打印结果,请务必全选并复制粘贴上传。