tencent cloud

Feedback

Adjusting Database Proxy Configuration

Last updated: 2023-01-12 15:35:18

    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 SpecificationAZNode QuantityLoad Balancing ModeSwitch TimeImpact
    Upgrade or downgradeUnchangedUnchangedAutomaticDuring maintenance timeThere will be a momentary disconnection lasting seconds. Make sure that your business has a reconnection mechanism.
    Upon upgrade completion
    ManualDuring maintenance time
    Upon upgrade completion

    Scenario 2: Changing the node quantity but not proxy specification or AZ

    Proxy SpecificationAZNode QuantityLoad Balancing ModeSwitch TimeImpact
    UnchangedUnchangedIncreasedAutomaticDuring maintenance timeThere 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.
    DecreasedAutomaticDuring maintenance timeThere will be a momentary disconnection lasting seconds. Make sure that your business has a reconnection mechanism.
    Upon upgrade completion
    ManualDuring maintenance time
    Upon upgrade completion

    Scenario 3: Changing the AZ and node quantity but not proxy specification

    Proxy SpecificationAZNode QuantityLoad Balancing ModeSwitch TimeImpact
    UnchangedIncreasedIncreasedAutomaticDuring maintenance timeThere 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.
    DecreasedAutomaticDuring maintenance timeThere will be a momentary disconnection lasting seconds. Make sure that your business has a reconnection mechanism.
    Upon upgrade completion
    ManualDuring maintenance time
    Upon upgrade completion
    DecreasedIncreasedAutomaticDuring maintenance time
    Upon upgrade completion
    ManualDuring maintenance time
    Upon upgrade completion
    DecreasedAutomaticDuring maintenance time
    Upon upgrade completion
    ManualDuring maintenance time
    Upon upgrade completion
    ChangedIncreasedAutomaticDuring maintenance time
    Upon upgrade completion
    ManualDuring maintenance time
    Upon upgrade completion
    DecreasedAutomaticDuring maintenance time
    Upon upgrade completion
    ManualDuring 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