Data Disaster Recovery 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 Supported database types 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 DMS console V5.0.
In the top navigation bar, choose .
NoteIf you use the DMS console in simple mode, move the pointer over the
icon in the upper-left corner of the DMS console and choose . 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, Data Disaster Recovery starts a full backup task and an incremental backup task at the same time.
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, Data Disaster Recovery 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 for Data Disaster Recovery.
Disable incremental log backup
Log on to the DMS console V5.0.
In the top navigation bar, choose .
NoteIf you use the DMS console in simple mode, move the pointer over the
icon in the upper-left corner of the DMS console and choose . 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.
Data Disaster Recovery no longer generates incremental backup data and clears existing incremental backup sets when they expire.
References
Related API operations
API operation | Description |
Enables the incremental log backup feature. | |
Disables the incremental log backup feature. | |
Queries a list of incremental backup tasks. |