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. |
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. |
Was this page helpful?