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) in the region.
For prices of backup capacity that exceeds the free tier, please see Backup Space Billing.
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. Please select the parameters as needed.
|Business Scenario||Recommended Backup Retention Period|
|Core businesses||7-1830 days|
|Non-core and non-data businesses||7 days|
|Archive businesses||7 days. We recommend that you manually back up data based on your business needs and delete the backups promptly after use|
|Testing businesses||7 days. We recommend that you manually back up data based on your 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, please see Backing up Databases > Backup modes. You can also back up data by using the following methods:
Basic single-node instances only support snapshot backups. For more information, please see Offline Migration of Data > Data Migration via the 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.
No. We recommend that you use DTS to migrate a MySQL instance.
Backup tasks cannot be canceled.
We recommend that 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 high-speed download over the private network.
wgetcommand format: wget -c 'backup file download address' -O custom filename.xb
Expired backup sets will be deleted automatically and cannot be downloaded or restored.
Manual backups will also take up the backup space. We recommend that 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 via the TencentDB for MySQL console to lower the capacity usage.
Please 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 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 log in to the TencentDB for MySQL console, click an instance ID to access the instance’s management page, click Manual Backup on the Backup and Restoration tab, and select Logical cold backup > Specify table in the pop-up dialog box. You can also download the logical backup file from the backup list after the backup is completed.
Because backup files in the latest version adopt a new compression algorithm, they cannot be unpacked/decompressed using the tar tool. Instead, xbstream and qpress are required.
For more information about how to unpack/decompress backup files with xbstream and qpress, please see Restoring Databases from Physical Backups and Restoring Databases from Logical Backups.