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-X console.

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

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

4. Find the instance that you want to manage and click its ID.

5. In the left-side navigation pane, choose Data Restoration > 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 Time Range	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.