Help Center/ Distributed Database Middleware/ Best Practices/ Migrating Data from RDS for MySQL to DDM Using DRS/ Overview
Updated on 2022-08-09 GMT+08:00
View PDF
Share

Overview

Scenarios

This practice describes how to migrate data from RDS for MySQL to DDM in a different region using Data Replication Service (DRS), including how to create an RDS for MySQL instance and a DDM instance on Huawei Cloud, and how to migrate data over the VPN network.

Prerequisites

  • You have a Huawei Cloud account.
  • Your account balance is not below zero.

Service List

  • Virtual Private Cloud (VPC)
  • Virtual Private Network (VPN)
  • RDS
  • Distributed Database Middleware (DDM)
  • Data Replication Service (DRS)
  • Data Admin Service (DAS)

Deployment Architecture

In this example, the source is a Huawei Cloud RDS for MySQL instance and the destination is a DDM instance in a different region. Data is migrated from the source to the destination over a VPN. Figure 1 shows the overall deployment architecture.

Figure 1 VPN-based deployment architecture

Constraints

  • Before data migration, you need to stop your workloads to ensure data integrity.
  • The new RDS for MySQL instance must be of the same version as the source RDS for MySQL instance.

Notes on Usage

  • The resource planning is for demonstration only. Adjust it as needed.
  • The end-to-end test data is for reference only.