Configuring a Cross-Region Backup Policy

Scenarios

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

After you enable cross-region backup, the backups are automatically stored in the region you specify.

Precautions

• To apply for the permissions to configure cross-region backup policies, submit an application by choosing Service Tickets > Create Service Ticket in the upper right corner of the management console.
• 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.

Supported Regions

Billing

For details, see GaussDB(for MySQL) Cross-Region Backup Billed Items.

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 project.
3. Click in the upper left corner of the page and choose Databases > GaussDB(for MySQL).
4. On the Instances page, click the instance name.
5. In the navigation pane, choose Backups. On the displayed page, click Configure Cross-Region Backup Policy.
   Figure 1 Configuring a cross-region backup policy
   

6. In the displayed dialog box, set required parameters.
   Figure 2 Configuring a backup policy
   

   Table 2 Parameter description

   Parameter	Description
   Cross-Region Full Backup	If you enable this option, automated full backups of the DB instance are stored in the region you specify.
   Cross-Region Incremental Backup	If you enable this option, incremental backups of the DB instance are stored in the region you specify. To enable cross-region incremental backup, enable cross-region full backup first. After cross-region incremental backup is enabled, you can restore an instance to a specified point in time only after the next automated full backup replication is complete. The specified point in time must be later than the time when the automated full backup is complete.
   Region	Select the region for storing backups.
   Retention Period	Cross-region backup files can be retained from 1 to 1,825 days.

7. Click OK.
8. On the Cross-Region Backups tab of the Backups page, manage cross-region backups.
   Figure 3 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 a DB instance fails, you can use the cross-region backups to restore data to a new DB 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 4 Full backups
     

     Figure 5 Incremental backups
     

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

     Figure 6 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. For details, see Restoring a DB Instance from a Cross-region Backup.

   • To return to the instance list, click View 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 project.
3. Click in the upper left corner of the page and choose Databases > GaussDB(for MySQL).
4. In the upper left corner of the page, select the region where the original DB instance is located.
5. Disable the cross-region backup policy using either of the following methods.

   Method 1:

   1. Choose Backups in the navigation pane and click the Cross-Region Backups tab.
   2. Locate the target DB instance and click Set Cross-Region Backup in the Operation column.
      Figure 7 Setting cross-region backup
      

   3. In the displayed dialog box, click next to Cross-Region Incremental Backup and Cross-Region Full Backup.
      Figure 8 Disabling cross-region backup
      

   4. Click OK.

   Method 2:

   1. On the Instances page, click the instance name.
   2. In the navigation pane, choose Backups.
   3. Click Configure Cross-Region Backup Policy.
   4. In the displayed dialog box, click next to Cross-Region Incremental Backup and Cross-Region Full Backup.
      Figure 9 Disabling cross-region backup
      

   5. Click OK.