Sign InTry Free

TiDB Tools Overview

This document introduces the functionalities of TiDB tools and their relationship.

Deploy and operate TiDB in Kubernetes

TiDB Operator is an automatic operation system for TiDB clusters in Kubernetes. It provides full life-cycle management for TiDB including deployment, upgrades, scaling, backup, fail-over, and configuration changes. With TiDB Operator, TiDB can run seamlessly in the Kubernetes clusters deployed on a public or private cloud.

The following are the basics of TiDB Operator:

Full data export

Dumpling is a tool for the logical full data export from MySQL or TiDB.

The following are the basics of Dumpling:

  • Input: MySQL/TiDB cluster
  • Output: SQL/CSV file
  • Supported TiDB versions: all versions
  • Kubernetes support: No

Full data import

TiDB Lightning (Lightning) is a tool used for the full import of large amounts of data into a TiDB cluster. Currently, TiDB Lightning supports reading SQL dump exported via Dumpling or CSV data source.

TiDB Lightning supports two modes:

  • importer: This mode uses tikv-importer as the backend, which is usually for importing a large amount of data (at the TB level). During the import, the cluster cannot provide services.
  • tidb: This mode uses TiDB/MySQL as the backend, which is slower than the importer mode but can be performed online. It also supports importing data to MySQL.

The following are the basics of TiDB Lightning:

Backup and restore

Dumpling can be used to back up the TiDB cluster to SQL/CSV files. See Full data export.

TiDB Lightning can be used to restore the SQL/CSV files exported by Dumpling to the TiDB cluster. See Full data import.

Incremental data replication

TiDB Binlog is a tool that collects binlog for TiDB clusters and provides near real-time sync and backup. It can be used for incremental data replication between TiDB clusters, such as making a TiDB cluster the secondary cluster of the primary TiDB cluster.

The following are the basics of TiDB Binlog:

Data migration

TiDB Data Migration (DM) is an integrated data replication task management platform that supports the full data migration and the incremental data migration from MySQL/MariaDB to TiDB.

The following are the basics of DM:

  • Input: MySQL/MariaDB
  • Output: TiDB cluster
  • Supported TiDB versions: all versions
  • Kubernetes support: No, under development

If the data volume is below the TB level, it is recommended to migrate data from MySQL/MariaDB to TiDB directly using DM. The migration process includes the full data import and export and the incremental data replication.

If the data volume is at the TB level, take the following steps:

  1. Use Dumpling to export the full data from MySQL/MariaDB.
  2. Use TiDB Lightning to import the data exported in Step 1 to the TiDB cluster.
  3. Use DM to migrate the incremental data from MySQL/MariaDB to TiDB.
Download PDF
One-stop & interactive experience of TiDB's capabilities WITHOUT registration.
TiDB Dedicated
TiDB Serverless
Get Demo
Get Started
© 2024 PingCAP. All Rights Reserved.
Privacy Policy.