Introduction

Designed for developers, DBAs, and architects who will use the TiDB database in their work. The course focuses on the architecture and design principles of the TiDB database, which is the basis for future administer, development, performance tuning and troubleshooting.

Start Free Learning

Summary

  • Audience: Database beginners who plan to become TiDB experts
  • Level: Introductory
  • Duration: 1 day
  • Prerequisites: Basic computer, operating system, network and database knowledge; Ability to read simple SQL statements.
  • TiDB Version: v6.x

Build a training plan for your team? Contact Sales

Course Outline

Chapter 01: TiDB Database Architecture Overview

  • The overall architecture of TiDB database
  • The key features of TiDB Server, TiKV, and PD

Chapter 02: TiDB Server

  • The TiDB Server architecture
  • The functions of TiDB Server
  • The process of TiDB Server
  • The cache of TiDB Server

Chapter 03: TiKV

  • The architecture and features of TiKV
  • The data persistence of TiKV
  • How TiKV provides MVCC and distributed transaction
  • The consistency of TiKV based on raft
  • Coprocessor

Chapter 04: PD(Placement Driver)

  • The architecture and functions of PD
  • The allocation of TSO
  • The scheduling process
  • The labels and high availability

Chapter 05: TiDB Database SQL Execution Process

  • DML process
  • DDL process

Chapter 06: TiDB Database HTAP Overview

  • HTAP technology
  • TiDB HTAP Architecture
  • The core features of HTAP

Chapter 07: TiFlash

  • The architecture and features of TiKV
  • The core functions of TiFlash

Chapter 08: TiDB 6.0 New Features

  • Placement Rules in SQL
  • Cached Tables
  • In-memory pessimistic lock
  • Top SQL
  • TiDB Enterprise Manager(TiEM)

Chapter 09: TiDB Cloud

  • Why TiDB Cloud
  • The architecture of TiDB Cloud
  • The features of TiDB Cloud
  • Quick start TiDB Cloud

Want to build a training plan for your team?  Contact Sales

Module 1: TiDB Database Architecture

Chapter 01: TiDB Database Architecture Overview

  • The overall architecture of TiDB database
  • The key features of TiDB Server, TiKV, and PD

Chapter 02: TiDB Server

  • The TiDB Server architecture
  • The functions of TiDB Server
  • The process of TiDB Server
  • The cache of TiDB Server

Chapter 03: TiKV

  • The architecture and features of TiKV
  • The data persistence of TiKV
  • How TiKV provides MVCC and distributed transaction
  • The consistency of TiKV based on raft
  • Coprocessor

Chapter 04: PD(Placement Driver)

  • The architecture and functions of PD
  • The allocation of TSO
  • The scheduling process
  • The labels and high availability

Chapter 05: TiDB Database SQL Execution Process

  • DML process
  • DDL 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