Updated on 2024-06-07 GMT+08:00

Setting the Local Retention Period of Binlogs

Function

This API is used to set the local retention period of binlogs.

  • Before calling an API, you need to understand the API in Authentication.

Constraints

  • The local retention period of binlogs cannot be set during the DB instance creation.
  • This API is supported for RDS for MySQL DB instances only.

URI

  • URI format

    PUT /v3/{project_id}/instances/{instance_id}/binlog/clear-policy

  • Parameter description
    Table 1 Parameter description

    Name

    Mandatory

    Description

    project_id

    Yes

    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

Table 2 Parameter description

Name

Mandatory

Type

Description

binlog_retention_hours

Yes

Integer

Specifies the binlog retention period.

Value range: 0 to 168 (7x24)

Example Request

Set the local retention period of binlogs to 3 hours.
PUT https://{endpoint}/v3/0483b6b16e954cb88930a360d2c4e663/instances/fa60258325f6424ca1ba28653629d7b1in01/binlog/clear-policy

{
     "binlog_retention_hours": 3
}

Response

  • Normal response
    Table 3 Parameter description

    Name

    Type

    Description

    resp

    String

    Returns successful if the invoking is successful.

Status Code

Error Code

For details, see Error Codes.