You can call the ModifyReadWriteSplittingConnection operation to modify the latency threshold that is allowed by the read/write splitting link and the read weights of a primary ApsaraDB RDS instance and its read-only instances.
Before you call this operation, make sure that the following requirements are met:
- The shared proxy feature must be enabled for the primary instance.
- The read/write splitting feature must be enabled for the primary instance.
- The primary instance must run one of the following database engine versions and RDS
editions:
- MySQL 5.7 on RDS High-availability Edition (with local SSDs)
- MySQL 5.6
- SQL Server 2017 on RDS Cluster Edition
Debugging
Request parameters
Parameter | Type | Required | Example | Description |
---|---|---|---|---|
Action | String | Yes | ModifyReadWriteSplittingConnection |
The operation that you want to perform. Set the value to ModifyReadWriteSplittingConnection. |
DBInstanceId | String | Yes | rm-uf6wjk5xxxxxxx |
The ID of the primary instance. |
ConnectionStringPrefix | String | No | rm-m5xxxxxxxxrw.mysql.rds.aliyuncs.com |
The prefix of the read/write splitting endpoint. The prefix must be unique. It can be up to 30 characters in length and can contain lowercase letters and hyphens (-). It must start with a lowercase letter. Note The default prefix consists of the name of the primary instance followed by the letters
rw.
|
Port | String | No | 3306 |
The port that is associated with the read/write splitting endpoint. |
MaxDelayTime | String | No | 12 |
The latency threshold that is allowed by the read/write splitting link. Unit: seconds. If the latency on a read-only instance exceeds the specified threshold, ApsaraDB RDS no longer routes read requests to the read-only instance. If you do not specify this parameter, the original value is retained. Note
|
DistributionType | String | No | Standard |
The method that is used to assign read weights. Valid values:
Note You must specify at least one of the following parameters: MaxDelayTime and DistributionType.
|
Weight | String | No | {"Instanceid1":"100","Instanceid2":"200"} |
The read weights of the primary instance and its read-only instances. A read weight must be a multiple of 100 and cannot exceed 10000. Format: {"Instanceid1":"Weight","Instanceid2":"Weight"...}. Note
|
Response parameters
Parameter | Type | Example | Description |
---|---|---|---|
RequestId | String | 5A77D650-27A1-4E08-AD9E-59008EDB6927 |
The ID of the request. |
Examples
Sample requests
http(s)://rds.aliyuncs.com/? Action=ModifyReadWriteSplittingConnection
&DistributionType=Standard
&DBInstanceId=rm-uf6wjk5xxxxxxx
&<Common request parameters>
Sample success responses
XML
format
<ModifyReadWriteSplittingConnectionResponse>
<RequestID>5A77D650-27A1-4E08-AD9E-59008EDB6927</RequestID>
</ModifyReadWriteSplittingConnectionResponse>
JSON
format
{
"RequestID":"5A77D650-27A1-4E08-AD9E-59008EDB6927"
}
Error codes
For a list of error codes, visit the API Error Center.