Querying Database Specifications¶
Function¶
This API is used to query the database specifications of a specified DB engine version. Before calling this API:
Learn how to authorize and authenticate it.
Obtain the required region and endpoint.
URI¶
GET /v3/{project_id}/flavors/{database_name}?availability_zone_mode={availability_zone_mode}
Parameter  | Mandatory  | Type  | Description  | 
|---|---|---|---|
project_id  | Yes  | String  | Project ID of a tenant in a region. To obtain this value, see Obtaining a Project ID.  | 
database_name  | Yes  | String  | DB engine.  | 
Parameter  | Mandatory  | Type  | Description  | 
|---|---|---|---|
version_name  | No  | String  | DB version number. To obtain this value, see Querying Version Information About a DB Engine. Currently, only MySQL 8.0 is supported.  | 
availability_zone_mode  | Yes  | String  | AZ mode. Its value can be single or multi and is case-insensitive.  | 
spec_code  | No  | String  | Specification code.  | 
Request Parameters¶
Parameter  | Mandatory  | Type  | Description  | 
|---|---|---|---|
X-Auth-Token  | Yes  | String  | User token.  | 
X-Language  | No  | String  | Language.  | 
Response Parameters¶
Status code: 200
Parameter  | Type  | Description  | 
|---|---|---|
flavors  | Array of MysqlFlavorsInfo objects  | DB instance specifications.  | 
Parameter  | Type  | Description  | 
|---|---|---|
vcpus  | String  | Number of vCPUs. For example, the value 1 indicates 1 vCPU.  | 
ram  | String  | Memory size in GB.  | 
type  | String  | Specification type. The value is x86.  | 
id  | String  | Specification ID. The value must be unique.  | 
spec_code  | String  | Resource specification code. Its value is same as the value of flavor_ref. Example: gaussdb.mysql.xlarge.x86.8.  | 
version_name  | String  | DB version number.  | 
instance_mode  | String  | DB instance type. Currently, its value can only be Cluster.  | 
az_status  | Map<String,String>  | Specification status in an AZ. 
  | 
Status code: 400
Parameter  | Type  | Description  | 
|---|---|---|
error_code  | String  | Error code.  | 
error_msg  | String  | Error message.  | 
Status code: 500
Parameter  | Type  | Description  | 
|---|---|---|
error_code  | String  | Error code.  | 
error_msg  | String  | Error message.  | 
Example Request¶
GET https://gaussdb-mysql.eu-de.otc.t-systems.com/v3/0483b6b16e954cb88930a360d2c4e663/flavors/gaussdb-mysql?version_name=8.0&spec_code=gaussdb.mysql.xlarge.x86.8&availability_zone_mode=single
Example Response¶
Status code: 200
Success.
{
  "flavors" : [ {
    "vcpus" : "4",
    "ram" : "32",
    "type" : "x86",
    "id" : "3169caaf-6c2f-41d5-aadd-c8fc3d83597e",
    "spec_code" : "gaussdb.mysql.xlarge.x86.8",
    "instance_mode" : "Cluster",
    "version_name" : "8.0",
    "az_status" : {
      "eu-de-01" : "normal",
      "eu-de-02" : "normal"
    }
  } ]
}
Status Code¶
For details, see Status Codes.
Error Code¶
For details, see Error Codes.