TDSQL-C for MySQL supports data recovery using snapshot backups. Its console provides a convenient operation interface, allowing you to quickly restore data with ease. When using snapshot backups,supports table-level rollback to the original cluster,table-level rollback to a new cluster, and entire cluster rollback to a new cluster. This document introduces how to use snapshot backups via the console to perform an entire cluster rollback to a new cluster. Note:
Billing for the new rolled-back cluster will start after the rollback succeeds. For more information on billing and pricing, please refer to Billing Overview. When performing an entire cluster rollback to a new cluster, the system will create a new cluster based on your selection. After the new cluster is verified, you can migrate the data back to the original cluster via DTS, allowing you to continue using the original cluster's VIP address; or you can directly use the new cluster, but you'll need to update your applications with the new cluster's VIP address and decide whether to delete the original cluster based on your actual needs. Feature Limits
When using snapshot backups to perform an entire cluster rollback to a new cluster via the console, swapping the VIP addresses of the original and new clusters is not supported.
Rollback mode
Rollback by backup file: This method restores the cluster to the dataset state of a specific snapshot backup file. The selection range of the backup file is determined by the data backup retention duration you set.
Rollback by time point: This method restores the cluster to any time point within the log backup retention duration you set.
Note:
When performing rollback by time point, the system will prioritize using snapshot backups. If no snapshot backup file is found, logical backup will be used. If you need to strictly restore based on the backup file type (logical backup or snapshot backup), it is recommended to choose rollback by backup file.
Prerequisites
There is an existing available snapshot backup under the original cluster. To generate a snapshot backup, please refer to Perform Backup steps in each documentation. The cluster status is running.
Procedural Steps
2. On the cluster management page, select Backup Management tab, click Roll Back.
3. On the rollback page, complete the following configuration, click Go to the purchase page to roll back the cluster.
|
Select a rollback type | Select Restore to a new cluster. |
Select Restore Scope | Select Whole Cluster Rollback. |
Region | Select the region for the new cluster. If you want to rollback using a snapshot backup, you need to choose the same region as the original cluster. |
AZ | Select the Availability Zone for the new cluster. |
Rollback Mode | Support for selecting rollback by backup file or by time point. |
Backup File | If the rollback mode is set to backup file, you need to select an existing snapshot backup file for the rollback, and then select the database table to be rolled back. |
Rollback Time | If the rollback mode is set to time point, you need to select the rollback time point. |
4. In the pop-up purchase page, complete the corresponding Database Configuration for the required database form, click Next.
Note:
If your new cluster is to be created as a Serverless instance type, you need to ensure that both the region and availability zone of the original and new clusters support the Serverless instance type. Otherwise, you can only create a cluster with the instance type set to Pre-configured Resources. Please refer to the purchase page for specific support details.
Select Provisioned Resource for instance type
Instance Mode: Provisioned Resource.
Rollback Mode: Support rollback by backup file and by time point.
By backup file: A new cluster can be restored from the specified backup set, and the selection range is based on the time of backup completion and the retention duration.
By time point: A new cluster can be restored from a specific time point, and the selection range is based on the backup retention duration.
Select Restore Scope: Choose Entire Cluster Rollback.
Region: Select the region for the new cluster. If you want to rollback using a snapshot backup, you need to choose the same region as the original cluster.
Source AZ: Select the Availability Zone for the new cluster.
Transfer Linkage: High IO.
Network: Select VPC.
Database Version: Same as the cluster restored.
Instance Type: Supports General and Dedicated types.
Compute Instance (read/write): Select the compute specifications for the read-write instance. Only one read-write instance is supported.
Compute Instance (read-only): Select the compute specifications and quantity for the read-only instance.
Computational Billing Mode: Supports annual and Monthly Subscription and Pay-as-You-Go billing.
Storage Billing Mode: Default is Pay-as-You-Go.
Instance Type: Select Serverless
Instance Mode: Serverless.
Rollback Mode: Support rollback by backup file and by time point.
By backup file: A new cluster can be restored from the specified backup set, and the selection range is based on the time of backup completion and the retention duration.
By time point: A new cluster can be restored from a specific time point, and the selection range is based on the backup retention duration.
Select Restore Scope: Choose Entire Cluster Rollback.
Region: Select the region for the new cluster. If you want to rollback using a snapshot backup, you need to choose the same region as the original cluster.
AZ: Select the AZ corresponding to the new cluster.
Transfer Linkage: High IO Version.
Network: Select VPC.
Database Version: Same as the cluster restored.
Serverless Architecture: Supports single-node and cluster editions.
Computing Power Configuration: Choose the upper and lower limits of the computing power configuration CCU (TDSQL-C Compute Unit). The instance will automatically scale up and down flexibly within the selected resource range. CCU (TDSQL-C Compute Unit) is the billing unit for Serverless computing. One CCU is approximately equal to 1 CPU core and 2 GB memory. The number of CCUs used in each billing cycle is the greater value between the number of CPU cores used by the database and 1/2 of the memory size. For more information on computing power configuration, refer to Service Computing Power Configuration. Automatic Suspension: Configure the automatic pause time of the instance. If there is no connection to access the database within the set time, the instance will be automatically paused. Once paused, billing will stop.
Computational Billing Mode: Supports pay-as-you-go or resource package.
Note:
Compute Resource Package: Used to prioritize the deduction of actual usage of pay-as-you-go products. Once the resource package quota is exhausted, billing will continue using the pay-as-you-go model. The compute resource package will be deducted based on the actual CCU used per second, making it more cost-effective and flexible than the pay-as-you-go model.
Compute Resource Package (Displayed when the computational billing model is set to resource package): Bind a resource package, which can be any available compute resource package in the same region under the current account and within the validity period. If there are no available resource packages, purchase a resource package first. Storage Billing Mode: Supports pay-as-you-go or resource package.
Note:
Storage Resource Package: Used to prioritize the deduction of actual usage of pay-as-you-go products. Once the resource package quota is exhausted, billing will continue using the pay-as-you-go model. The storage resource package will be deducted based on the actual storage used per hour, making it more cost-effective and flexible than the pay-as-you-go model.
Storage Resource Package (Displayed when the storage billing model is set to resource package): Bind a resource package, which can be any available storage resource package in the same region under the current account and within the validity period. If there are no available resource packages, purchase a resource package first. 5. On the configuration page, set basic and advanced information, including cluster name, default character set, security group, parameter template, and item. After confirming everything is correct, click Purchase Now.
6. Return to the cluster list. You can see the new cluster created through rollback. Once the status changes to Running, it can be used normally.
Was this page helpful?