Database Backup (DBS) provides the incremental log backup feature. You can use this feature to back up transaction logs of your database. This way, you can track data operations on the database, such as insert, update, and delete operations, based on the transaction logs. After you enable incremental log backup, you can restore the database to any point in time from the completion of the first full backup to the completion of the last incremental backup. The lifecycle of incremental backup data is the same as that of full backup data. This topic describes how to enable or disable incremental log backup.
Prerequisites
The database that you want to back up supports the incremental log backup feature. For more information, see Database engines and features.
The binary logging feature is enabled for the database that you want to back up.
NoteBy default, the binary logging feature is enabled for an ApsaraDB RDS for MySQL database. If you use a self-managed database, you must manually enable the binary logging feature.
For more information about how to enable the binary logging feature for a PolarDB for MySQL database, see Enable binary logging.
Enable incremental log backup
Log on to the DBS console.
In the left-side navigation pane, click Backup Schedules. In the top navigation bar, select a region.
Find the backup schedule that you want to manage and click Manage in the Actions column to go to the Configure Task page.
In the Task Running Information section, click . In the message that appears, click OK.
The Precheck message appears. After the precheck succeeds, click Start Task or click the
icon in the upper-right corner of the message. NoteIf you click Start Task, DBS starts a full backup task and an incremental backup task.
After the full backup task is complete, you can restore the database to any point in time from the completion of the first full backup.
If you click the
icon, DBS does not start a full backup task or an incremental backup task. The next time a full backup task starts based on your existing scheduling policy of the full backup set, DBS also starts an incremental backup task. After the full backup task is complete, you can restore the database to any point in time from the completion of the first full backup.
If the precheck fails, try again as prompted. For more information, see Common Errors and Troubleshooting.
Disable incremental log backup
Log on to the DBS console.
In the left-side navigation pane, click Backup Schedules. In the top navigation bar, select a region.
Find the backup schedule that you want to manage and click Manage in the Actions column to go to the Configure Task page.
In the Task Running Information section, click . In the message that appears, click OK.
If an incremental backup task is in progress when you disable incremental log backup, the incremental backup task is immediately stopped.
DBS no longer generates incremental backup data and clears existing incremental backup sets when they expire.
References
Related API operations
Operation | Description |
Enables the incremental log backup feature. | |
Disables the incremental log backup feature. | |
Queries a list of incremental backup tasks. |