tencent cloud

Feedback

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.
    Contact Us

    Contact our sales team or business advisors to help your business.

    Technical Support

    Open a ticket if you're looking for further assistance. Our Ticket is 7x24 avaliable.

    7x24 Phone Support