Can DRS Migrate Data to Primary/Standby RDS DB Instances?
Yes. With the high availability mechanism, DRS can migrate data to single or primary/standby RDS DB instances. For migration of primary/standby RDS DB instances, DRS automatically rebuilds the databases connection after a short interruption. In addition, DRS provides a resumable data transfer feature to ensure the continuity and consistency of data synchronization based on the point where the transfer is interrupted.
If the high availability (HA) design of the source database suits the requirements of floating IP address connections and RPO is 0 during a switchover, DRS supports migration of primary/standby DB instances without manual intervention.
- The floating IP address is used and RPO may be 0 during a switchover. In this situation, the database can be connected, but DRS will identify data interruption (if data loss occurs during the switchover) and display a message indicating that the task fails. You can only reset the migration task.
- A fixed IP address is used and RPO is 0 during the switchover. In this situation, the migration is supported only when the instance is running properly.
- The floating IP address is used and zero RPO cannot be ensured during a switchover. In this situation, the database can be connected, but DRS will identify data interruption (if data loss occurs during the switchover) and display a message indicating that the task fails. You can only reset the migration task.
If the destination database is primary/standby DB instances, DRS can ensure that the source data is completely migrated to the destination database. However, the switchover of the destination database cannot ensure zero RPO. As a result, data in the destination database may be interrupted.
Did this article solve your problem?
Thank you for your score！Your feedback would help us improve the website.