Introduction
TDSQL-C MySQL data backup is a database backup feature provided by Tencent Cloud COS (Cloud Object Storage, COS) based on SCF (Serverless Cloud Function, SCF) for users, which can assist users in transferring backup files on TDSQL-C MySQL cloud database to COS for persistent storage to prevent data loss or corruption. When users configure backup function rules in a specified bucket, SCF will periodically scan your TDSQL-C MySQL backup files and transfer the files to the bucket. Must-Knows
TDSQL-C MySQL data backup function backs up the binlog backup files of Tencent Cloud TDSQL-C MySQL databases. If you have not enabled scheduled binlog backups for your TDSQL-C MySQL database, you cannot run this backup function. For more information about Tencent Cloud TDSQL-C MySQL database backup, see TDSQL-C MySQL Backup and Rollback Overview. Logical backup and snapshot backup are temporarily not supported for backup to COS via this feature.
If you have previously added TDSQL-C MySQL data backup rules for a bucket in the COS Console, you can view the created TDSQL-C MySQL data backup function in the SCF Console. Do not delete this function, as it may cause your rules to become ineffective. The current feature only supports regions where both COS and SCF are available. Some regions (such as Chongqing) are not supported. For specifics, refer to the regions displayed on the COS and SCF consoles.
Operation Steps
Configure Backup In Application Integration
2. In the left navigation, click Application Integration > Data Backup, and locate TDSQL-C MySQL Backup.
3. Click Configure Backup Rules to go to the rule configuration page.
4. Click Add Function.
Note:
If you have not activated SCF service, please go to the SCF console to activate the service and follow the prompts to complete the service authorization. 5. In the pop-up window, configure the following information:
Function Name: As the unique identifier of the function, it cannot be modified after creation. You can view this function on the SCF Console. Associated Bucket: the bucket that stores TDSQL-C MySQL backup files.
Note:
The region where the TDSQL-C MySQL data to be backed up resides must be the same as the region of the associated bucket.
Trigger Cycle: The TDSQL-C MySQL data backup function triggers backup offloading operations through timer triggers. Supported trigger cycles include daily, weekly, and custom intervals.
Note:
For example, a user configured TDSQL-C backup rules on July 3, 2023, specifying that TDSQL-C instance files be backed up to COS daily at 00:00.
The SCF will begin running at 2023-07-04 00:00:03 (with a few seconds' delay in startup), scan TDSQL-C instance files from the past three days, and upload them to COS.
The SCF runs at 2023-07-04 00:00:03, so the final backup file time range is: 2023-07-01 00:00:00 to 2023-07-04 00:00:03.
Cron Expression: When the trigger cycle is set to custom, you can specify the trigger cycle rules via Cron. Cron currently runs on local standard time. For detailed configuration policies, see Cron-related documentation. Database Instance: the list of TDSQL-C MySQL database instances in the current bucket's region.
Delivery Path: The prefix of the delivery path for backup files. If left blank, files will be saved by default at the root path of the bucket.
SCF Authorization: TDSQL-C MySQL data backup requires authorizing the cloud function to read database instances and their backup files from your TDSQL-C MySQL backups, and offload the backup files to your specified bucket. This authorization is thus required.
6. After adding the configuration, click Confirm, and you will see that the function has been successfully added.
You can perform the following operations on the newly created function:
Click Logs to view the historical operation status of TDSQL-C MySQL data backup. When backup errors occur, you can also click Logs to quickly navigate to the SCF Console and view log error details.
Click More > Edit to modify TDSQL-C MySQL data backup rules.
Click More > Delete to remove unused TDSQL-C MySQL data backup rules.
Set up backup in the bucket configuration item
2. In the left navigation, select Bucket List, click the bucket that requires TDSQL-C MySQL data backup setup, and go to the bucket management page.
3. Click Function Compute on the left and locate the TDSQL-C MySQL Backup Function configuration item.
Note:
If you have not activated SCF service, please go to the SCF console to activate the service and follow the prompts to complete the service authorization. 4. Click Add Function.
5. In the pop-up window, configure the following information:
Function Name: As the unique identifier of the function, it cannot be modified after creation. You can view this function on the SCF Console. Trigger Cycle: The TDSQL-C MySQL data backup function triggers backup offloading operations through timer triggers. Supported trigger cycles include daily, weekly, and custom intervals.
Note:
For example, a user configured TDSQL-C backup rules on July 3, 2023, specifying that TDSQL-C instance files be backed up to COS daily at 00:00.
The SCF will begin running at 2023-07-04 00:00:03 (with a few seconds' delay in startup), scan TDSQL-C instance files from the past three days, and upload them to COS.
The SCF runs at 2023-07-04 00:00:03, so the final backup file time range is: 2023-07-01 00:00:00 to 2023-07-04 00:00:03.
Cron Expression: When the trigger cycle is set to custom, you can specify trigger cycle rules via Cron. Cron currently runs on UTC+8 China Standard Time (CST), which is Beijing Time. For detailed configuration policies, see Cron-related documentation. Database Instance: the list of TDSQL-C MySQL database instances in the current bucket's region.
Delivery Path: The prefix of the delivery path for backup files. If left blank, files will be saved by default at the root path of the bucket.
SCF Authorization: TDSQL-C MySQL data backup requires authorizing the cloud function to read database instances and their backup files from your TDSQL-C MySQL backups, and offload the backup files to your specified bucket. This authorization is thus required.
6. After adding the configuration, click Confirm, and you will see that the function has been successfully added.
You can perform the following operations on the newly created function:
Click Logs to view the historical operation status of TDSQL-C MySQL data backup. When backup errors occur, you can also click Logs to quickly navigate to the SCF Console and view log error details.
Click More > Edit to modify TDSQL-C MySQL data backup rules.
Click More > Delete to remove unused TDSQL-C MySQL data backup rules.