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
Your RDS instance must meet the following requirements:
Major engine version: MySQL 8.0 or MySQL 5.7
Edition: RDS High-availability Edition or RDS Cluster Edition
Storage type: ESSDs or general ESSDs
The AliyunServiceRoleForDBS service-linked role is created by using your Alibaba Cloud account if you use the backup feature of ApsaraDB RDS for the first time. For more information, see How do I create a service-linked role for DBS?
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 backup storage that you use. For more information, see Backup storage fees.
Feature 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 generated 1 hour ago, ApsaraDB RDS deletes the snapshots except for the first snapshot after the hour. For snapshots that are generated 24 hours ago, ApsaraDB RDS deletes the snapshots except for 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. |
For more information about snapshot retention policies, see Manage the snapshots that are generated by the high-frequency snapshot backup feature.
Enable the high-frequency snapshot backup feature
In the left-side navigation pane of the instance details page, click Backup and Restoration. On the Backup Strategy tab of the page that appears, click Edit in the Basic Backup section to specify a snapshot frequency.
Before you can use this feature, you must enable the single-digit second backup feature. If the single-digit second backup feature is disabled, the system automatically enables the single-digit second backup feature when you enable the high-frequency snapshot backup feature.
For more information about other parameters, see Use the automatic backup feature.
References
You can also call an API operation to configure the snapshot backup frequency that is specified by the BackupInterval parameter. For more information, see ModifyBackupPolicy.
For more information, see Backup features of an ApsaraDB RDS for PostgreSQL instance or Overview of data restoration methods.