Cloud Migration without Stopping Services: Alibaba Cloud DTS

Migration after Stopping Services — Traditional Database Migration Solution

Migration without Stopping Services — Alibaba Cloud DTS

  1. Migrate a self-built database from an offline IDC room to the self-built database on Alibaba Cloud RDS or ECS.
  2. Migrate a self-built database from other cloud vendors to the self-built database on Alibaba Cloud RDS or ECS.
  3. Migrate a database on Alibaba Cloud across regions and accounts.
  4. Migrate a self-built database on Alibaba Cloud RDS or ECS to the offline IDC test environment.

DTS Migration Process

  1. Preparation, including that of the target database, the source database, and the migration account of the target database.
  2. Schema migration: DTS migrates the schema objects of the source database to the target database.
  3. Full migration. DTS migrates historical data from the source database to the target database.
  4. Incremental migration. DTS migrates incremental data from the source database to the target database. Incremental migration is divided into two steps: incremental data fetching and incremental data synchronization. To ensure the integrity of the migrated data, DTS starts incremental data fetching at the same time as the schema migration, and captures the incremental data generated by the source instance during the process of schema migration and full migration in real time.
  5. Data verification. Users verify the consistency of the migrated data between the source database and the target database.
  6. Business switching. Selects the low peak period for the business, and points the business to the target database when DTS incremental migration will have no delay.

Basic Principles of DTS Migration

1. Schema Migration

2. Full Migration

3. Incremental Migration

Migration Process — 3 Steps to Complete Database Migration

Preparations

Performing Migration

  1. Name of the task: By default, DTS generates a name for every task automatically. The task name does not need to be unique, and can be modified. A name indicating the specific business of the task is recommended to facilitate task identification.
  1. Instance type: Select a self-built instance with a public network IP.
  2. Database type: Select MySQL.
  3. Host name or IP address: Configure the external network address for RDS MySQL that is on the other cloud vendor.
  4. Port: Configure instance listening ports for RDS MySQL that is on the other cloud vendor.
  5. Account: Configure the instance access account for MySQL that is on the other cloud vendor.
  6. Password: Configure the password corresponding to the access account for MySQL that is on the other cloud vendor.
  1. Instance type: Select a RDS instance
  2. RDS instance ID: Instance ID of the target RDS instance to which you want to migrate data. DTS supports RDS for MySQL instances using classic networks and VPC networks
  3. Database account: the connection account for the RDS for MySQL instance
  4. Database password: the database password corresponding to the database account specified above
  1. Migration type
  2. DTS supports schema migration, full migration, and incremental migration. To migrate without stopping services, select: Schema Migration + Full Migration + Incremental Migration.
  3. Migration object
  4. Select the object to be migrated. The migration object can be a database, a table, or a column. After the migration object and migration type are configured, the pre-check for the migration task is started.

Conclusion

--

--

--

Follow me to keep abreast with the latest technology news, industry insights, and developer trends. Alibaba Cloud website:https://www.alibabacloud.com

Love podcasts or audiobooks? Learn on the go with our new app.

Recommended from Medium

Powerup collector

A mindset journey from Engineer to Product Owner

CI/CD pipeline for OrangeHRM open source application

Katalon Studio: What You Need To Know About Tests Explorer

Bridging the Gap Between Python and Scala Jupyter Notebooks

Building Real-time Applications

HOW TO CREATE YOUR FIRST MAVEN PROJECT

A Tale of Software Engineering Teams

Get the Medium app

A button that says 'Download on the App Store', and if clicked it will lead you to the iOS App store
A button that says 'Get it on, Google Play', and if clicked it will lead you to the Google Play store
Alibaba Cloud

Alibaba Cloud

Follow me to keep abreast with the latest technology news, industry insights, and developer trends. Alibaba Cloud website:https://www.alibabacloud.com

More from Medium

Historize elastic APM server data

Containers 101: Containerization

CMAN-TDM — An Oracle Database connection proxy for scalable and highly available applications

How to Connect Elastic Sink Connector with Kafka