After you enable the log backup feature for your RDS instance, the binary log files of your RDS instance are uploaded to backup storage in real time. The binary log files in the backup storage are called log backup files. You can use log backup files to restore data to a specific point in time within the backup retention period that you specified. This topic describes how to manage and view the log backup files of an ApsaraDB RDS for MySQL instance.
Billing
You are not charged for the feature. However, log backup files consume backup storage, and you are charged for the backup storage that is consumed. A free quota on backup storage is provided. If the total size of data backup files and log backup files exceeds the free quota, you are charged backup storage fees. For more information, see Backup storage pricing of an ApsaraDB RDS for MySQL instance.
Enable or disable the log backup feature
- 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.
- In the left-side navigation pane, click Backup and Restoration.
- On the Backup and Restoration page, click the Backup Strategy tab.
- In the Base Backup section, click Edit to disable the log backup feature.Note
- After you turn on Log Backup, you can specify a retention period for log backup files. Log backup files can be retained for 7 to 730 days.
- The retention period for log backup files cannot be longer than the retention period for data backup files.
- If your RDS instance runs MySQL 5.7 on RDS Basic Edition, the retention period for log backup files is fixed as seven days.
View log backup files
- 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.
- In the left-side navigation pane, click Backup and Restoration.
- On the Backup and Restoration page, click Base Backups and then Log Backup. If your RDS instance runs RDS High-availability Edition or RDS Enterprise Edition, log backup files are generated by your primary RDS instance and its secondary RDS instances. You can check the instance ID of each log backup file to identify the log backup files that are generated by your primary RDS instance and the log backup files that are generated by the secondary RDS instances.
View the total size of log backup files
- 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.
- On the Basic Information page of the RDS instance, view the total size of log backup files in the Usage Statistics section. Note
- Log backup files are stored in the backup storage and do not consume the storage capacity of your RDS instance. The backup storage is inaccessible.
- After you update the minor engine version of your RDS instance, the value of the Backup Size parameter on the Basic Information page in the ApsaraDB RDS console may be displayed as 0. After the next scheduled backup is complete, this error is automatically fixed.
Delete log backup files
For more information, see Delete the backup files or reduce the size of backup files
Download log backup files
For more information, see Download the backup files of an ApsaraDB RDS for MySQL instance
Restore data to a specific point in time
For more information, see Restore full data of an ApsaraDB RDS for MySQL instance and Restore individual databases and tables of an ApsaraDB RDS for MySQL instance.
FAQ
Category | Description |
Data restoration | Can I use log backup files to restore data? After the log backup feature is enabled, you can restore data to a specific point in time within the backup retention period that you specified. The point in time can be accurate to seconds. For more information, see Restore full data of an ApsaraDB RDS for MySQL instance or Restore individual databases and tables of an ApsaraDB RDS for MySQL instance. |
Backup fee | Am I charged for the log backup feature? No, you are not charged for the feature. However, log backup files consume backup storage, and you are charged for the backup storage that is consumed. A free quota on backup storage is provided. If the total size of data backup files and log backup files exceeds the free quota, you are charged backup storage fees. For more information, see Backup storage pricing of an ApsaraDB RDS for MySQL instance. |
Backup file check |
|
Disabling of the feature and reduction of log backups |
|
Related operations
Operation | Description |
DescribeBackupPolicy | Queries the backup settings of an ApsaraDB RDS instance. |
ModifyBackupPolicy | Modifies the backup settings of an ApsaraDB RDS instance. |