PolarDB:Automatic data backup feature

Precautions

• You cannot perform operations such as scaling and configuration changes during the backup process to prevent backup failures.

• You cannot execute DDL statements during the backup process to avoid backup failures caused by locked tables.

Procedure

1. Log on to the PolarDB for Xscale console.

2. In the top navigation bar, select the region where the target instance is located.

3. On the Instances page, click the PolarDB-X 2.0 tab.

4. Find the target instance and click its ID.

5. In the left-side navigation pane, choose Data Recovery > Backup and Restoration.

6. Click Backup policy.

7. On the Data Backup settings tab, configure the following parameters.

   Parameter	Description
   Enable backup	The automatic data backup feature is enabled by default and cannot be disabled.
   Backup Set Retention Time	The retention period for automatic backup. Valid values: 7 to 730. Unit: days.
   Backup start period	The start time for automatic backup. You can select a time range from the drop-down list. We recommend that you select a time period that is within off-peak hours.
   Backup cycle	The automatic backup cycle. The minimum value is once a week.
   Log Backup Retention Time	The retention period of log backup files. Valid values: 7 to 730.

8. Click OK.

   Note

   • The minimum automatic backup frequency is once a week.

   • To ensure point-in-time restoration, the log backup retention period must be greater than or equal to the data backup retention period.

   • PolarDB-X deletes backup files when their specified retention period expires.

   • Automatic backup files are stored only in the same region. For more information about how to dump automatic backup files to a different region, see Cross-region backups.