All Products
Search
Document Center

Data Management:GetInstance

Last Updated:Oct 21, 2024

Queries the details of a database instance.

Debugging

You can run this interface directly in OpenAPI Explorer, saving you the trouble of calculating signatures. After running successfully, OpenAPI Explorer can automatically generate SDK code samples.

Authorization information

There is currently no authorization information disclosed in the API.

Request parameters

ParameterTypeRequiredDescriptionExample
TidlongNo

The ID of the tenant. You can call the GetUserActiveTenant operation to obtain the tenant ID.

2***
HoststringYes

The endpoint of the database instance. You can call the ListInstances operation to obtain the endpoint.

172.17.XXX.XXX
PortintegerYes

The port number that is used to connect to the database instance. You can call the ListInstances operation to obtain the port number.

5432
SidstringNo

The system ID (SID) of the database instance. You can call the ListInstances operation to obtain the SID.

test

Response parameters

ParameterTypeDescriptionExample
object
RequestIdstring

The ID of the request.

F6C80B69-3203-56AC-8021-18BA72A6F4E1
Instanceobject

The details of the database instance.

VpcIdstring

The ID of the virtual private cloud (VPC) to which the database instance belongs.

vpc-o6wrloqsdqc9io3mg****
DatabaseUserstring

The account that is used to log on to the database instance.

dbuser
DbaIdstring

The ID of the database administrator (DBA) for the database instance.

29****
UseDsqlinteger

Indicates whether the cross-database query feature is enabled for the database instance. Valid values:

  • 0: disabled
  • 1: enabled
0
Portinteger

The port number that is used to connect to the database instance.

5432
EcsInstanceIdstring

The ID of the Elastic Compute Service (ECS) instance on which the database instance is deployed.

i-bp124ldpklqz59y3****
EnvTypestring

The type of the environment to which the database instance belongs. Valid values:

  • product: production environment
  • dev: development environment
  • pre: staging environment
  • test: test environment
  • sit: system integration testing (SIT) environment
  • uat: user acceptance testing (UAT) environment
  • pet: stress testing environment
  • stag: STAG environment
test
Sidstring

The SID of the database instance.

test
OwnerIdListarray

The IDs of the owners for the database instance.

OwnerIdsstring

The ID of the instance Owner.

10****
SafeRuleIdstring

The ID of the security rule set for the database instance.

3****
OwnerNameListarray

The nicknames of the owners for the database instance.

OwnerNamesstring

The nickname of the instance Owner.

yang_test
DbaNickNamestring

The nickname of the DBA for the database instance.

dbaname
QueryTimeoutinteger

The timeout period for querying data in the database instance.

7200
InstanceSourcestring

The source of the database instance.

ECS_OWN
Hoststring

The host address that is used to connect to the database instance.

192.168.XXX.XXX
Statestring

The status of the database instance. Valid values:

  • NORMAL: normal
  • DISABLE: disabled
NORMAL
DataLinkNamestring

The name of the database link for the database instance.

test
ExportTimeoutinteger

The timeout period for exporting data from the database instance.

86400
InstanceIdstring

The ID of the database instance.

188****
InstanceTypestring

The type of the database instance.

postgresql
DatabasePasswordstring

The password that is used to log on to the database.

******
InstanceAliasstring

The alias of the database instance.

test
DdlOnlineinteger

Indicates whether the lock-free schema change feature is enabled for the database instance.

0
EcsRegionstring

The ID of the region in which the database instance resides.

cn-beijing
StandardGroupobject

The control mode of the database instance.

GroupNamestring

The name of the security rule set corresponding to the control mode.

test group name
GroupModestring

The type of the control mode. Valid values:

  • COMMON: Security Collaboration
  • NONE_CONTROL: Flexible Management
  • STABLE: Stable Change
NONE_CONTROL
SellSitdstring

Whether sensitive data protection is enabled. Valid values:

  • true: Enable.

  • false: Close.

false
ErrorCodestring

The error code that is returned.

UnknownError
ErrorMessagestring

The error message that is returned.

UnknownError
Successboolean

Indicates whether the request was successful. Valid values:

  • true: The request was successful.
  • false: The request failed.
true

Examples

Sample success responses

JSONformat

{
  "RequestId": "F6C80B69-3203-56AC-8021-18BA72A6F4E1",
  "Instance": {
    "VpcId": "vpc-o6wrloqsdqc9io3mg****",
    "DatabaseUser": "dbuser",
    "DbaId": "29****",
    "UseDsql": 0,
    "Port": 5432,
    "EcsInstanceId": "i-bp124ldpklqz59y3****",
    "EnvType": "test",
    "Sid": "test",
    "OwnerIdList": {
      "OwnerIds": [
        "10****"
      ]
    },
    "SafeRuleId": "3****",
    "OwnerNameList": {
      "OwnerNames": [
        "yang_test"
      ]
    },
    "DbaNickName": "dbaname",
    "QueryTimeout": 7200,
    "InstanceSource": "ECS_OWN",
    "Host": "192.168.XXX.XXX",
    "State": "NORMAL",
    "DataLinkName": "test",
    "ExportTimeout": 86400,
    "InstanceId": "188****",
    "InstanceType": "postgresql",
    "DatabasePassword": "******",
    "InstanceAlias": "test",
    "DdlOnline": 0,
    "EcsRegion": "cn-beijing",
    "StandardGroup": {
      "GroupName": "test group name",
      "GroupMode": "NONE_CONTROL"
    },
    "SellSitd": "false"
  },
  "ErrorCode": "UnknownError",
  "ErrorMessage": "UnknownError",
  "Success": true
}

Error codes

For a list of error codes, visit the Service error codes.

Change history

Change timeSummary of changesOperation
No change history