When a table or data in the cluster is accidentally deleted or modified, if you need restore it to its original status, you can restore the data to the original cluster.
TDSQL-C for MySQL supports database/table-level rollback by time point and backup set.
Rollback by time point: The selection range of time point is determined by the log backup retention period you set.
Rollback by backup set: The selection range of the backup file is determined by the data backup retention period you set.
After a cluster is created, TDSQL-C for MySQL generates backup files every 6-48 hours on a 24/24 uninterrupted basis, which has no impacts on the instance performance. You can also set the backup retention time in the console as needed. Based on this, when you perform database/table-level rollback on the cluster, the available time points and backup sets will be directly displayed for your selection in the console.
Process
To roll back by time point or by backup set, you need to roll back the backup data to the original cluster first, and then compare the data.
The process is as shown below:
