tencent cloud

PrevNext

Feedback

search by keyword

Recent Pages

Documentation
TDSQL-C for MySQL
    Documentation
    Download PDF

    Viewing and Changing the Access Policy

    Last updated: 2024-03-25 17:53:53
    Download PDF
      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.

      Contact Us
      Technical Support

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

      Submit a Ticket
      7x24 Phone Support
      Copyright © 2013-2024 Tencent Cloud. All Rights Reserved.
      Privacy PolicyLegalCookie Policy