Updated on 2022-02-22 GMT+08:00

Changing DB Instance Specifications

Function

This API is used to change DB instance specifications.

Services will be interrupted for 5 to 10 minutes when you change DB instance specifications. Exercise caution when performing this operation.

Constraints

  • The new DB instance specifications must be different from the original DB instance specifications.
  • The instance class can be modified only for DB instances whose status is Available.
  • The specifications of a DB instance can be changed only to the specifications of the same DB instance type. (For example, the specifications of a single DB instance cannot be changed to those of primary/standby DB instances.)

URI

  • URI format

    POST https://{Endpoint}/v3/{project_id}/instances/{instance_id}/action

  • 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

    resize_flavor

    Yes

    Object

    For details, see Table 3.

    Table 3 resize_flavor field data structure description

    Name

    Mandatory

    Type

    Description

    spec_code

    Yes

    String

    Specifies the resource specification code. Use rds.mysql.m1.xlarge as an example. rds indicates RDS, mysql indicates the DB engine, and m1.xlarge indicates the performance specification (large-memory). The parameter containing rr indicates the read replica specifications. The parameter not containing rr indicates the single or primary/standby DB instance specifications.

    • Request example

      MySQL:

      {
      	"resize_flavor": {
      		"spec_code": "rds.mysql.m1.xlarge"
                
      	}
      }

      PostgreSQL:

      {
      	"resize_flavor": {
      		"spec_code": "rds.pg.c2.medium.ha"
                
      	}
      }

      Microsoft SQL Server:

      {
      	"resize_flavor": {
      		"spec_code": "rds.mssql.2014.se.s3.large.2"
                
      	}
      }

Response

  • Pay-per-use
    • Normal response
      Table 4 Parameter description

      Name

      Type

      Description

      job_id

      String

      Indicates the task ID.

    • Example normal response
      {
      	"job_id": "2b414788a6004883a02390e2eb0ea227"
      }
    • Abnormal response

      For details, see Abnormal Request Results.

  • Yearly/Monthly
    • Normal response
      Table 5 Parameter description

      Name

      Type

      Description

      order_id

      String

      Indicates the order ID.

    • Example normal response
      {
      	"order_id": "CS2009151216NO2U1"
      }
    • Abnormal response

      For details, see Abnormal Request Results.

Status Code

For details, see Status Codes.

Error Code

For details, see Error Codes.