ApsaraDB RDS for MySQL provides the high-frequency snapshot backup feature. You can specify a backup frequency that ranges from 15 minutes to 12 hours for your ApsaraDB RDS for MySQL instance to increase the backup frequency.

Prerequisites

The RDS instance runs RDS High-availability Edition with standard SSDs or enhanced SSDs (ESSDs).

Billing rules

ApsaraDB RDS for MySQL provides a free quota on the storage of each RDS instance to store backup files. If the total size of the backup files of your RDS instance does not exceed the free quota, no fees are charged. If the total size of the backup files of your RDS instance exceeds the free quota, you are charged for the excess storage that you use. For more information, see Backup storage pricing of an ApsaraDB RDS for MySQL instance.

Description

  • If you do not enable the high-frequency snapshot backup feature, you can set the snapshot backup frequency to once a day.
  • If you enable the high-frequency snapshot backup feature, you can specify a backup frequency that ranges from 15 minutes to 12 hours based on your business requirements.
The snapshot retention policy changes based on the snapshot backup frequency.
Snapshot backup frequency Snapshot retention policy
Minutes If you set the snapshot backup frequency to a value at the minute granularity, all snapshots that are completed within 1 hour are retained. For snapshots that are retained for more than 1 hour, ApsaraDB RDS keeps only the first snapshot in each hour. For snapshots that are retained for more than 24 hours, ApsaraDB RDS keeps only the first snapshot after 00:00 every day.

For example, if you set the snapshot backup frequency to 15 minutes, four snapshots are generated within 1 hour and all snapshots are retained. For snapshots that are generated within the range of 1 to 24 hours, the first snapshot that is completed in each hour is retained, and a total of 23 snapshots are retained within the range. For snapshots that are generated within the range of 24 hours to 7 days, the first snapshot that is completed on each day is retained, and a total of 6 snapshots are retained within the range. In this example, if you set the snapshot backup frequency to 15 minutes, a total of 33 snapshots are retained within a week.

Hours If you set the snapshot backup frequency to a value at the hour granularity, all snapshots that are completed within 24 hours are retained. For snapshots that are retained for more than 24 hours, ApsaraDB RDS keeps only the first snapshot after 00:00 every day.

For example, if you set the snapshot backup frequency to 6 hours, four snapshots are generated within 24 hours and all snapshots are retained. For snapshots that are generated within the range of 24 hours to 7 days, the first snapshot that is completed on each day is retained, and a total of 6 snapshots are retained within the range. In this example, if you set the snapshot backup frequency to 6 hours, a total of 10 snapshots are retained within a week.

Enable the high-frequency snapshot backup feature

In the left-side navigation pane of the details page of your RDS instance, click Backup and Restoration. On the Backup Settings tab of the page that appears, specify a snapshot backup frequency.
Note
  • Before you can use this feature, you must enable the Single-digit Second Backup feature. If the Single-digit Second Backup feature is disabled, ApsaraDB RDS automatically enables the Single-digit Second Backup feature when you enable this feature.
  • For more information about other parameters, see Enable the automatic backup feature for an ApsaraDB RDS for MySQL instance.

Related operations

Operation Description
Modify backup settings Modifies the backup settings of an ApsaraDB RDS instance.
Note To specify a snapshot backup frequency, you must configure the BackupInterval parameter.