This document describes how to change instance specifications in the TDSQL console. You can expand the capacity of specified shards by changing their node specifications to improve the business processing performance.
- You can still use the old instance as usual during the adjustment.
- The name, access IP, and access port of an instance will remain the same after the adjustment; however, the SQL passthrough ID (Setid) will change.
- When the adjustment is completed, the database will be disconnected for several seconds. We recommend that you implement an automatic reconnection feature in your program.
- During the adjustment, try avoiding operations such as modifying global parameters, instance name, or user password of the database.
Scheduled switch: You can choose to switch the database to its new configuration at a specified time, which is usually during off-peak hours and must be within 72 hours.
- Generally, the switch time has a deviation of about 15 minutes, as there may be high amounts of write requests to large transactions, which will affect the data sync progress. In this case, the system will first guarantee sync between the new and old instances instead of performing the scheduled switch.
- To ensure a successful switch, you can select the option for retry upon failure, and the system will try switching again two hours after a switch failure.
If you upgrade a database instance, the price difference between original and upgraded specifications is deducted from your account. If the account balance is insufficient, you need to top it up.
*Upgrade fees = (price of target specification - price of original specification) * remaining validity period*