title | summary | aliases | |
---|---|---|---|
TiDB Tools Use Cases |
Learn the common use cases of TiDB tools and how to choose the tools. |
|
This document introduces the common use cases of TiDB tools and how to choose the right tool for your scenario.
If you need to deploy and operate TiDB on physical or virtual machines, you can install TiUP, and then use TiUP to manage TiDB components such as TiDB, PD, and TiKV.
If you need to deploy and operate TiDB on Kubernetes, you can deploy a Kubernetes cluster, and then deploy TiDB Operator. After that, you can use TiDB Operator to deploy and operate a TiDB cluster.
If you need to import the compatible CSV files exported by other tools to TiDB, use TiDB Lightning.
If you need to import full data from MySQL/Aurora, use Dumpling first to export data as SQL dump files, and then use TiDB Lightning to import data into the TiDB cluster.
If you need to migrate both full data and incremental data from MySQL/Aurora, use TiDB Data Migration (DM) to perform the Migrate Data from Amazon Aurora to TiDB.
If the full data volume is large (at the TB level), you can first use Dumpling and TiDB Lightning to perform the full data migration, and then use DM to perform the incremental data migration.
If you need to back up a TiDB cluster or restore backed up data to the cluster, use BR (Backup & Restore).
In addition, BR can also be used to perform incremental backup and incremental restore of TiDB cluster data.
If you need to migrate data from a TiDB cluster to another TiDB cluster, use Dumpling to export full data from TiDB as SQL dump files, and then use TiDB Lightning to import data to another TiDB cluster.
If you also need to migrate incremental data, you can use TiCDC.
If you need to subscribe to TiDB's incremental changes, you can use TiCDC.