Adjusting Database Proxy Configuration
This document describes how to adjust the database proxy configuration in the console, including the proxy specification, AZ, and node quantity.
Prerequisites
Notes
The database proxy will be automatically upgraded to the latest version during configuration adjustment if its version is old.
If the selected proxy and the source instance are not in the same AZ and you access the instance through the proxy, the write performance will be reduced.
If the recommended number of proxy nodes you calculated exceeds the maximum purchasable quantity, choose a higher proxy node specification.
If resources are sufficient in the region, you can select up to three AZs and need to retain at least one AZ (the one in the first row).
Impact description
Changing different configuration items has different impacts, some of which will not cause a momentary disconnection, while some will. The specific change items and their impacts are as detailed below:
Scenario 1: Changing the proxy specification but not AZ or node quantity
Proxy Specification | AZ | Node Quantity | Load Balancing Mode | Switch Time | Impact |
Upgrade or downgrade | Unchanged | Unchanged | Automatic | During maintenance time | There will be a momentary disconnection lasting seconds. Make sure that your business has a reconnection mechanism. |
| | | | | Upon upgrade completion |
| | | | Manual | During maintenance time |
| | | | | Upon upgrade completion |
Scenario 2: Changing the node quantity but not proxy specification or AZ
Proxy Specification | AZ | Node Quantity | Load Balancing Mode | Switch Time | Impact |
Unchanged | Unchanged | Increased | Automatic | During maintenance time | There will be a momentary disconnection lasting seconds. Make sure that your business has a reconnection mechanism. |
| | | | | Upon upgrade completion |
| | | Manual | - | There will be no momentary disconnections. |
| | Decreased | Automatic | During maintenance time | There will be a momentary disconnection lasting seconds. Make sure that your business has a reconnection mechanism. |
| | | | | Upon upgrade completion |
| | | | Manual | During maintenance time |
| | | | | Upon upgrade completion |
Scenario 3: Changing the AZ and node quantity but not proxy specification
Proxy Specification | AZ | Node Quantity | Load Balancing Mode | Switch Time | Impact |
Unchanged | Increased | Increased | Automatic | During maintenance time | There will be a momentary disconnection lasting seconds. Make sure that your business has a reconnection mechanism. |
| | | | | Upon upgrade completion |
| | | Manual | - | There will be no momentary disconnections. |
| | Decreased | Automatic | During maintenance time | There will be a momentary disconnection lasting seconds. Make sure that your business has a reconnection mechanism. |
| | | | | Upon upgrade completion |
| | | | Manual | During maintenance time |
| | | | | Upon upgrade completion |
| | Decreased | Increased | Automatic | During maintenance time |
| | | | | Upon upgrade completion |
| | | | Manual | During maintenance time |
| | | | | Upon upgrade completion |
| | | Decreased | Automatic | During maintenance time |
| | | | | Upon upgrade completion |
| | | | Manual | During maintenance time |
| | | | | Upon upgrade completion |
| | Changed | Increased | Automatic | During maintenance time |
| | | | | Upon upgrade completion |
| | | | Manual | During maintenance time |
| | | | | Upon upgrade completion |
| | | Decreased | Automatic | During maintenance time |
| | | | | Upon upgrade completion |
| | | | Manual | During maintenance time |
| | | | | Upon upgrade completion |
Directions
1. Log in to the TencentDB for MySQL console, select the region at the top of the page, and click the ID of the target instance to enter the instance management page.
2. On the instance management page, select the Database Proxy tab.
3. On the Overview tab on the Database Proxy tab, select Basic Info > Node Quantity and click Adjust Specification Configuration.
4. In the pop-up window, modify the proxy specification, AZ, and node quantity of the database proxy as needed and click OK.
5. In Basic Info on the Database Proxy tab, after the task status changes from Upgrading to Running, the configuration adjustment is completed.
Note:
If you select Upon upgrade completion, after the configuration is adjusted, the system will automatically switch to the new configuration.
If you select During maintenance time, after the configuration is adjusted, the system will switch the configuration during the specified maintenance time period.
If you select During maintenance time but need to switch the configuration earlier due to your business requirements, after the configuration is adjusted, you can go to Database Proxy > Overview > Basic Info > Status/Task and click Complete Now after Waiting for switch (after upgrade).
If you select manual rebalance after the configuration adjustment, perform the operation in Overview > Connection Address on the Database Proxy tab after the configuration is adjusted.
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