This topic describes how to migrate the data of an ApsaraDB RDS for MySQL instance to an ApsaraDB RDS for PostgreSQL instance and use the ApsaraDB RDS for PostgreSQL instance as the real-time data analytics instance of the ApsaraDB RDS for MySQL instance.
Background information
If you want to analyze the data of an ApsaraDB RDS for MySQL instance by using the features of ApsaraDB RDS for PostgreSQL or if you want to process spatio-temporal data or analyze user profile data by using GIS, you can use Data Transmission Service (DTS) to migrate the data of the ApsaraDB RDS for MySQL instance to an ApsaraDB RDS for PostgreSQL instance. Then, you can use the ApsaraDB RDS for PostgreSQL instance as the real-time data analytics instance of the ApsaraDB RDS for MySQL instance.
Prerequisites
- An ApsaraDB RDS for MySQL instance is created. This instance is known as the source instance. For more information, see Create an ApsaraDB RDS for MySQL instance.
- An ApsaraDB RDS for PostgreSQL instance is created. This instance is known as the destination instance. For more information, see Create an ApsaraDB RDS for PostgreSQL instance.
- The available storage of the destination instance must be greater than the storage that is occupied by the source instance.
Procedure
Prepare test data on the source instance
Create a migration task
Migrate the data of the source instance to the destination instance
- View the progress of the full data migration operation.
- Test whether the data that is inserted into the source database is continuously migrated
to the destination database.
- Test whether the data that is updated in the source database is continuously migrated
to the destination database.
- Test whether the data that is deleted from the source instance is continuously deleted
from the destination database.