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

Restoring Data to a New Instance

Overview

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.

Figure 1 Restore to New Instance

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

Restrictions

  • Restoring data to a new DDM instance will overwrite data on it and cause the instance to be unavailable during restoration.
  • Ensure that no schemas are created or deleted between the restoration time and the current time.
  • The new RDS for MySQL DB instances must have the same or later versions than the original ones, and their storage space must be greater than or equal to that of the original ones.
  • Data cannot be restored to a local RDS for MySQL instance.
  • Data cannot be restored to an RDS for MySQL instance that uses SSDs for storage.
  • Restoration is not supported if the DDM instance is in the primary network and the destination RDS for MySQL instance is in the extended network.

Prerequisites

  • You have logged in to the DDM console.
  • The current (source) DDM instance is in the Running state.

Procedure

  1. 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.

  2. 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 instances.

  3. In the DDM instance list, click the name of the instance created in 1.
  4. In the navigation pane on the left, choose Backups & Restorations. Click Restore to New Instance.
  5. On the displayed Restore to New Instance page, specify a time range and a point in time and select the DDM instance created in 1 as the destination DDM instance.
  6. Select the RDS for MySQL instances created in 2 as destination DB instances and check the confirmation box. Click OK. Wait for 1 to 3 minutes for the data restoration to complete.
Parent topic: Backups and Restorations