Help Center> GaussDB(for MySQL)> User Guide> Data Restorations> Restoring Instance Data to a Specific Point in Time
Updated on 2023-10-18 GMT+08:00

Restoring Instance Data to a Specific Point in Time

Scenarios

You can restore data of an instance to a specified point in time.

Procedure

  1. Log in to the management console.
  2. Click in the upper left corner and select a region and a project.
  3. Click in the upper left corner of the page, choose Database > GaussDB(for MySQL).
  4. On the Instances page, click the instance name to go to the Basic Information page.
  5. In the navigation pane on the left, choose Backups. On the displayed page, click Restore to Point in Time.
  6. Select a time range, select or enter a time point within the acceptable range, and set Restoration Method to Create New Instance or Restore to Original.

    1. Create New Instance: Click OK. On the Create New Instance page, configure parameters and click Next.
      • The region, DB engine and version of the new instance are the same as those of the original instance and cannot be changed.
      • The default database port is 3306.
      • Retain the default values for other parameters. You can also set the parameters as required.
    2. Restore to Original: Click Next. In the displayed dialog box, click OK.

      Data on the original instance will be overwritten and the original DB instance will be unavailable during the restoration.

  7. View the restoration results.

    • Create New Instance: After the creation is complete, the instance status changes from Creating to Available. The new instance is independent from the original one and includes the data before the backup was created. If you want to offload read pressure from the primary node, create one or more read replicas for the new instance.

      A full backup is triggered after the new instance is created.

    • Restore to Original: When the instance status changes from Restoring to Available, the restoration is complete.