- Use TiUP to deploy TiDB cluster
- Start and Stop TiDB cluster
- Describe the stages of TiDB cluster startup
- Describe TiDB cluster configuration and log files
- Create TiDB cluster in the TiDB Cloud
Introduction
This course guides you learn about managing TiDB. Understand TiDB’s data migration, replication and backup recover method, as well as the scenarios and basic usage of the common ecosystem tools.
This course is available through private training. To purchase private training for you or your team, speak to you TiDB representative or contact sales.
Summary
- Audience: Database administrators
- Level: Intermediate
- Duration: 3 days
- Prerequisites: You have completed DBA COURSE 1: TiDB Essentials for DBA, or you should be familiar with distributed database operation and administer or equivalent work experience.
Course Outline
- Understand the TiDB compatibility with MySQL
- Describe how to connect to TiDB server
- Understand TiDB system variables
- Understand the scope of TiDB system variables
- Understand TiDB configuration file parameters
- Describe how to modify TiDB system variables
- Describe how to modify TiDB configuration file parameters
- Understand authentication and authorization
- Understand the levels of access privileges for users
- Manage TiDB user accounts
- Grant and revoke privileges
- Use SQL statements to manage accounts
- Describe the monitoring and alerting framework
- Identify common monitoring metrics
- Monitor TiDB cluster status on Grafana` panels
- Monitor TiDB cluster status on TiDB Dashboard
- Rename a TiDB cluster
- Scale out TiDB cluster components
- Scale in TiDB cluster components
- Tear down a TiDB cluster
- Change the timezone of TiDB
- Describe the TiDB versioning
- Patch the TiDB cluster
- Upgrade the TiDB cluster
- Describe TiDB backup types
- Compare the various backup techniques
- Perform backups on TiDB Cloud cluster
- Describe what TiDB Lightning is
- Explain when and how to use TiDB Lightning
- Using TiDB Lightning to import data
- Explain when and how to use Dumpling
- Use Dumpling to perform logical backups
- Describe what BR is
- Explain when and how to use BR
- Using BR to backup and restore TiDB cluster data
- Describe the key features of sync-diff-inspector
- Explain when and how to use sync-diff-inspector
- Using sync-diff-inspector to compare schema and data
- Describe the key features of TiDB Data Migration
- Explain when and how to use TiDB Data Migration
- Replicate data from MySQL-compatible upstream by using TiDB Data Migration cluster
- Describe the key features of TiCDC cluster
- Explain when and how to use TiCDC cluster
- Using TiCDC cluster to fan out database change events to downstreams
Purchase private training for you or your team? Contact Sales
Module 1: TiDB Cluster Deployment
- Use TiUP to deploy TiDB cluster
- Start and Stop TiDB cluster
- Describe the stages of TiDB cluster startup
- Describe TiDB cluster configuration and log files
- Create TiDB cluster in the TiDB Cloud
Module 2: Connecting to TiDB
- Understand the TiDB compatibility with MySQL
- Describe how to connect to TiDB server
Module 3: Configuring TiDB
- Understand TiDB system variables
- Understand the scope of TiDB system variables
- Understand TiDB configuration file parameters
- Describe how to modify TiDB system variables
- Describe how to modify TiDB configuration file parameters
Module 4: Security and User Management
- Understand authentication and authorization
- Understand the levels of access privileges for users
- Manage TiDB user accounts
- Grant and revoke privileges
- Use SQL statements to manage accounts
Module 5: TiDB Monitoring Tools
- Describe the monitoring and alerting framework
- Identify common monitoring metrics
- Monitor TiDB cluster status on Grafana` panels
- Monitor TiDB cluster status on TiDB Dashboard
Module 6: TiDB Cluster Operational Tasks
- Rename a TiDB cluster
- Scale out TiDB cluster components
- Scale in TiDB cluster components
- Tear down a TiDB cluster
- Change the timezone of TiDB
Module 7: Upgrading TiDB Cluster (On-premises)
- Describe the TiDB versioning
- Patch the TiDB cluster
- Upgrade the TiDB cluster
Module 8: Backup Terminology and Strategies
- Describe TiDB backup types
- Compare the various backup techniques
- Perform backups on TiDB Cloud cluster
Module 9: Importing Data using TiDB Lightning
- Describe what TiDB Lightning is
- Explain when and how to use TiDB Lightning
- Using TiDB Lightning to import data
Module 10: Exporting Data using Dumpling
- Explain when and how to use Dumpling
- Use Dumpling to perform logical backups
Module 11: Using BR for Backup and Restore
- Describe what BR is
- Explain when and how to use BR
- Using BR to backup and restore TiDB cluster data
Module 12: Using sync-diff-inspector to Validate Data
- Describe the key features of sync-diff-inspector
- Explain when and how to use sync-diff-inspector
- Using sync-diff-inspector to compare schema and data
Module 13: Migrating Data from MySQL-compatible Databases with TiDB Data Migration (DM)
- Describe the key features of TiDB Data Migration
- Explain when and how to use TiDB Data Migration
- Replicate data from MySQL-compatible upstream by using TiDB Data Migration cluster
Module 14: Replicating TiDB Change Events Using TiCDC
- Describe the key features of TiCDC cluster
- Explain when and how to use TiCDC cluster
- Using TiCDC cluster to fan out database change events to downstreams
TiDB
The most advanced, open source, distributed SQL database
TiDB Cloud
A fully-managed DBaaS with zero operational overhead