Help Center> Relational Database Service> API Reference> API v3 (Recommended)> Database Proxy (PostgreSQL)> Changing the Delay Threshold of Read/Write Splitting
View PDF

Changing the Delay Threshold of Read/Write Splitting

Function

This API is used to modify the delay threshold of read/write splitting in a specified DB instance.

Constraints

  • Only PostgreSQL 11 and PostgreSQL 12 are supported.
  • The database proxy of DB instance has been enabled.

URI

  • URI format

    PUT https://{Endpoint}/v3/{project_id}/instances/{instance_id}/proxy/delay-threshold

  • Example

    https://rds.cn-north-1.myhuaweicloud.com/v3/0483b6b16e954cb88930a360d2c4e663/instances/cee5265e1e5845649e354841234567dfin01/proxy/delay-threshold

  • Parameter description
    Table 1 Parameter description

    Name

    Mandatory

    Description

    project_id

    Yes

    Specifies the project ID of a tenant in a region.

    For details about how to obtain the project ID, see Obtaining a Project ID.

    instance_id

    Yes

    Specifies the DB instance ID.

Request

  • Parameter description
    Table 2 Parameter description

    Name

    Mandatory

    Type

    Description

    delay_threshold_in_kilobytes

    Yes

    Integer

    Specifies the delay threshold in KB. It can be a value from 0 to 10485760.
  • Request example 
    {
    "delay_threshold_in_kilobytes":30
}

Response

  • Normal response
    Table 3 Parameter description

    Name

    Type

    Description

    result

    String

    Indicates the modified result of the delay threshold of read/write splitting.
  • Example normal response 
    {
 "result":"success"
}

Status Code

For details, see Status Codes.

Error Code

For details, see Error Codes.