tencent cloud

Adjusting Database Proxy Configuration
Last updated: 2024-07-22 15:17:32
Adjusting Database Proxy Configuration
Last updated: 2024-07-22 15:17:32
This document describes how to adjust the database proxy configuration in the console, including the proxy specification, AZ, and node quantity.

Prerequisites

You have enabled the database proxy. For more information, see Enabling Database Proxy.

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 Configurations.


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.
Was this page helpful?
You can also Contact Sales or Submit a Ticket for help.
Yes
No

Feedback