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¶
URI format
GET https://{endpoint}/mysql/v3/{project_id}/flavors/{database_name}?version_name={version_name}&spec_code={spec_code}&availability_zone_mode={availability_zone_mode}
Example
Parameter description
Table 1 Parameter description¶ Name
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. Its value is case-insensitive and can be:
gaussdb-mysql
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.  | 
Content-Type  | Yes  | String  | MIME type of the request body. You are advised to use the default value application/json. For APIs used to upload objects or images, the value can vary depending on the flow type.  | 
Response Parameters¶
Status code: 202
Parameter  | Type  | Description  | 
|---|---|---|
flavors  | Array of MysqlFlavorsInfo objects  | 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, only the cluster type is supported.  | 
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/mysql/v3/0483b6b16e954cb88930a360d2c4e663/flavors/gaussdb-mysql
Example Response¶
Status code: 202
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"
    }
  } ]
}
Status Code¶
For details, see Status Codes.
Error Code¶
For details, see Error Codes.