产品概述
应用场景
产品架构
实例类型
兼容性说明
使用规范建议
## 部署 TiUPcurl --proto '=https' --tlsv1.2 -sSf https://tiup-mirrors.pingcap.com/install.sh | shsource /root/.bash_profile## 部署 BR 并升级到最新版本tiup install brtiup update --self && tiup update br
## 部署 TiDB2TDSQL 工具chmod +x bin/tidb2tdsql
# 获取腾讯云对象存储 COS 桶的 secret_id 与 secret_keyexport AWS_ACCESS_KEY_ID=${cos_secret_id}export AWS_SECRET_ACCESS_KEY=${cos_secret_key}tiup br backup full --pd "${PD_IP}:2379" \\--storage "s3://db_br?endpoint=https://source_address.cos.ap-guangzhou.myqcloud.com?AWS_ACCESS_KEY_ID=${cos_secret_id}&AWS_SECRET_ACCESS_KEY=${cos_secret_key}" \\--s3.region="ap-guangzhou" \\--s3.provider="cos"
# 获取腾讯云对象存储 COS 桶的 secret_id 与 secret_keyexport AWS_ACCESS_KEY_ID=${cos_secret_id}export AWS_SECRET_ACCESS_KEY=${cos_secret_key}tiup br validate decode --field="end-version" \\--storage"s3://db_br?endpoint=https://source_address.cos.ap-guangzhou.myqcloud.com" \\--s3.region="ap-guangzhou" \\--s3.provider="cos" | tail -n1
463592975341191170
# 获取腾讯云对象存储 COS 桶的 secret_id 与 secret_keyexport AWS_ACCESS_KEY_ID=${cos_secret_id}export AWS_SECRET_ACCESS_KEY=${cos_secret_key}bin/tidb2tdsql dump --worker-count 64 \\--storage "s3://db_br?endpoint=https://source_address.cos.ap-guangzhou.myqcloud.com" \\--s3.region="ap-guangzhou" \\--s3.provider="cos" \\--output "s3://db_tdsql?endpoint=https://target_address.cos.ap-guangzhou.myqcloud.com"
{schema}-schema-create.sql：创建 schema 的 SQL 文件{schema}.{table}-schema.sql：创建表的 SQL 文件{schema}.{table}.{000000001}.{sql}：数据文件，按照分片存储{schema}.{view}-schema-view.sql：视图的 SQL 文件。$ cat metadata# Started dump at: 2026-01-15 17:54:08[myloader_session_variables]SQL_MODE='NO_ENGINE_SUBSTITUTION'[config]max-statement-size = 1048576# SHOW MASTER STATUS:# Log: tidb-br-dump# Pos: 463592975341191170# GTID:# Finished dump at: 2026-01-15 17:54:36
463592975341191170。Create changefeed successfully，则同步任务创建成功。normal，则同步任务正常。tiup cdc cli changefeed list --pd=http://172.16.6.122:2379[{"id": "totdsqlc","summary": {"state": "normal","tso": 463592975341191170,"checkpoint": "2026-01-15 17:54:36.270","error": null}}]
# Diff Configuration.######################### Datasource config #########################[data-sources][data-sources.upstream]host = "172.20.6.11" # 需要替换为实际上游集群 ipport = 4000user = "root"password = "YourPassword"snapshot = "436138236720447494" # 配置为实际的备份时间点 TSO[data-sources.downstream]host = "172.20.6.88" # 需要替换为实际下游集群 ipport = 3306user = "root"password = "YourPassword"######################### Task config #########################[task]output-dir = "./output"source-instances = ["upstream"]target-instance = "downstream"target-check-tables = ["*.*"]
文档反馈