xqwbx163
(Xqwbx163)
1
在同一个mysql实例下,我有10个库,每个库下面有同样的两张表test1,test2
我打算把这个mysql同步到同一个TIDB库下,合库合表,一个库两个表
通过dm-portal 可视化界面配置以后,
Welcome to dmctl
Release Version: v1.0.0-9-gac64db13
Git Commit Hash: ac64db13f24ace3c1bf61790de11519ee88f148a
Git Branch: master
UTC Build Time: 2019-09-05 08:25:59
Go Version: go version go1.12 linux/amd64
» check-task ./new-task.yaml
{
“result”: false,
“msg”: “[code=26002:class=dm-master:scope=upstream:level=high] fail to initial checker: failed to open DSN dm:***@192.168.1.2:3306
github.com/pingcap/dm/pkg/terror.(*Error).Generate
/home/jenkins/workspace/build_dm_master/go/src/github.com/pingcap/dm/pkg/terror/terror.go:232
github.com/pingcap/dm/checker.(*Checker).Init
/home/jenkins/workspace/build_dm_master/go/src/github.com/pingcap/dm/checker/checker.go:129
github.com/pingcap/dm/checker.CheckSyncConfig
/home/jenkins/workspace/build_dm_master/go/src/github.com/pingcap/dm/checker/cmd.go:50
github.com/pingcap/dm/dm/master.(*Server).generateSubTask
/home/jenkins/workspace/build_dm_master/go/src/github.com/pingcap/dm/dm/master/server.go:1847
github.com/pingcap/dm/dm/master.(*Server).CheckTask
/home/jenkins/workspace/build_dm_master/go/src/github.com/pingcap/dm/dm/master/server.go:1816
github.com/pingcap/dm/dm/pb._Master_CheckTask_Handler
/home/jenkins/workspace/build_dm_master/go/src/github.com/pingcap/dm/dm/pb/dmmaster.pb.go:1818
google.golang.org/grpc.(*Server).processUnaryRPC
/go/pkg/mod/google.golang.org/grpc@v1.23.0/server.go:995
google.golang.org/grpc.(*Server).handleStream
/go/pkg/mod/google.golang.org/grpc@v1.23.0/server.go:1275
google.golang.org/grpc.(*Server).serveStreams.func1.1
/go/pkg/mod/google.golang.org/grpc@v1.23.0/server.go:710
runtime.goexit
/usr/local/go/src/runtime/asm_amd64.s:1337”
}
1 个赞
datahoe
(Datahoe)
2
麻烦发一下 task 及相关配置文件,从报错信息看,数据库建立连接失败,确认一下上游数据库是可以正常访问的吗?用户是否有足够的权限
xqwbx163
(Xqwbx163)
3
我确认过,数据库连接没有问题,上游数据库是可以访问的。
配置如下:
name: increate
task-mode: incremental
is-sharding: true
target-database:
host: xxx
port: 4000
user: xxx
password: xxxx
mysql-instances:
- source-id: replica-1
meta:
binlog-name: mysql-bin.0000253
binlog-pos: 4
filter-rules: []
route-rules:
- replica-1.route_rules.6
- replica-1.route_rules.8
- replica-1.route_rules.10
- replica-1.route_rules.13
- replica-1.route_rules.16
- replica-1.route_rules.21
- replica-1.route_rules.1
- replica-1.route_rules.4
- replica-1.route_rules.5
- replica-1.route_rules.18
- replica-1.route_rules.19
- replica-1.route_rules.20
- replica-1.route_rules.22
- replica-1.route_rules.24
- replica-1.route_rules.27
- replica-1.route_rules.2
- replica-1.route_rules.7
- replica-1.route_rules.17
- replica-1.route_rules.25
- replica-1.route_rules.29
- replica-1.route_rules.3
- replica-1.route_rules.9
- replica-1.route_rules.31
- replica-1.route_rules.14
- replica-1.route_rules.23
- replica-1.route_rules.30
- replica-1.route_rules.11
- replica-1.route_rules.12
- replica-1.route_rules.15
- replica-1.route_rules.26
- replica-1.route_rules.28
black-white-list: replica-1.bw_list.1
mydumper-config-name: replica-1.dump
routes:
replica-1.route_rules.1:
schema-pattern: test_10
table-pattern: “”
target-schema: test
target-table: “”
replica-1.route_rules.2:
schema-pattern: test_1
table-pattern: test_table_1
target-schema: test
target-table: test_table_1
replica-1.route_rules.3:
schema-pattern: test_10
table-pattern: test_table_1
target-schema: test
target-table: test_table_1
replica-1.route_rules.4:
schema-pattern: test_11
table-pattern: test_table_1
target-schema: test
target-table: test_table_1
replica-1.route_rules.5:
schema-pattern: test_12
table-pattern: test_table_1
target-schema: test
target-table: test_table_1
replica-1.route_rules.6:
schema-pattern: test_13
table-pattern: test_table_1
target-schema: test
target-table: test_table_1
replica-1.route_rules.7:
schema-pattern: test_14
table-pattern: test_table_1
target-schema: test
target-table: test_table_1
replica-1.route_rules.8:
schema-pattern: test_15
table-pattern: test_table_1
target-schema: test
target-table: test_table_1
replica-1.route_rules.9:
schema-pattern: test_2
table-pattern: test_table_1
target-schema: test
target-table: test_table_1
replica-1.route_rules.10:
schema-pattern: test_3
table-pattern: test_table_1
target-schema: test
target-table: test_table_1
replica-1.route_rules.11:
schema-pattern: test_4
table-pattern: test_table_1
target-schema: test
target-table: test_table_1
replica-1.route_rules.12:
schema-pattern: test_5
table-pattern: test_table_1
target-schema: test
target-table: test_table_1
replica-1.route_rules.13:
schema-pattern: test_6
table-pattern: test_table_1
target-schema: test
target-table: test_table_1
replica-1.route_rules.14:
schema-pattern: test_7
table-pattern: test_table_1
target-schema: test
target-table: test_table_1
replica-1.route_rules.15:
schema-pattern: test_8
table-pattern: test_table_1
target-schema: test
target-table: test_table_1
replica-1.route_rules.16:
schema-pattern: test_9
table-pattern: test_table_1
target-schema: test
target-table: test_table_1
replica-1.route_rules.17:
schema-pattern: test_1
table-pattern: test_table_2
target-schema: test
target-table: test_table_2
replica-1.route_rules.18:
schema-pattern: test_10
table-pattern: test_table_2
target-schema: test
target-table: test_table_2
replica-1.route_rules.19:
schema-pattern: test_11
table-pattern: test_table_2
target-schema: test
target-table: test_table_2
replica-1.route_rules.20:
schema-pattern: test_12
table-pattern: test_table_2
target-schema: test
target-table: test_table_2
replica-1.route_rules.21:
schema-pattern: test_13
table-pattern: test_table_2
target-schema: test
target-table: test_table_2
replica-1.route_rules.22:
schema-pattern: test_14
table-pattern: test_table_2
target-schema: test
target-table: test_table_2
replica-1.route_rules.23:
schema-pattern: test_15
table-pattern: test_table_2
target-schema: test
target-table: test_table_2
replica-1.route_rules.24:
schema-pattern: test_2
table-pattern: test_table_2
target-schema: test
target-table: test_table_2
replica-1.route_rules.25:
schema-pattern: test_3
table-pattern: test_table_2
target-schema: test
target-table: test_table_2
replica-1.route_rules.26:
schema-pattern: test_4
table-pattern: test_table_2
target-schema: test
target-table: test_table_2
replica-1.route_rules.27:
schema-pattern: test_5
table-pattern: test_table_2
target-schema: test
target-table: test_table_2
replica-1.route_rules.28:
schema-pattern: test_6
table-pattern: test_table_2
target-schema: test
target-table: test_table_2
replica-1.route_rules.29:
schema-pattern: test_7
table-pattern: test_table_2
target-schema: test
target-table: test_table_2
replica-1.route_rules.30:
schema-pattern: test_8
table-pattern: test_table_2
target-schema: test
target-table: test_table_2
replica-1.route_rules.31:
schema-pattern: test_9
table-pattern: test_table_2
target-schema: test
target-table: test_table_2
filters: {}
black-white-list:
replica-1.bw_list.1:
do-tables:
- db-name: test_1
tbl-name: test_table_1
- db-name: test_1
tbl-name: test_table_2
- db-name: test_10
tbl-name: test_table_1
- db-name: test_10
tbl-name: test_table_2
- db-name: test_11
tbl-name: test_table_1
- db-name: test_11
tbl-name: test_table_2
- db-name: test_12
tbl-name: test_table_1
- db-name: test_12
tbl-name: test_table_2
- db-name: test_13
tbl-name: test_table_1
- db-name: test_13
tbl-name: test_table_2
- db-name: test_14
tbl-name: test_table_1
- db-name: test_14
tbl-name: test_table_2
- db-name: test_15
tbl-name: test_table_1
- db-name: test_15
tbl-name: test_table_2
- db-name: test_2
tbl-name: test_table_1
- db-name: test_2
tbl-name: test_table_2
- db-name: test_3
tbl-name: test_table_1
- db-name: test_3
tbl-name: test_table_2
- db-name: test_4
tbl-name: test_table_1
- db-name: test_4
tbl-name: test_table_2
- db-name: test_5
tbl-name: test_table_1
- db-name: test_5
tbl-name: test_table_2
- db-name: test_6
tbl-name: test_table_1
- db-name: test_6
tbl-name: test_table_2
- db-name: test_7
tbl-name: test_table_1
- db-name: test_7
tbl-name: test_table_2
- db-name: test_8
tbl-name: test_table_1
- db-name: test_8
tbl-name: test_table_2
- db-name: test_9
tbl-name: test_table_1
- db-name: test_9
tbl-name: test_table_2
do-dbs: []
ignore-tables:
- db-name: xx_tmp
tbl-name: xxx
ignore-dbs: []
mydumpers:
replica-1.dump:
mydumper-path: bin/mydumper
threads: 4
chunk-filesize: 64
skip-tz-utc: true
extra-args: -T test_1.test_table_1,test_1.test_table_2,test_10.test_table_1,test_10.test_table_2,test_11.test_table_1,test_11.test_table_2,test_12.test_table_1,test_12.test_table_2,test_13.test_table_1,test_13.test_table_2,test_14.test_table_1,test_14.test_table_2,test_15.test_table_1,test_15.test_table_2,test_2.test_table_1,test_2.test_table_2,test_3.test_table_1,test_3.test_table_2,test_4.test_table_1,test_4.test_table_2,test_5.test_table_1,test_5.test_table_2,test_6.test_table_1,test_6.test_table_2,test_7.test_table_1,test_7.test_table_2,test_8.test_table_1,test_8.test_table_2,test_9.test_table_1,test_9.test_table_2
@xqwbx163
能麻烦执行 query-status 看一下当前的 relayStatus?
另外,在部署 DM 时,在 inventory.ini 内配置的上游 MySQL 密码是使用 dmctl 加密后的吗
system
(system)
关闭
5
此话题已在最后回复的 1 分钟后被自动关闭。不再允许新回复。