Help Center/ Distributed Database Middleware/ User Guide/ Data Migration/ Overview
Updated on 2024-04-01 GMT+08:00
View PDF
Share

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, submit a service ticket in the upper right corner on the console or contact DDM customer service and 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 Methods

DDM supports the following migration methods:

  • Using official MySQL clients. The following passages will use an RDS for MySQL instance as an example to describe this method.
  • Using DRS

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 on Huawei Cloud to DDM
  4. Scenario 4: Exporting Data from a DDM Instance
  5. Scenario 5: Migrating Data from Heterogeneous Databases to DDM
  6. Scenario 6: Migrating Data from Huawei Cloud RDS for MySQL to DDM
Parent topic: Data Migration