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.
Before calling this API, learn about request header parameters.

URI

URI format
GET /v3/{project_id}/flavors/{database_name}?version_name={version_name}&spec_code={spec_code}

Parameter description

**Table 1** Parameters
Parameter	Mandatory	Description
project_id	Yes	Definition Project ID of a tenant in a region. For details about how to obtain the project ID, see Obtaining a Project ID. Constraints N/A Range N/A Default Value N/A
database_name	Yes	Definition DB engine name. Constraints N/A Range MySQL PostgreSQL SQLServer Default Value N/A
version_name	No	Definition Database version. For details about how to obtain the database version, see section Querying Version Information About a DB Engine. Constraints N/A Range N/A Default Value N/A
spec_code	No	Definition Specification code. Constraints N/A Range N/A Default Value N/A

Request

Request parameters
None

URI example
GET https://{endpoint}/v3/0483b6b16e954cb88930a360d2c4e663/flavors/mysql?version_name=5.7&spec_code=rds.mysql.m1.xlarge.rr

Response

Normal response

**Table 2** Parameters
Parameter	Type	Description
flavors	Array of objects	Definition DB instance specifications information list. For details, see Table 3.

**Table 3** flavors field data structure description
Parameter	Type	Description
vcpus	String	Definition Number of vCPUs. For example, the value 1 indicates 1 vCPU. Range N/A
ram	Integer	Definition Memory size in GB. Range N/A
spec_code	String	Definition 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). Range N/A
instance_mode	String	Definition Instance type. Range ha indicates primary/standby instances. replica indicates read replicas. single indicates single DB instances.
az_status	Map<String, String>	Definition Specification status in an AZ. Range normal: The specifications in the AZ are available. unsupported: The specifications are not supported by the AZ. sellout: 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"
		}
	}]
}