This topic describes how to back up an ApsaraDB RDS for PPAS instance. You can specify a data and log backup cycle based on which the system automatically backs up data and logs. You can also manually back up an RDS instance.

Precautions

  • Backup files occupy backup storage. Each RDS instance is allocated with a free quota for backup storage. If your backup storage usage exceeds the free quota, you must pay for the extra backup space that you use. We recommend that you specify a backup cycle based on your business requirements to maximize the usage of the free backup storage. For more information about the free quota for backup storage, see View the quota of free backup space for an RDS PPAS instance.
  • For more information about the billing methods and billing items, see Pricing, billing items, and billing methods.
  • For more information about the billing standard for backup storage usage, see Pricing.
  • Do not execute data definition language (DDL) statements during a backup. These statements trigger locks on tables, and the backup may fail as a result of the locks.
  • We recommend that you back up your RDS instance during off-peak hours.
  • If the data volume is large, backing up your RDS instance may require a long time.
  • Backups are retained based on the specified retention period. We recommend that you download the backups you require to your computer before they are deleted.

Backup types

Data backup Log backup
You can back up the data of your RDS instance. Only physical backups are supported. The data backup files can be used to restore your RDS instance. Your RDS instance automatically perform physical backup by default.
Note You can use commands to perform logical backup and restoration. For more information, see Create a logical backup and restore data from a logical backup.
You can back up the binary logs of your RDS instance. The binary log files can be used to restore your RDS instance to a point in time.

Configure a backup policy for automated backup

ApsaraDB for RDS automatically backs up your RDS instance based on the specified backup policy.

  1. Log on to the ApsaraDB for RDS console.
  2. In the top navigation bar, select the region where the target RDS instance resides.Select a region
  3. Find the target RDS instance and click its ID. The Basic Information page appears.
  4. In the left-side navigation pane, click Backup and Restoration.
  5. On the Backup and Restoration page, click the Backup Settings tab and then the Edit button.
  6. In the Backup Settings dialog box, configure the following parameters and click OK. The following table describes the parameters.
    Parameter Description
    Data Retention Period You can specify the number of days for which you want to retain data backup files. Valid values: 7 to 730. Unit: days. Default value: 7.
    Backup Cycle The cycle to create backups. You can select one or more days of a week.
    Note To ensure data security, we recommend that you back up your RDS instance at least twice a week.
    Backup Time The hour at which you want to create a backup.
    Log backup The switch to enable or disable the log backup function.
    Notice If you disable this function, all binary log files are deleted, and you cannot restore the RDS instance to a point in time.
    Log Retention Period
    • The number of days for which you want to retain binary log files. Valid values: 7 to 730. Unit: days. Default value: 7.
    • The log retention period must be shorter than or equal to the data retention period.
    Backup settings

Back up data manually

  1. Log on to the ApsaraDB for RDS console.
  2. In the top navigation bar, select the region where the target RDS instance resides.Select a region
  3. Find the target RDS instance and click its ID. The Basic Information page appears.
  4. In the upper-right corner of the page, click Back Up Instance.
  5. Select a backup mode and click Confirm.
  6. In the upper-right corner of the page, click the Task Progress button to view the progress of the backup task.View task progress
    Note You cannot download backup files to your computer.

FAQ

  1. Can I disable the data backup function of my RDS instance?

    No, you cannot disable the data backup function of your RDS instance. However, you can reduce the backup frequency to as low as twice a week. The data retention period must be within the range from 7 days to 730 days.

  2. Can I disable the log backup function of my RDS instance?

    Yes, you can disable the data backup function of your RDS instance. You can log on to the ApsaraDB for RDS console and navigate to the Backup Settings tab to disable the log backup function of your RDS instance.

Related operations

Operation Description
Create backup set Creates a backup for an ApsaraDB for RDS instance.
Query backup sets Queries the backup sets created for an ApsaraDB for RDS instance.
Query backup settings Queries the backup settings of an ApsaraDB for RDS instance.
Modify backup settings Modifies the backup settings of an ApsaraDB for RDS instance.
Delete backup sets Deletes one or more data backup files from an ApsaraDB for RDS instance.
Query backup tasks Queries the backup tasks created for an ApsaraDB for RDS instance.
Query binary logs Queries the binary log files of an ApsaraDB for RDS instance.