---
title: "数据校验"
method: POST
path: "/mysql/pt-table-checksum"
tags: ["mysql"]
---

# 数据校验

`POST /mysql/pt-table-checksum`

数据校验

## Request body

- DbmServicesMysqlDbToolsDbactuatorPkgComponentsMysqlPtTableChecksumComp
  - `extend` DbmServicesMysqlDbToolsDbactuatorPkgComponentsMysqlPtTableChecksumParam
    - `bk_biz_id` integer — 业务 id
    - `cluster_id` integer — 集群 id
    - `db_patterns` string[] — 库表过滤选项
    - `ignore_dbs` string[] — 库表过滤选项
    - `ignore_tables` string[] — 库表过滤选项
    - `immute_domain` string — 集群域名
    - `inner_role` string — 执行校验的 db inner role, 应该是[master, repeater]
    - `master_access_slave_password` string — 从 db 访问 slave 的密码
    - `master_access_slave_user` string — 从 db 访问 slave 的用户名
    - `master_ip` string — 执行校验的 db ip
    - `master_port` integer — 执行校验的 db port
    - `replicate_table` string — 结果表, 带库前缀
    - `runtime_hour` integer — 校验运行时长
    - `slaves` DbmServicesMysqlDbToolsDbactuatorPkgComponentsMysqlSlaveInfo[] — slave 列表
      - `id` integer — slave id
      - `ip` string — slave ip
      - `port` integer — slave port
    - `system_dbs` string[] — 系统表
    - `table_patterns` string[] — 库表过滤选项
  - `general` DbmServicesMysqlDbToolsDbactuatorPkgComponentsGeneralParam
    - `runtime_account` DbmServicesMysqlDbToolsDbactuatorPkgComponentsRuntimeAccountParam
      - `admin_pwd` string — mysql admin 密码，环境变量 GENERAL_ACCOUNT_admin_pwd
      - `admin_user` string — mysql admin 账户，环境变量 GENERAL_ACCOUNT_admin_user
      - `backup_pwd` string — dbbackup pwd
      - `backup_user` string — dbbackup user
      - `monitor_access_all_pwd` string — mysql monitor@% 密码
      - `monitor_access_all_user` string — mysql monitor@%
      - `monitor_pwd` string — mysql monitor 密码，环境变量 GENERAL_ACCOUNT_monitor_pwd
      - `monitor_user` string — mysql monitor 账户，环境变量 GENERAL_ACCOUNT_monitor_user
      - `proxy_admin_pwd` string — proxy admin pwd
      - `proxy_admin_user` string — proxy admin user
      - `repl_pwd` string — repl pwd, 环境变量 GENERAL_ACCOUNT_repl_pwd
      - `repl_user` string — repl user, 环境变量 GENERAL_ACCOUNT_repl_user
      - `tdbctl_pwd` string
      - `tdbctl_user` string
      - `yw_pwd` string — yw pwd
      - `yw_user` string — yw user
    - `runtime_extend` DbmServicesMysqlDbToolsDbactuatorPkgComponentsRuntimeExtend
      - `mysql_sys_users` string[]

---

[API](https://skmtc.net/tencentblueking/apis/dbactuator-api.md) · [All operations](https://skmtc.net/tencentblueking/apis/dbactuator-api/llms.txt) · [OpenAPI document](https://skmtc-service-staging.skmtc.workers.dev/v1/apis/tencentblueking/dbactuator-api/versions/dc22dd49fd50/schema)