Configuring a Cross-Region Backup Policy

Scenarios

GaussDB(for MySQL) can store backup files in the storage space that is in a different region from your DB instance for disaster recovery. If your DB instance in a region is faulty, you can use the backup files in another region to restore data to a new instance.

After you enable cross-region backup, the backup files are automatically stored in the region you specify. On the Backups page of the GaussDB(for MySQL) console, you can click View Backup in the Operation column and manage cross-region backup files.

Currently, cross-region backup can be enabled for up to 150 DB instances in a single region under a tenant. It is recommended that the data volume of a single DB instance be at most 2 TB. If the data volume is too large, the synchronization progress may be delayed.

To apply for the cross-region backup policy permission, submit a service ticket by choosing Service Tickets > Create Service Ticket in the upper right corner of the management console.

Supported Regions

To view regions where cross-region backup policy can be enabled, see OBS Cross-Region Replication.

Billing

Enabling or Modifying a Cross-Region Backup Policy

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 Databases > 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 Configure Cross-Region Backup Policy. Configure parameters as shown in Figure 1.
   Figure 1 Configuring a cross-region backup policy
   
   • If you enable Cross-Region Full Backup, automated full backup files of the instance are stored in OBS in the region you specify.
   • If you enable Cross-Region Log Backup, incremental backup files of the instance are stored in OBS in the region you specify. Enable cross-region full backup first.
   • Cross-region backup files can be retained from 1 to 1,825 days.
   • After cross-region log backup is enabled, you can restore an instance to a specified time point only after the next automated full backup replication is complete. The specified time point must be later than the time when the automated full backup is complete.

6. Click OK.
7. On the Cross-Region Backups tab of the Backups page, manage cross-region backup files.
   Figure 2 Cross-region backups
   
   • By default, all instances with cross-region backups are displayed.
     • To modify the cross-region backup policy, click Set Cross-Region Backup in the Operation column.
     • To view generated cross-region backup files, click View Cross-Region Backup in the Operation column. If an instance fails, you can use the cross-region backup files to restore data to a new instance.
       Full or incremental backups can be resorted to a new DB instance. Select the backup you want to restore and click Restore in the Operation column.

       Figure 3 Restoring a full backup
       

       Figure 4 Restoring an incremental backup
       

       Incremental backups can be restored to a point of time. You need to select a time range, select or enter a time point within the acceptable range.

       Figure 5 Restoring an incremental backup to a point in time
       
   • To view all cross-region backups, click View All Backups.

     To restore a backup, locate the backup and click Restore in the Operation.

   • To return to the instance list, click View All Instances.

Disabling a Cross-Region Backup Policy

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 Databases > GaussDB(for MySQL).
4. On the Backups page, click the Cross-Region Backups tab.
5. Locate the instance and click Set Cross-Region Backup in the Operation column. On the displayed page, disable the cross-region backup policy. Before disabling Cross-Region Full Backup, you need to disable Cross-Region Log Backup.
   Figure 6 Disabling a cross-region backup policy
   

6. Click OK.