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

Querying Database Specifications

Function

This API is used to query the database specifications of a specified DB engine version.

URI

  • URI format

    GET https://{Endpoint}/v3/{project_id}/flavors/{database_name}?version_name={version_name}&spec_code={spec_code}

  • Example

    https://rds.cn-north-1.myhuaweicloud.com/v3/0483b6b16e954cb88930a360d2c4e663/flavors/mysql?version_name=5.7&spec_code=rds.mysql.m1.xlarge.rr

  • 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.

    database_name

    Yes

    Specifies the DB engine name. Its value can be any of the following and is case-insensitive:

    • MySQL
    • PostgreSQL

    version_name

    No

    Specifies the database version. For details about how to obtain the database version, see section Querying Version Information About a DB Engine.

    spec_code

    No

    Specifies the specification code.

Request

None

Response

  • Normal response
    Table 2 Parameter description

    Name

    Type

    Description

    flavors

    Array of objects

    Indicates the DB instance specifications information list.

    For details, see Table 3.

    Table 3 flavors field data structure description

    Name

    Type

    Description

    vcpus

    String

    Indicates the CPU size. For example, the value 1 indicates 1 vCPU.

    ram

    Integer

    Indicates the memory size in GB.

    spec_code

    String

    Indicates the resource specification code. Use rds.mysql.m1.xlarge.rr as an example.

    • rds: indicates the RDS product.
    • mysql: indicates the DB engine.
    • m1.xlarge: indicates the high memory performance specifications.
    • rr: indicates the read replica (.ha indicates primary/standby DB instances).

    instance_mode

    String

    Indicates the DB instance type. Its value can be any of the following:

    • ha: indicates primary/standby DB instances.
    • replica: indicates read replicas.
    • single: indicates single DB instances.

    az_status

    Map<String, String>

    Indicates the status of the AZ to which the DB instance specifications belong. Its value can be any of the following:

    • normal: indicates that the AZ is on sale.
    • unsupported: indicates that the DB instance specifications are not supported by the AZ.
    • sellout: indicates that the DB instance specifications are sold out.
  • Example normal response
    {
    	"flavors": [{
    		"vcpus": "1",
    		"ram": 2,
    		"spec_code": "rds.mysql.c2.medium.ha",
    		"instance_mode": "ha",
    		"az_status": {
    			"az1": "normal",
    			"az2": "normal"
    		}
    	}, {
    		"vcpus": "1",
    		"ram": 2,
    		"spec_code": "rds.mysql.c2.medium.rr",
    		"instance_mode": "replica",
    		"az_status": {
    			"az1": "normal",
    			"az2": "normal"
    		}
    	}]
    }
  • Abnormal response

    For details, see Abnormal Request Results.

Status Code

For details, see Status Codes.

Error Code

For details, see Error Codes.