TencentDB for MySQL supports flexible scaling that allows you to quickly adjust instance specification in the console. You can do so at any time (at the start, during rapid development, or during peak/off-peak hours), so you can get the most out of your resources and reduce unnecessary costs in real time. For more information, see Instance Adjustment Fee.
Note:You can view disk space on the instance details page in the MySQL console, or receive disk alarms by configuring [Alarm Policies (TCOP)(https://www.tencentcloud.com/document/product/236/8457).
By default, the instance configuration is adjusted in the normal mode, which requires a data migration for the adjustment to complete after you adjust the instance configuration in the console. But if the physical machine where the instance is located has sufficient remaining resources (aka local resources), you can choose the QuickChange mode. The adjustment process is as follows:
Note:If the local resources are sufficient and meet the conditions of the QuickChange mode, this mode will be used by default. If you don't need to use it, you can disable it by toggling it off on the configuration adjustment page.
Isolation Policy | CPU and Memory | Maximum IOPS | Storage Space |
---|---|---|---|
General | 1-core 1000 MB MEM | 1200 | 25–3000 GB |
1-core 2000 MB MEM | 2000 | ||
2-core 4000 MB MEM | 4000 | ||
4-core 8000 MB MEM | 8000 | ||
4-core 16000 MB MEM | 14000 | 25–4000 GB | |
8-core 16000 MB MEM | 20000 | ||
8-core 32000 MB MEM | 28000 | ||
16-core 32000 MB MEM | 32000 | ||
16-core 64000 MB MEM | 40000 | ||
16-core 96000 MB MEM | 40000 | ||
16-core 128000 MB MEM | 40000 | 25–8000 GB | |
24-core 244000 MB MEM | 60000 | ||
32-core 256000 MB MEM | 80000 | ||
48-core 488000 MB MEM | 120000 | 25–12000 GB | |
Dedicated | 2-core 16000 MB MEM | 8000 | 25–3000 GB |
4-core 16000 MB MEM | 10000 | ||
4-core 24000 MB MEM | 13000 | ||
4-core 32000 MB MEM | 16000 | ||
8-core 32000 MB MEM | 32000 | ||
8-core 48000 MB MEM | 36000 | ||
8-core 64000 MB MEM | 40000 | ||
12-core 48000 MB MEM | 36000 | 25–4000 GB | |
16-core 64000 MB MEM | 60000 | ||
12-core 72000 MB MEM | 40000 | ||
12-core 96000 MB MEM | 48000 | ||
16-core 96000 MB MEM | 60000 | ||
24-core 96000 MB MEM | 72000 | ||
16-core 128000 MB MEM | 60000 | ||
32-core 128000 MB MEM | 80000 | ||
24-core 144000 MB MEM | 76000 | ||
24-core 192000 MB MEM | 80000 | ||
32-core 192000 MB MEM | 90000 | ||
48-core 192000 MB MEM | 120000 | ||
32-core 256000 MB MEM | 100000 | ||
48-core 288000 MB MEM | 140000 | ||
48-core 384000 MB MEM | 140000 | ||
64-core 256000 MB MEM | 150000 | 25–9000 GB | |
64-core 384000 MB MEM | 150000 | ||
64-core 512000 MB MEM | 150000 | 25–12000 GB | |
90-core 720000 MB MEM | 150000 |
Note:The storage space cap of an instance specification may vary by region as displayed on the purchase page.
Note:
- When the local resources are sufficient, you can enable the QuickChange mode by turning on the QuickChange toggle on the configuration adjustment page in the console.
- In some cases, instance restart is not required in the QuickChange mode and the configuration adjustment will take effect immediately after you submit the request, as shown below:
You can adjust the instance configuration using the UpgradeDBInstance
API. For more information, see UpgradeDBInstance.
It may be because the used storage capacity has reached the maximum capacity of the hard disk. To downgrade you instance, you need to clean up data first and make sure the remaining available capacity accounts for more than 20% of the total capacity or over 50 GB.
It may be because you select During maintenance time as the Switch Time when you adjust instance configuration in the console, so the instance will not be switched immediately after the adjustment.
To switch immediately, find the target instance in the instance list and click Switch Now in the Operation column. The switch will cause a momentary disconnection. Make sure that your business has a reconnection mechanism.
The time it takes depends on the instance's data volume and data replication speed.
Instances can still be accessed during the upgrade, but after the upgrade is completed, there is a VIP switch which causes a short disconnection lasting for just seconds.
You can view the progress in Task List in the console.
If over 85% disk space is used, we recommend that you delete data no longer used or expand disk space in the console by selecting More > Adjust Configurations in the Operation column on the right of the instance list.
On the configuration adjustment page, if the QuickChange mode is supported, the QuickChange toggle can be turned on or off as needed; otherwise, the toggle cannot be used.
If the kernel minor version of the instance is not the latest when memory or disk capacity is expanded, it will be upgraded to the latest. In this case, enabling the QuickChange mode will cause the database to restart.
The instance needs to be restarted in some cases. A prompt will appear asking if you want to restart the instance on the configuration adjustment page.
Note:If the instance is running the latest kernel minor version, it won’t restart if you only adjust the disk capacity in the QuickChange mode.
You can check the QuickChange switch on the configuration adjustment page: if the switch is toggled on, the QuickChange mode is enabled; otherwise, the mode is disabled.
APIs do not support QuickChange for the time being, so instance configuration can be adjusted only by migrating data if you use APIs. APIs will support QuickChange in the future.
The innodb_buffer_pool_size
parameter will be modified according to the configuration changes.
It is the same with the normal mode. In the QuickChange mode, some parameters will be modified according to the configuration changes.
The QuickChange mode requires no data migration, so it takes less time to adjust instance configuration.
Was this page helpful?