After a sandbox instance is created for emergency disaster recovery, you can use Data Transmission Service (DTS) to migrate data from the sandbox instance to an ApsaraDB RDS for MySQL instance.
Background information
Database Backup (DBS) provides a sandbox solution based on copy data management (CDM). You can create independent DBS sandbox instances with ease to make your backup data available in a short period of time. For more information, see Overview.
- Save the data that is written in a sandbox instance. Read and write operations performed within sandbox instances do not affect source databases. To save the data that is written to a sandbox instance, you can migrate the data from the sandbox instance to an ApsaraDB RDS for MySQL instance.
- Accelerate restoration. Compared with the regular restoration methods provided by DBS, the DBS sandbox feature accelerates the restoration of backup sets. You can use the DBS sandbox instance feature to create a sandbox instance for emergency disaster recovery and then migrate the tables or databases in the sandbox instance to an ApsaraDB RDS for MySQL instance.
Prerequisites
- A sandbox instance is created for emergency disaster recovery. For more information, see Create a sandbox instance for the emergency disaster recovery of an ApsaraDB RDS for MySQL database.
- The available storage space of the ApsaraDB RDS for MySQL instance must be larger than the total size of the data to be migrated.
Precautions
- Data migration does not affect the data in the sandbox instance. During data migration, DTS reads the data in the sandbox instance and copies the data to the ApsaraDB RDS for MySQL instance. DTS does not delete the data in the sandbox instance.
- To ensure data consistency, we recommend that you do not write data to the sandbox instance during full data migration.
For more information, see Precautions and limits for migrating data from a MySQL database.
Migration types and billing rules
- Schema migration
DTS can be used to migrate the schemas of objects from an ApsaraDB RDS for MySQL source instance to a destination instance.
- Full data migration
You can migrate the data of all objects from an ApsaraDB RDS for MySQL source instance to a destination instance by using DTS. This is called a full data migration operation.
- Incremental data migration
After all data of an ApsaraDB RDS for MySQL source instance is migrated to a destination instance, you can synchronize the incremental data of the source instance to the destination instance by using DTS. This is called an incremental data migration operation. Incremental data migration ensures service continuity when you migrate data between self-managed databases.
You are not charged for schema migration and full data migration. We recommend that you perform only schema migration and full data migration. You are charged for incremental data migration. For more information, see Billing methods.