nav-img
Advanced

Overview

Data migration is a process of migrating data from databases to DDM or exporting data from DDM to other database systems. You can use the MySQL tool mysqldump to export data. If both full and incremental migrations are required, use Data Replication Service (DRS).

Precautions

  • Services may be interrupted during migration. The duration of the interruption depends on the amount of data to be migrated and on network conditions.
  • Data migration is complicated and is recommended during off-peak hours. This guide is for reference only. Design a proper migration solution based on your service scenario, data volume, and downtime requirements.
  • To migrate a large amount of data or a large data table, perform a rehearsal before formal migration.
  • DDM can be accessed only using an ECS. So you need to export databases as files, upload the files to the ECS, and import the file data from the ECS to DDM.

Migration Scenarios

Data migration is involved in the following scenarios:

  1. Scenario 1: Migrating Data from an On-Premises MySQL Instance to DDM
  2. Scenario 2: Migrating Data from a Third-Party Cloud MySQL Instance to DDM
  3. Scenario 3: Migrating Data from an ECS-hosted MySQL Instance to DDM
  4. Scenario 4: Exporting Data from a DDM Instance