lab_code: demo_006
title_en: "TiDB Admin Lab 5: Using Resource Control with Mixed Workloads"
title_zh: "管理 TiDB 实验 5: 使用资源控制功能管理数据库混合工作负载"
title_ja: "管理 TiDB 演習 5: リソース制御を使用して混合ワークロードを管理"
title_ko: "TiDB 관리 실습 5: 혼합 워크로드에 리소스 제어 사용"
description_en:
  This hands-on lab demonstrates how to use TiDB's resource control
  feature to manage mixed workloads in a database. TiDB's resource control feature
  allows you to set resource limits for different workloads, ensuring that one workload
  doesn't consume all the resources and impact other workloads. This feature is especially
  useful in a multi-tenant environment where different workloads have different resource
  requirements.
description_zh: 本实验演示了如何使用 TiDB 的资源控制功能来管理数据库中的混合工作负载。TiDB 的资源控制功能允许您为不同的工作负载设置资源限制，确保一个工作负载不会消耗所有资源并影响其他工作负载。此功能在多租户环境中特别有用，因为不同的工作负载具有不同的资源需求。
description_ja:
  このハンズオン演習では、データベース内の混合ワークロードを管理するために TiDB のリソース制御機能を使用する方法を示します。TiDB
  のリソース制御機能を使用すると、異なるワークロードに対してリソース制限を設定でき、1 つのワークロードがすべてのリソースを消費して他のワークロードに影響を与えることがありません。この機能は、異なるワークロードに異なるリソース要件があるマルチテナント環境で特に有用です。
description_ko:
  이 실습에서는 데이터베이스의 혼합 워크로드를 관리하기 위해 TiDB의 리소스 제어 기능을 사용하는 방법을 보여줍니다.
  TiDB의 리소스 제어 기능을 사용하면 다양한 워크로드에 대해 리소스 제한을 설정할 수 있어, 하나의 워크로드가 모든 리소스를 소비하여 다른 워크로드에
  영향을 주는 것을 방지할 수 있습니다. 이 기능은 서로 다른 워크로드가 서로 다른 리소스 요구사항을 가진 멀티테넌트 환경에서 특히 유용합니다.
splash_image_en: https://lab-static.pingcap.com/quick-demo/dba_303_ch05_en.png
splash_image_zh: https://lab-static.pingcap.com/quick-demo/dba_303_ch05_en.png
splash_image_ja: https://lab-static.pingcap.com/quick-demo/dba_303_ch05_en.png
splash_image_ko: https://lab-static.pingcap.com/quick-demo/dba_303_ch05_en.png
external_materials_en:
  - name: "Resource Control Deck Template"
    url: https://docs.google.com/presentation/d/1Uc10LAKCAIUo7HnyA3bCLo4TQXUaRKBX/edit?slide=id.p1#slide=id.p1
    employee_only: true
  - name: "Resource Control Deck from PM (Internal)"
    url: https://docs.google.com/presentation/d/1Vw8L_z7iylIFOcTwonfXm2_8Pgf9rH3u/edit?slide=id.p1#slide=id.p1
    employee_only: true
external_materials_ja:
  - name: "リソース制御デッキテンプレート"
    url: https://docs.google.com/presentation/d/1Uc10LAKCAIUo7HnyA3bCLo4TQXUaRKBX/edit?slide=id.p1#slide=id.p1
    employee_only: true
  - name: "リソース制御デッキ（PM提供・内部用）"
    url: https://docs.google.com/presentation/d/1Vw8L_z7iylIFOcTwonfXm2_8Pgf9rH3u/edit?slide=id.p1#slide=id.p1
    employee_only: true
external_materials_zh:
  - name: "资源控制演示文稿模板"
    url: https://docs.google.com/presentation/d/1Uc10LAKCAIUo7HnyA3bCLo4TQXUaRKBX/edit?slide=id.p1#slide=id.p1
    employee_only: true
  - name: "资源控制演示文稿（PM 内部版）"
    url: https://docs.google.com/presentation/d/1Vw8L_z7iylIFOcTwonfXm2_8Pgf9rH3u/edit?slide=id.p1#slide=id.p1
    employee_only: true
external_materials_ko:
  - name: "리소스 제어 자료 템플릿"
    url: https://docs.google.com/presentation/d/1Uc10LAKCAIUo7HnyA3bCLo4TQXUaRKBX/edit?slide=id.p1#slide=id.p1
    employee_only: true
  - name: "리소스 제어 데크 (PM 제공・내부용)"
    url: https://docs.google.com/presentation/d/1Vw8L_z7iylIFOcTwonfXm2_8Pgf9rH3u/edit?slide=id.p1#slide=id.p1
    employee_only: true
lab_level: Intermediate
category_en:
  - Resource Control
  - Multi-Tenant
category_zh:
  - 资源控制
  - 多租户
category_ja:
  - リソース制御
  - マルチテナント
category_ko:
  - 리소스 제어
  - 멀티테넌트
authors:
  - Tony Huang (CEG)
  - Fei Dong (CEG)
delivery_type: Self-Paced
tidb_environments:
  - TiDB Self-Managed
tidb_versions:
  - "7.5.4"
  - "8.1.1"
  - "8.5.1"
target_audience:
  - Architect
  - DBA
  - DevOps
regions:
  aws:
    - oregon
    - tokyo
    - singapore
    - frankfurt
credits: 1
credit_redeemable: true
employee_only: false
estimated_duration_minutes: 90

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

requirements:
  - type: CloudStack

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

features:
  enable_content_explain: false