- About DM
- What is DM?
- Basic Features
- Advanced Features
- Merge and Migrate Data from Sharded Tables
- Migrate from MySQL Databases that Use GH-ost/PT-osc
- Filter Certain Row Changes Using SQL Expressions
- DM Architecture
- Benchmarks
- Quick Start
- Deploy
- Maintain
- Tools
- Cluster Upgrade
- Manage Data Source
- Manage a Data Migration Task
- Manually Handle Sharding DDL Lock
- Manage Schemas of Tables to be Migrated
- Handle Alerts
- Daily Check
- Usage Scenarios
- Troubleshoot
- Performance Tuning
- Reference
- Secure
- FAQ
- Glossary
- Release Notes
Data Migration Scenario Overview
Before creating a data migration task, you need to perform the following operations:
This document introduces how to configure a data migration task in different scenarios. You can choose suitable documents to create your data migration task according to the specific scenario.
In addition to scenario-based documents, you can also refer to the following ones:
- For a complete example of data migration task configuration, refer to DM Advanced Task Configuration File.
- For a data migration task configuration guide, refer to Data Migration Task Configuration Guide.
Migrate Data from Multiple Data Sources to TiDB
If you need to migrate data from multiple data sources to TiDB, and to rename tables to avoid migration conflicts caused by duplicate table names in different data sources, or to disable some DDL/DML operations in some tables, refer to Migrate Data from Multiple Data Sources to TiDB.
Migrate Sharded Schemas and Sharded Tables to TiDB
If you need to migrate sharded schemas and sharded tables to TiDB, refer to Data Migration Shard Merge Scenario.
Migrate Incremental Data to TiDB
If you have already migrated full data using other tools like TiDB Lightning and you need to migrate incremental data, refer to Migrate Incremental Data to TiDB.
Migration when the Downstream Table Has More Columns
If you need to customize your table schema in TiDB to include not only all the columns from the source but also additional columns, refer to Migration when the Downstream Table Has More Columns.