tencent cloud

Feedback

Viewing and Changing the Access Policy

Last updated: 2024-03-25 17:53:53
    After database proxy is enabled for TDSQL-C for MySQL, a database proxy address will be added by default. You can also add addresses later to implement different business logics. The number of proxy addresses that can be created is the same as that of database proxy nodes. You can view and change the access policy of these addresses in the console.

    Prerequisites

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

    Viewing the Access Policy

    1. Log in to the TDSQL-C for MySQL console. In the cluster list, select the cluster with the proxy enabled and click its ID to navigate to the Cluster Management page.
    2. On the Cluster Management page, click Cluster Details > Details to open the Database Proxy Management page. Alternatively, you can directly enter the Database Proxy Management page by selecting Database Proxy on the Cluster Management page.
    3. On the Database Proxy management page, choose Database Proxy > Access Policy.
    

    Changing the Access Policy

    1. Log in to the TDSQL-C for MySQL console. In the cluster list, select the cluster with the proxy enabled and click its ID to navigate to the Cluster Management page.
    2. On the Cluster Management page, click Cluster Details > Details to open the Database Proxy Management page. Alternatively, you can directly enter the Database Proxy Management page by selecting Database Proxy on the Cluster Management page.
    3. On the Database Proxy Management page, select Access Policy, find the target access policy, and click Adjust Configuration.
    Note:
    You can also find the target proxy address in Database Proxy > Overview > Connection Address. Then, click Adjust Configurations in the Operation column.
    4. In the pop-up window, change the policy configuration and click OK.
    Step 1. Configure the policy
    
    Parameter
    Description
    Read/Write Attribute
    Choose the read/write attribute for this proxy address: Read/Write Separation or Read-Only. If you select Read/Write Separation, the feature will be enabled automatically.
    Access Mode
    There are two access modes available to manage the connection between the client application and the database: Balanced Distribution and Nearby Access. For details, see Access Mode.
    Consistency Settings
    Under the Read-Write Separation Attribute, three consistency levels are provided: Eventual Consistency, Session Consistency, and Global Consistency, to meet your consistency requirements in different scenarios. For more information, see Consistency Level.
    Connection Pool Status
    Connection pooling shares connections across different user requests to reduce the instance load caused by frequent creation of new connections. Enabling this feature allows you to choose a supported connection pool type, with Session-Level Connection Pool as the default.
    Connection Pool Threshold
    Configure the Connection Pool Threshold. The valid range is between 0 to 300 seconds.
    Transaction Split
    You can enable this feature to separate reads and writes in a transaction, directing them to different instances for execution. Read requests will be forwarded to read-only instances, effectively reducing the load on the read-write instance.
    Failover (For instances with read/write separation)
    ‌You can enable this feature to ensure that in the event of a failure in the database proxy, the address will be routed to the read/write separation instance.
    Apply to Newly Added RO Instances
    ‌‌You can enable this feature to automatically add newly purchased read-only instances to the database proxy.If Assign Read Weight is set to Assigned by system, newly purchased read-only instances will be assigned with the default weight based on their specification.If Assign Read Weight is set to Custom, when newly purchased read-only instances are added to the RO group, their weights will be 0 by default. You can change the weight on the Configure Weight page.
    Step 2: Configure the Weight
    
    Parameter
    Description
    Assign Read Weight
    You can select Assigned by system or Custom. If Custom is selected, you can separately assign the weights of different instances.
    Note:
    The weight here refers to the distribution policy for read request (non-transactional) weights.
    
    
    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