Release Notes
Product Announcements
One-Click Upgrade to Cluster Edition
This document describes how to upgrade a TencentDB for MySQL dual-node or three-node instance to a cluster instance using the console's one-click upgrade feature.
Prerequisites
The TencentDB for MySQL dual-node or three-node instance architecture is used.
The instance is running.
Notes
After an upgrade to the cluster edition, rollback is not supported. Proceed with caution.
After an upgrade to the cluster edition, the backup files of the original instance will not be retained. If you need to keep the backup files of the original instance, please ensure to download and save it in advance.
This feature is not supported for disaster recovery instances.
Directions
1. Log in to the TencentDB for MySQL console.
2. In the instance list, find the instance to be upgraded and click One-click Upgrade in the Billing Mode column, or check the target instance and click One-click Upgrade above the instance list.
3. In the pop-up window, select Upgrade to TencentDB for MySQL Cluster Edition and click Upgrade Now.
4. On the right side of the pop-up interface, click Change Configuration.
5. In the pop-up window, set the relevant configuration information for the cluster, and then click OK.
Parameter | Description |
AZ | It is used to select the availability zone for read-write nodes and read-only nodes. |
Disk type | It is the cloud disk by default. |
Instance specification | It is used to select the type, CPU, and memory of the instance. |
Disk | It is used to select the disk type and storage space. The storage space range is from 30 to 32,000 GB, with an increment of 10. The storage space should be at least 1.2 times the data file size and not be less than the disk size of the original instance. |
Data protection space | It is used to set data protection space, with a range from 1 to 10 GB. To ensure the recoverability of database instances, cluster instances require the setting of some space for data protection of database instances. The space cannot store data, belongs to the system protection space, and aims to prevent instances from malfunctioning when storage is full. |
6. Due to the upgrade of cluster edition alarm metrics, you need to create an alarm policy. For operations, refer to Alarm Policy.
7. After changing the configuration and selecting the alarm policy, click Upgrade Check at the bottom of the redirected interface.
8. Check items for the upgrade check are listed in the table below. If any item fails, make a necessary adjustment as reminded, and then re-run the upgrade check. Once all the check items pass the upgrade check, you can proceed to the next step.
Check Item | Check Instance Type | Description |
Audit | Primary instance Read-only instance | Check whether the original instance has database audit enabled. If so, migration is not possible. You can back up the database audit logs, disable database audit, and then upgrade to the cluster edition again. For the disabling of database audit, see Disabling Audit Service. |
Backup | Primary instance | Check whether the original instance has regular retention policy, transition-to-cold storage for backup files, or transition-to-cold storage for binlog files enabled. If so, migration is not possible. You need to disable them and try again. For more details and operations, see Backing up Databases and Configuring Transition-to-Cold Storage. |
Backup encryption | Primary instance | Check whether the original instance has backup encryption enabled. If so, migration is not possible. You need to disable it and try again. For more details and operations, see Backup Encryption. |
DR instance | Primary instance | Check whether there are disaster recovery instances under the original instance. If so, migration is not possible. You need to release the disaster recovery instances and try again. For instance releasing operations, see Terminating Instances. |
Elastic expansion | Primary instance Read-only instance | Check whether the original instance has CPU elastic expansion enabled. If so, migration is not possible. You need to disable it and try again. For more details and operations, see CPU Elastic Expansion. |
Instance status | Primary instance Read-only instance | Check whether the original instance's running status is normal. If other tasks are in progress, retry after the tasks are complete and the instance is in running state. Other abnormal status can be adjusted according to the suggested solutions. |
Single node | Primary instance Read-only instance | Check the architecture of the original instance. Only dual-node and three-node instances support one-click upgrade to the cluster edition. If the original instance adopts a single-node architecture, migration is not possible. Select an instance architecture that supports migration. |
Remote backup | Primary instance | Check whether the original instance has cross-region backup enabled. If so, migration is not possible. You can disable cross-region backup and try again. For related operations, see Cross-Region Backup. |
SSL | Primary instance Read-only instance | Check whether the original instance has SSL encryption enabled. If so, migration is not possible. You can disable SSL encryption and try again. For related operations, see Setting SSL Encryption. |
Version check | Primary instance Read-only instance | Check the kernel minor version of the original instance. Migration is possible only if the following conditions are met. For kernel minor version upgrade operations, see Upgrading Kernel Minor Version. MySQL 5.7 20230601 and later versions. MySQL 8.0 20230630 and later versions. |
TDE encryption | Primary instance | Check whether the original instance has TDE encryption enabled. If so, migration is not possible. Use an instance with TDE encryption disabled instead for an upgrade. |
9. Select the upgrade switching time. You can choose to switch during the maintenance time or upon completion of the upgrade. For the setting of maintenance time, see Setting Maintenance Time.
10. Read and check the reminder: During the instance upgrade, data will be migrated, and instance access will not be affected. After upgrade preparation is complete, an instance switch will occur, causing a momentary disconnection. Please ensure that your business has a reconnection mechanism.
11. Click Start Upgrade. You can check the upgrade progress in the Task List.
12. If you choose to switch upon upgrade completion, the original instance will be immediately upgraded to a cluster edition after data consistency verification. The upgrade is complete when the instance is in running state.
13. If you choose to switch during the maintenance time, the upgrade will be performed within the maintenance time you have set. If you want to complete the upgrade immediately, you can go to the instance list, and click Switch Now in the operation column of the target instance. After reading the precautions in the pop-up window, click Switch again. The upgrade is complete when the instance is in running state.
Note:
When you perform instance switching operation, the instance will switch to the cluster architecture.
After switching to the cluster architecture, a new read-only IP address will be generated.
After switching to the cluster architecture, the IP address of the read-write node will remain consistent with the pre-upgrade instance.
Help and Support
Was this page helpful?
You can also Contact sales or Submit a Ticket for help.
Help us improve! Rate your documentation experience in 5 mins.
Feedback