Help Center> Distributed Database Middleware> User Guide> Backups and Restorations> Restoring Data to a New Instance
Updated on 2024-04-01 GMT+08:00
View PDF

Restoring Data to a New Instance

DDM allows you to restore data from the current instance to any point in time using an existing backup. This is a good choice for routine service backup and restoration.

This section uses an RDS for MySQL instance as an example to describe how to restore data to a new DDM instance.

Precautions

  • Restoring data to a new instance restores your DDM instance and its data nodes (RDS for MySQL instances). Before the restoration, you need to prepare a new DDM instance and as many new RDS for MySQL instances as there are data nodes.
  • Restoring data to a new DDM instance will overwrite data on it and cause the instance to be unavailable during restoration.
  • The new RDS for MySQL instances must have the same or later versions and as much as or more storage space than the original ones.
  • Data cannot be restored to an RDS for MySQL instance that uses local SSDs.
  • Restoration is not supported if the destination DDM instance is in the primary network and its associated RDS for MySQL instance is in the extended network.
  • The source DDM instance must be of the version 2.3.2.11 or later, and the destination DDM instance must be of the version 3.0.8 or later.
  • Time points that data can be restored to depend on the backup policy set on original data nodes.

Procedure

  1. Log in to the DDM console.
  2. Create a DDM instance or select an existing DDM instance that meets the requirements in the region where the source DDM instance is located.

    Ensure that the new DDM instance or the selected existing DDM instance is not associated with any RDS for MySQL instance and has no schemas or accounts.

  3. On the RDS console, create as many RDS for MySQL instances as there are in the source DDM instance.

    • Ensure that the new RDS instances have the same or later versions than RDS instances associated with the source DDM instance.
    • Ensure that each new RDS for MySQL instance has the same or larger storage space than each source RDS instance.

  4. Switch back to the DDM console, in the instance list, locate the DDM instance whose data you want to restore, and click its name.

    Figure 1 DDM instance list

  5. In the navigation pane on the left, choose Backups & Restorations.
  6. Click Restore to New Instance.

    Figure 2 Basic Information page

  7. On the displayed Restore to New Instance page, specify a time range and a time point, and select destination DDM instance and associated data nodes.

    Figure 3 Configuring required parameters
    Table 1 Parameter description

    Parameter

    Description

    Time Range

    Select a time range.

    Time Point

    Select a time point

    DDM checks whether the associated data nodes have available backups at the selected time point.

    Destination DDM instance

    Select the DDM instance created in 2 as the destination instance.

    Associated Data Nodes

    Select the RDS for MySQL instances created in 3 as the destination data nodes.

  8. Confirm the information and click OK. Wait for 1 to 3 minutes for the data restoration to complete.
Parent topic: Backups and Restorations