ApsaraDB RDS:Enable the automatic backup feature for an ApsaraDB RDS for MySQL instance

Prerequisites

If this is the first time that you use the backup feature of ApsaraDB RDS, you must create the AliyunServiceRoleForDBS service-linked role for Database Backup (DBS) by using your Alibaba Cloud account. For more information, see How do I create a service-linked role for DBS.

Procedure

1. Go to the Instances page. In the top navigation bar, select the region in which the RDS instance resides. Then, find the RDS instance and click the ID of the instance.

2. In the left-side navigation pane, click Backup and Restoration.

3. On the Backup and Restoration page, click the Backup Strategy tab.

4. In the Basic Backup section, click Edit. Configure the following parameters and click OK.

   Note

   If your RDS instance uses cloud disks, the system creates snapshots to back up the data of the RDS instance.

   Table 2. Data backup settings

   Instance category	Parameter	Description
   All RDS instances	Full Backup Retention Period (Days)	The number of days for which backup files are retained. Default value: 7. Valid values: For RDS instances that use cloud disks: 7 to 730. Note If your RDS instance runs MySQL 5.7 on RDS Basic Edition, the value is fixed as 7. If you enable the single-digit second backup feature, the value of this parameter ranges from 7 to 730. For RDS instances that use local disks: 7 or more. The value must be less than 2 to the power of 31. Data backup files that are retained for 730 days or less are considered regular backup files. Data backup files that are retained for more than 730 days are converted into archived backup files. The cost of archived backup files is less than the cost of regular backup files. For more information, see Backup storage pricing of an ApsaraDB RDS for MySQL instance. Note If you set this parameter to a value greater than 730 or select Long-term Retention, you must specify the number of archived backup files to retain. For example, if you select Monthly and enter 2 in the unit field, the system retains the first two archived backup files that are generated each month.
   	Full Backup Cycle	The cycle based on which data backups are created. You must select at least two days of the week.
   	Start At	The time at which a data backup starts. For example, you can select 08:00. We recommend that you select an off-peak hour.
   RDS instances that use local disks	Database/Table Restoration	Specifies whether to enable the restoration feature for individual databases and tables. For more information, see Restore individual databases and tables of an ApsaraDB RDS for MySQL instance The restoration feature for individual databases and tables is automatically enabled and cannot be disabled. Note The restoration feature for individual databases and tables is supported for RDS instances that run MySQL 8.0, MySQL 5.7, or MySQL 5.6 on RDS High-availability Edition and use local disks. After you enable the restoration feature for individual databases and tables, a new backup file format takes effect. For more information, see [Notice] New physical backup file format phased in for some ApsaraDB RDS for MySQL instances.
   	Fast Restoration	Specifies whether to enable the fast restoration feature for individual databases and tables. If you enable the fast restoration feature for individual databases and tables, the data is restored at a fast speed. If you disable the fast restoration feature, the data is restored at a standard speed. Standard: Data is restored at a standard speed. Fast: Data is restored at a speed that is 50% to 95% faster than standard restoration. For more information, see Restore individual databases and tables of an ApsaraDB RDS for MySQL instance. Note If you enable the fast restoration feature for individual databases and tables, you must also configure the CDM Billing Method and CDM Retention Period parameters. The fast restoration feature for individual databases and tables is not supported in some Alibaba Cloud regions.
   	Retain Backup Files after Instance Release	Specifies whether to retain backup files after the RDS instance is released. Note This parameter is displayed and can be configured only when your RDS instance uses local disks and was created at least seven days ago. We recommend that you select Latest or All. After your RDS instance is released, you can go to the Backup for Deleted Instances tab to download the backup files of your RDS instance. Then, you can use the backup files to restore the data of your RDS instance. For more information, see Retain the backup files of an ApsaraDB RDS for MySQL instance for a long period of time.
   RDS instances that use cloud disks	Backup within Seconds	Specifies whether to enable the single-digit second backup feature. If the feature is enabled, a snapshot backup can be completed within a few seconds. Note This feature is supported for RDS High-availability Edition with enhanced SSDs (ESSDs) and RDS Cluster Edition.
   	Increase Snapshot Frequency	The frequency at which snapshot backups are created. You can configure a shorter interval to create snapshots by using the single-digit second backup feature, which increases the frequency of the snapshots. You can increase the frequency to up to once every 15 minutes. The snapshot retention policies vary based on the value of this parameter. A value at the minute granularity: All snapshots that are completed within 1 hour are retained. For snapshots that are generated 1 hour ago, the system deletes the snapshots except for the first snapshot after the hour. For snapshots that are generated 24 hours ago, the system deletes the snapshots except for the first snapshot after 00:00 every day. A backup frequency at the hour granularity: All snapshots that are completed within 24 hours are retained. For snapshots that are generated 24 hours ago, the system deletes the snapshots except for the first snapshot after 00:00 every day. Note This feature is supported for RDS High-availability Edition with cloud disks and RDS Cluster Edition. If you want to enable 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 this feature. This feature is supported only for RDS instances that run RDS High-availability Edition with cloud disks. You cannot enable the Increase Snapshot Frequency feature and the Single-digit Second Backup feature at the same time. After the Increase Snapshot Frequency feature is enabled, the maximum backup retention period decreases.
   	Fast Database/Table Restoration	Specifies whether to enable the fast restoration feature for individual databases and tables. Fast restoration provides a restoration speed that is 50% to 95% faster than standard restoration. For more information, see Restore individual databases and tables of an ApsaraDB RDS for MySQL instance. Note The fast restoration feature for individual databases and tables is not supported in some Alibaba Cloud regions.

   Table 3. Log backup settings

   Parameter	Description
   Log Backup	Specifies whether to enable the log backup feature. After the feature is enabled, you can restore the data of your RDS instance to a point in time. This feature is enabled by default.
   Log Backup Retention Period (Days)	Valid values: 7 to 730. Default value: 7. The log backup retention period must be less than or equal to the data backup retention period. Note The value is fixed as 7 for RDS instances that run MySQL 5.7 on RDS Basic Edition.