Incremental log backup captures transaction logs (inserts, updates, and deletes) on top of your existing full backup schedule. With incremental log backup enabled, you can restore your database to any point in time between the completion of the first full backup and the last incremental backup — a capability known as point-in-time recovery (PITR).
The lifecycle of incremental backup data follows that of full backup data.
Prerequisites
Before you begin, make sure that:
Your database supports incremental log backup. For supported database types, see Supported database types and features.
Binary logging is enabled for your database:
ApsaraDB RDS for MySQL: Binary logging is enabled by default.
PolarDB for MySQL: See Enable binary logging.
Self-managed databases: Enable binary logging manually before proceeding.
Enable incremental log backup
Log on to the DMS console V5.0.
In the top navigation bar, choose Security and Specifications (DBS) > Disaster Recovery for Data (DBS) > Backup Plan.
If you use the DMS console in simple mode, move the pointer over the
icon in the upper-left corner and choose All Features > Security and Specifications (DBS) > Disaster Recovery for Data (DBS) > Backup Plan.Find the backup plan you want to manage and click Manage in the Actions column to open the Configure Task page.
In the Task Running Information section, click Enable Incremental Log Backup. In the confirmation message, click OK.
After the precheck completes successfully, choose one of the following options:
Start Task: DBS immediately starts a full backup and an incremental backup in parallel. Once the full backup completes, PITR is available from that point forward.
Close (
): DBS skips the immediate backup. The next scheduled full backup automatically triggers incremental backup. Once that full backup completes, PITR becomes available.
If the precheck fails, follow the on-screen prompts to resolve the issue. For details, see Common errors and troubleshooting for Data Disaster Recovery.
Disable incremental log backup
Disabling incremental log backup has the following effects:
Any incremental backup task in progress is immediately stopped.
DBS stops generating new incremental backup data.
Existing incremental backup sets are cleared when they expire.
Log on to the DMS console V5.0.
In the top navigation bar, choose Security and Specifications (DBS) > Disaster Recovery for Data (DBS) > Backup Plan.
If you use the DMS console in simple mode, move the pointer over the
icon in the upper-left corner and choose All Features > Security and Specifications (DBS) > Disaster Recovery for Data (DBS) > Backup Plan.Find the backup plan you want to manage and click Manage in the Actions column to open the Configure Task page.
In the Task Running Information section, click Disable Incremental Log Backup. In the confirmation message, click OK.
What's next
API reference
| API operation | Description |
|---|---|
| EnableBackupLog | Enables the incremental log backup feature. |
| DisableBackupLog | Disables the incremental log backup feature. |
| DescribeIncrementBackupList | Queries a list of incremental backup tasks. |