Introduction

In this course, you can learn and master TiDB architecture, design practices, performance monitoring, parameter optimization, troubleshooting, SQL optimization, and high-availability design.

This course is available through Private Training. To purchase Private Training, contact sales to build out a custom training plan.

Contact Sales

Summary

  • Audience: Database administrators
  • Level: Advanced
  • Duration: 5 days
  • Prerequisites: TiDB system management basics, or equivalent work experience
  • TiDB Version: v5.x

Course Outline

  • TiDB Cluster Introduction
  • TiDB Server Introduction
  • TiKV Introduction
  • Placement Driver Introduction
  • SQL Execution Process
  • TiDB Server Performance Related Parameters
  • PD Performance Related Parameters
  • TiKV Performance Related Parameters
  • Common Monitoring Metrics for TiDB Clusters
  • Distributed Transactions Fundamentals
  • Percolator Transaction Model
  • TiDB Transactions
  • TiDB Database Table Schema Design
  • TiDB Database Indexes
  • TiDB Database System Tables
  • Introduction to TiDB Optimizer
  • Understand Execution Plan
  • Statistics Management
  • Index-Based Optimization
  • TiDB SQL Tuning
  • Problem SQL vs Slow SQL
  • Optimizing DML Statements
  • Tune SQL Statements Based on Execution Plans
  • Diagnose Database Hotspots
  • Fast Recover from Data Loss
  • TiDB OOM Diagnosis
  • TiKV OOM Diagnosis
  • Common Troubleshooting Approaches for PD Scheduling
  • Common Troubleshooting Approaches for Slow Writes
  • Common Troubleshooting Approaches for Slow Reads
  • TiDB Database High Availability Overview
  • Common HA Patterns for TiDB Database
  • TiFlash
  • TiDB HTAP Overview

Build out a custom training plan?  Contact Sales

Module 1: Deep Dive into TiDB Architecture

  • TiDB Cluster Introduction
  • TiDB Server Introduction
  • TiKV Introduction
  • Placement Driver Introduction
  • SQL Execution Process
TiDB Cloud logo-white

TiDB Cloud

Get the massive scale and resiliency of TiDB databases in a fully managed cloud service

TiDB logo-white

TiDB

TiDB is effortlessly scalable, open, and trusted to meet the real-time needs of the digital enterprise