tencent cloud

Feedback

Access Mode

Last updated: 2024-03-25 16:16:49
    This document describes the access modes of the TDSQL-C for MySQL database proxy.

    Prerequisites

    You have enabled database proxy. For details, see Enabling Database Proxy.

    Overview

    There are two access modes available to manage the connection between the client application and the database: Balanced Distribution and Nearby Access. The following sections detail the rules, advantages, and disadvantages of the two access modes.

    Balanced Distribution

    
    Rule: In the Balanced Distribution access mode, the client application connects to all available database proxy nodes. If the database proxy nodes are spread across multiple availability zones, application connections to the database are evenly distributed among all availability zone nodes.
    Advantage: Traffic is evenly distributed, resolving the issue of excessive load on a single node.
    Disadvantage: If there are proxy nodes in different availability zones, high request latency is prone to occur due to extended access paths.

    Nearby Access

    
    Rule: In the Nearby Access mode, the application will connect to the proxy node in the same availability zone or the one with the shortest access path. Even if the database proxy nodes are spread across multiple availability zones, the application will still connect the proxy node with the shortest access path.
    Advantage: Low access latency and high speed.
    Disadvantage: If your client application changes to an availability zone with fewer database proxy nodes than the original zone, it can lead to excessive load on the nodes and performance delays.

    Changing Access Mode

    The access mode can be changed. For details, see Viewing and Changing the Access Policy.
    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