Incremental log backup captures database transaction logs to accurately track data changes, such as insert, update, and delete operations. After you enable this feature, you can restore a database to any point in time after a backup is performed. The data lifecycle of an incremental log backup is identical to that of a full backup. This topic describes how to enable or disable incremental log backup.
Prerequisites
Before you begin, ensure that you have:
Created a backup plan
Configured the backup plan
Usage notes
-
Before you enable incremental log backup, confirm that your source database supports this feature. For more information, see Supported database types and features.
-
Before you enable incremental log backup, ensure that Binlog is enabled for your source database.
Note-
Binlog is enabled by default for ApsaraDB RDS for MySQL, but you must enable it manually for self-managed databases.
-
To enable Binlog for PolarDB for MySQL, see Enable Binlog.
-
Enable incremental log backup
-
Log in 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 . -
In the Actions column of the target backup plan, click Manage. The backup task configuration page opens.
-
In the Running Information section, click .
-
The Precheck dialog box automatically opens. The system checks the source database connectivity, database permissions, OSS connection, Binlog status of the source database, Binlog mode, and
binlog_row_imageconfiguration. After you confirm that all checks are successful, click Start Now or click the
icon in the upper-right corner of the dialog box.Note-
If you click Start Now, the system starts one full backup task and one incremental backup task.
After the full backup is complete, you can restore the database to any point in time after this full backup set is created.
-
If you click the
icon, the system does not start the full and incremental backup tasks immediately.The system will start an incremental backup task concurrently with the next scheduled full backup task, based on your existing scheduling policy. After the full backup is complete, you can restore the database to any point in time after this full backup set is created.
-
If the precheck fails, follow the on-screen instructions and try again. For more information, see Troubleshoot common errors in Disaster Recovery for Data (formerly DBS).
-
Disable incremental log backup
-
Log in 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 . -
In the Actions column of the target backup plan, click Manage. The backup task configuration page opens.
-
In the Running Information section, click .
-
After you disable incremental log backup, any ongoing incremental backup tasks stop immediately.
-
The system stops generating incremental backup data and automatically deletes historical backup sets upon expiration.
Related documents
Related APIs
|
API |
Description |
|
Enables incremental log backup. |
|
|
Disables incremental log backup. |
|
|
Queries the list of incremental backup tasks. |