使用sync_diff_inspector 如何对比所有数据库

为提高效率,提问时请提供以下信息,问题描述清晰可优先响应。

  • 【TiDB 版本】:3.0.5
  • 【问题描述】: 使用sync_diff_inspector 如何对比所有数据库

目前看文档里的参数,是支持库下所有的表的对比。表支持正则表达式匹配。但是库不支持,如何配置对比所有数据库?

您好: 参考设置为全表试试 https://pingcap.com/docs-cn/v3.0/reference/tools/sync-diff-inspector/overview/#sync-diff-inspector-用户文档

image

测试过,报错,不支持

您好: 麻烦发一下报错,我再确认下,多谢

[tidb@localhost bin]$ ./sync_diff_inspector --config=./config.toml [2020/04/16 19:52:02.744 +08:00] [FATAL] [main.go:76] [“fail to initialize diff process”] [error=“schema target.~^h3.* not found”] [errorVerbose=“schema target.~^h3.* not found\ngithub.com/pingcap/errors.NotFoundf\n\t/home/jenkins/workspace/build_tidb_tools_master/go/pkg/mod/github.com/pingcap/errors@v0.11.1/juju_adaptor.go:75\nmain.(*Diff).AdjustTableConfig\n\t/home/jenkins/workspace/build_tidb_tools_master/go/src/github.com/pingcap/tidb-tools/sync_diff_inspector/diff.go:174\nmain.(*Diff).init\n\t/home/jenkins/workspace/build_tidb_tools_master/go/src/github.com/pingcap/tidb-tools/sync_diff_inspector/diff.go:86\nmain.NewDiff\n\t/home/jenkins/workspace/build_tidb_tools_master/go/src/github.com/pingcap/tidb-tools/sync_diff_inspector/diff.go:72\nmain.checkSyncState\n\t/home/jenkins/workspace/build_tidb_tools_master/go/src/github.com/pingcap/tidb-tools/sync_diff_inspector/main.go:74\nmain.main\n\t/home/jenkins/workspace/build_tidb_tools_master/go/src/github.com/pingcap/tidb-tools/sync_diff_inspector/main.go:62\nruntime.main\n\t/usr/local/go/src/runtime/proc.go:200\nruntime.goexit\n\t/usr/local/go/src/runtime/asm_amd64.s:1337”] [stack=“github.com/pingcap/log.Fatal\n\t/home/jenkins/workspace/build_tidb_tools_master/go/pkg/mod/github.com/pingcap/log@v0.0.0-20190307075452-bd41d9273596/global.go:59\nmain.checkSyncState\n\t/home/jenkins/workspace/build_tidb_tools_master/go/src/github.com/pingcap/tidb-tools/sync_diff_inspector/main.go:76\nmain.main\n\t/home/jenkins/workspace/build_tidb_tools_master/go/src/github.com/pingcap/tidb-tools/sync_diff_inspector/main.go:62\nruntime.main\n\t/usr/local/go/src/runtime/proc.go:200”]

您好: schema target.~^h3.* not found 请问要对比的两个库都有这些吗?