Querying Database Specifications

Function

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

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

URI

URI format
GET /v3/{project_id}/flavors/{database_name}?version_name={version_name}
Example
https://{Endpoint}/v3/0483b6b16e954cb88930a360d2c4e663/flavors/mysql?version_name=5.7

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 read replicas (.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 instances. replica: indicates read replicas. single: indicates single DB instances.
az_status	Map<String, String>	Indicates the specification status in an AZ. Its value can be any of the following: normal: indicates that the specifications in the AZ are available. unsupported: indicates that the specifications are not supported by the AZ. sellout: indicates that the specifications in the AZ 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"
		}
	}]
}