TencentDB for MySQL offers a certain amount of backup capacity for free based on the region. The capacity is equivalent to the sum of the storage capacity of all two-node and three-node instances (including source instances and disaster recovery instances) in the region.
The used space and free space of a single-node instance of cloud disk edition are displayed separately, which can be viewed on the Backup and Restoration tab.
For prices of backup capacity that exceeds the free tier, see Backup Space Billing.
Note:The rollback feature relies on the backup cycle and retention days of data backups and log backups (binlog). Rollback will be affected if you reduce the automatic backup frequency and retention period. You can select the parameters as needed. For more information, see Rolling back Database.
Business Scenario | Recommended Backup Retention Period |
---|---|
Core businesses | 7–1,830 days |
Non-core, non-data businesses | 7 days |
Archival businesses | 7 days. We recommend you manually back up data based on your actual business needs and delete the backups promptly after use |
Testing businesses | 7 days. We recommend you manually back up data based on your actual business needs and delete the backups promptly after use |
You can configure it on the Backup and Restoration tab in the TencentDB for MySQL console.
TencentDB for MySQL instances are fully backed up on a daily basis by default. For more information, see Backing up Database > Backup modes. You can also back up data by using the following methods:
Basic single-node instances only support snapshot backups. For more information, see Offline Migration of Data > Data Migration with Command Line Tool.
You can use the wget -c 'backup file download address' -O custom filename.xb
command to download data backup files. Note that the download address should be placed inside a pair of single quotation marks (') to help the program identify it.
Yes. For detailed directions, see Restoring Database from Logical Backup.
Backup tasks cannot be canceled.
We recommend you copy the download address on the Backup and Restoration tab in the TencentDB for MySQL console, log in to a Linux CVM instance in the same VPC as the TencentDB instance, and run the wget
command for download over the private network at a higher speed.wget
command format: wget -c 'backup file download address' -O custom filename.xb
Expired backup sets will be automatically deleted and cannot be downloaded or restored.
Note:Manual backups will also take up the backup space. We recommend you plan the usage of the backup space appropriately to reduce costs.
No. However, you can reduce the backup frequency and delete manual backups no longer used in the TencentDB for MySQL console to lower the space usage.
You need to check the automatic backup time you configured. If the instance is performing the daily automatic backup task, you cannot initiate a manual backup task.
After the backup feature as described in Backing up Database was upgraded, both logical and physical backups adopted the new compression algorithm, making some download features currently unavailable.To perform logical backups by tables, you can select Logical backup > Specify table in manual backup and download the completed backup file.
Because backup files in the latest version adopt a new compression algorithm, they cannot be unpacked/decompressed with the tar tool. Instead, xbstream and qpress are required.
For more information on how to unpack/decompress backup files with xbstream and qpress, see Restoring Database from Physical Backup and Restoring Database from Logical Backup.
yum
repositories.
Was this page helpful?