Backup and Recovery
The TiDB service will back up data to user’s US3-Bucket, making it convenient for users to download the data by themselves. It requires users to enable US3 permissions and authorize operations (create bucket, upload backup files, download backup files for recovery) on US3 product.
Setting Backup Strategy
| Parameter | Description |
|---|---|
| Whether to enable automatic backup | Enable automatic backup switch |
| Backup time | Daily automatic backup time |
| The number of automatic backup retain | There will be a limit on the number of automatic backups. When the number exceeds the limit, the earliest automatic backup will be deleted, up to 7 copies |
| Automatic backup cycle | The interval in days between automatic backups, up to 7 days |
Adjusting Automatic Backup Strategy
You can adjust whether to enable automatic backup and the backup strategy by clicking the “Automatic Backup Strategy” button in the backup panel.
Manual Backup
In addition to the automatic backup, TiDB also provides manual backup options. You can initiate a manual backup task by clicking the “Manual Backup” button in the backup panel, and a maximum of 7 copies of the manual backup can be preserved at the same time.
Deleting Backup Data
The backup data supports manual deletion, Users can manually delete historical backup data (including automatic and manual backup data).
In the operations list of the backup, choose the ‘Delete’ button to delete the backup data.
Backup Recovery
TiDB currently supports recovering from a backup file to a new TiDB instance. User needs to prepare a new instance in advance, recovery operation will overwrite the data in the new instance, pleaase be careful when selecting.
In the backup list, select the backup data to be recovered, click the “Recover” button to open the recovery window, select the new instance to be recovered, and click “Confirm” to start the recovery task.
After selecting, you can check the status of the recovery task in the recovery panel.