lab_code: dba_303_lab_ff8
title_en: "TiDB Admin Lab 9: Using sync-diff-inspector for Data Check"
title_zh: "管理 TiDB 实验 9: 使用 sync-diff-inspector 进行数据检查"
title_ja: "管理 TiDB 演習 9: データチェックに sync-diff-inspector を使用する"
title_ko: "TiDB 관리 실습 9: sync-diff-inspector를 사용하여 데이터 검사"
description_en: In this hands-on lab, you will learn how to use sync-diff-inspector for data check. Specifically, we will cover how to deploy the sync-diff-inspector tool, check data for TiDB upstream and downstream clusters.
description_zh: 在这个实验中，您将学习如何使用 sync-diff-inspector 进行数据检查。具体来说，我们将介绍如何部署 sync-diff-inspector 工具、检查 TiDB 上游和下游集群的数据。
description_ja: このハンズオン演習では、データチェックに sync-diff-inspector を使用する方法を学びます。具体的には、sync-diff-inspector ツールをデプロイし、TiDB の上流および下流クラスタのデータをチェックする方法について説明します。
description_ko: 이 실습에서는 sync-diff-inspector를 사용하여 데이터 검사를 수행하는 방법을 배우게 됩니다. 구체적으로, sync-diff-inspector 도구를 배포하고, TiDB 위와 아래 클러스터의 데이터를 검사하는 방법에 대해 설명합니다.
splash_image_en: https://lab-static.pingcap.com/quick-demo/dba_303_ch10_en.png
splash_image_ja: https://lab-static.pingcap.com/quick-demo/dba_303_ch10_en.png
splash_image_zh: https://lab-static.pingcap.com/quick-demo/dba_303_ch10_en.png
splash_image_ko: https://lab-static.pingcap.com/quick-demo/dba_303_ch10_en.png
external_materials_en:
  - name: "sync-diff-inspector Deck Template"
    url: https://docs.google.com/presentation/d/1fCW0tl8gJbSGkmaD1ln9_94tjH_6m0eq/edit?slide=id.p1#slide=id.p1
    employee_only: true
external_materials_ja:
  - name: "sync-diff-inspectorを運用するデッキテンプレート"
    url: https://docs.google.com/presentation/d/1fCW0tl8gJbSGkmaD1ln9_94tjH_6m0eq/edit?slide=id.p1#slide=id.p1
    employee_only: true
external_materials_zh:
  - name: "运维 sync-diff-inspector 演示文稿模板"
    url: https://docs.google.com/presentation/d/1fCW0tl8gJbSGkmaD1ln9_94tjH_6m0eq/edit?slide=id.p1#slide=id.p1
    employee_only: true
external_materials_ko:
  - name: "sync-diff-inspector를 운영하는 데크 템플릿"
    url: https://docs.google.com/presentation/d/1fCW0tl8gJbSGkmaD1ln9_94tjH_6m0eq/edit?slide=id.p1#slide=id.p1
    employee_only: true
lab_level: Beginner
category_en:
  - Data Migration
category_zh:
  - 数据迁移
category_ja:
  - データ移行
category_ko:
  - 데이터 마이그레이션
authors:
  - Fei Dong (CEG)
  - Todd Bao (CEG)
delivery_type: Instructor-Led
tidb_environments:
  - TiDB Self-Managed
tidb_versions:
  - 7.5.1
target_audience:
  - Architect
  - DBA
  - DevOps
regions:
  aws:
    - oregon
    - tokyo
    - singapore
    - frankfurt
credits: 1
credit_redeemable: true
employee_only: false
estimated_duration_minutes: 60

topology:
  - role: monitor
    node_count: 1
    web_ssh: true
    web_ssh_name: "TiUP Control Machine"
    ssh_user: ec2-user
  - role: pd
    node_count: 3
    ssh_user: ec2-user
  - role: kv
    node_count: 3
  - role: db
    node_count: 2
  - role: tiflash
    node_count: 1

requirements:
  - type: "CloudStack"

bootstrap:
  - name: "prepare monitor"
    type: "ShellScript"
    target:
      - monitor1
    script: ./scripts/prepare-monitor.sh

  - name: "prepare pd"
    type: "ShellScript"
    target:
      - pd1
      - pd2
    script: ./scripts/prepare-pd.sh

  - name: "prepare tidb"
    type: "ShellScript"
    target:
      - monitor1
    shell: |
      set -e
      sed -i "s|--yes|--yes >> /home/ec2-user/create-cluster-vinput.log 2>\&1|" /home/ec2-user/create-cluster-vinput.sh
      /home/ec2-user/create-cluster-vinput.sh ${TIDB_VERSION} ${REGION_NAME} solution-topology-ten-nodes.yaml

  - name: "prepare steps"
    type: "ShellScript"
    target:
      - monitor1
    script: ./scripts/prepare-steps.sh

features:
  enable_content_explain: false