This topic describes how to migrate an ApsaraDB RDS for SQL Server instance across zones in the same region. After the migration is complete, the attributes, configuration, and endpoints of the RDS instance remain unchanged. The time that is required to complete the migration is based on the amount of data to be migrated. The migration can take a few hours.

Prerequisites

  • Your RDS instance runs SQL Server 2008 R2 with local SSDs.
  • The region where your RDS instance resides consists of multiple zones. For more information about regions and zones, see Regions and zones.

Billing

The migration is provided free of charge. This applies even if you migrate your RDS instance from one zone to multiple zones.

Precautions

  • During the migration, a transient connection error of about 30 seconds occurs. Make sure that your application is configured to automatically reconnect to your RDS instance.
  • After the migration, your RDS instance switches to a new VPC and a new vSwitch. In this case, the virtual IP addresses (VIPs) of your RDS instance change. Therefore, we recommend that you connect your application to your RDS instance by using an internal or public endpoint. Do not establish a connection by using an IP address.
  • The VIP changes temporarily interrupt the availability of DRDS . After the migration is completed, you must immediately update and view endpoints in the DRDS console.
  • If your RDS instance has an ongoing Data Transmission Service (DTS) task, you must restart the task after the migration is completed.

Migration scenarios

Migration scenario Description
Migration from one zone to another zone The original zone where your RDS instance resides cannot ensure service performance due to issues such as heavy loads.
Migration from one zone to multiple zones You want to implement disaster recovery across data centers for your RDS instance. After the migration is completed, your RDS instance and its secondary instance reside in different zones.

Multi-zone deployment delivers higher disaster recovery capabilities than single-zone deployment. If your RDS instance is deployed in a single zone, it can withstand server and rack failures. However, if your RDS instance is deployed in multiple zones, it can withstand data center failures.

Migration from multiple zones to one zone You want your RDS instance to provide specific features that are supported only for single-zone deployment.

Procedure

  1. Go to the Basic Information page.
    1. Log on to the ApsaraDB for RDS console. In the left-side navigation pane, click Instances. In the top navigation bar, select the region where your RDS instance resides.
      选择地域
    2. Find your RDS instance and click its ID. In the left-side navigation pane, click Basic Information.
  2. In the upper-right corner of the Basic Information section, click Migrate Across Zones.
  3. In the dialog box that appears, specify the destination zone, vSwitch, and switching time. Then, click OK.

    After you click OK, ApsaraDB RDS starts to copy the data of your RDS instance to the destination zone. This does not interrupt the running of your RDS instance. After all the data is copied to the destination zone, your workloads are switched over to the destination zone at the specified switching time (Switch Now or Switch Within Maintenance Window).

    Note
    • During the switchover, a transient connection error of about 30 seconds occurs. Make sure that your application is configured to automatically reconnect to your RDS instance. Otherwise, you must manually reconnect your application to your RDS instance.
    • If the DNS records cached on the client are not immediately updated after the migration is complete, some of your workloads may be switched over to the destination zone 10 minutes later. This causes another transient connection error.

Related operations

Operation Description
Migration zone Migrates an ApsaraDB RDS instance across zones in the same region.