All Products
Search
Document Center

ApsaraDB for OceanBase:DescribeTenant

Last Updated:Mar 19, 2025

You can call this operation to query the information of a specific tenant in a specific cluster.

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

The following table shows the authorization information corresponding to the API. The authorization information can be used in the Action policy element to grant a RAM user or RAM role the permissions to call this API operation. Description:

  • Operation: the value that you can use in the Action element to specify the operation on a resource.
  • Access level: the access level of each operation. The levels are read, write, and list.
  • Resource type: the type of the resource on which you can authorize the RAM user or the RAM role to perform the operation. Take note of the following items:
    • For mandatory resource types, indicate with a prefix of * .
    • If the permissions cannot be granted at the resource level, All Resources is used in the Resource type column of the operation.
  • Condition Key: the condition key that is defined by the cloud service.
  • Associated operation: other operations that the RAM user or the RAM role must have permissions to perform to complete the operation. To complete the operation, the RAM user or the RAM role must have the permissions to perform the associated operations.
OperationAccess levelResource typeCondition keyAssociated operation
oceanbase:DescribeTenantget
*All Resources
*
    none
none

Request parameters

ParameterTypeRequiredDescriptionExample
InstanceIdstringYes

The ID of the OceanBase cluster.

ob317v4uif****
TenantIdstringYes

The ID of the tenant.

ob2mr3oae0****

Response parameters

ParameterTypeDescriptionExample
object

The details of the tenant.

RequestIdstring

The ID of the request.

EE205C00-30E4-XXXX-XXXX-87E3A8A2AA0C
Tenantobject

The information about the tenant.

TenantIdstring

The ID of the tenant.

t4louaeei****
TenantNamestring

The name of the tenant.

forMySQLTenant
TenantModestring

The mode of the tenant. Valid values:

  • Oracle
  • MySQL
MySQL
VpcIdstring

The Virtual Private Cloud (VPC) ID of the tenant. If no suitable VPC is available, create a VPC as prompted. For more information, see "What is a VPC".

vpc-bp1d2q3mhg9i23ofi****
Statusstring

The status of the tenant.

  • ONLINE: The tenant is running.

  • PENDING_CREATE: The tenant is being created.

  • WAITING_ALLOCATE_MASTER_ADDRESS: The standby cluster is waiting for the primary address to be created.

  • ALLOCATING_MASTER_ADDRESS: The primary address is being created.

  • DELETING_MASTER_ADDRESS: The primary address is being deleted.

  • ALLOCATING_INTERNET_ADDRESS: The Internet address is being created.

  • PENDING_OFFLINE_INTERNET_ADDRESS: The Internet address is being deleted.

  • ALLOCATING_READONLY_ADDRESS: The read-only address is being created.

  • DELETING_READONLY_ADDRESS: The read-only address is being deleted.

  • ALLOCATING_READWRITE_ADDRESS: The read/write splitting address is being created.

  • DELETING_READWRITE_ADDRESS: The read/write splitting address is being deleted.

  • ALLOCATING_CLOGSERVICE_ADDRESS: The clog address is being created.

  • DELETING_CLOGSERVICE_ADDRESS: The clog address is being deleted.

  • MODIFYING_ADDRESS: The domain name of the address is being modified.

  • MODIFYING_PRIMARY_ZONE: The primary zone is being switched.

  • MODIFYING_READONLY_ADDRESS: The read-only address is being modified.

  • MODIFYING_READWRITE_ADDRESS: The read/write splitting address is being modified.

  • SPEC_MODIFYING: The specifications of the tenant are being modified.

  • WHITE_LIST_MODIFYING: The allowlist is being modified.

  • CREATING_BINLOG: Binlogs are being created.

ONLINE
EnableInternetAddressServiceboolean

Indicates whether the Internet address can be enabled for the tenant.

true
PrimaryZonestring

The primary zone of the tenant.

cn-hangzhou-h
DeployTypestring

The deployment type of the cluster. Valid values:

  • multiple: multi-IDC deployment
  • single: single-IDC deployment
  • dual: dual-IDC deployment
multiple
DeployModestring

The data replica distribution mode of the tenant.

  • For the high availability version, N-N-N indicates the three-zone mode, and N-N indicates the dual-zone or single-zone mode.
  • For the basic version, N indicates the single-zone mode.
Note
N represents the number of nodes in a single zone.
1-1-1
Descriptionstring

The description of the tenant.

paycore database
CreateTimestring

The time when the tenant was created.

2023-04-21 11:15:47.0
TenantResourceobject

The resource information of the tenant.

UnitNuminteger

The number of resource units for the tenant.

1
Cpuobject

The information about the CPU resources of the tenant.

UsedCpufloat

The number of used CPU cores of the tenant.

8
TotalCpufloat

The total number of CPU cores of the tenant.

10
UnitCpufloat

The number of CPU cores in each resource unit of the tenant.

8
Memoryobject

The information about the memory resources of the tenant.

UsedMemoryfloat

The size of used memory of the tenant, in GB.

30
TotalMemoryfloat

The total memory size of the tenant, in GB.

64
UnitMemoryfloat

The memory size of each resource unit of the tenant, in GB.

32
DiskSizeobject

The information about the disk resources of the tenant.

UsedDiskSizefloat

The size of used disk space of the tenant, in GB.

86
CapacityUnitobject

The information about capacity units.

MaxCapacityUnitinteger

The maximum number of capacity units.

16
MinCapacityUnitinteger

The minimum number of capacity units.

1
UsedCapacitinteger

The number of used capacity units.

5
LogDiskSizeobject

The information about the log disk resources of the tenant.

TotalLogDiskinteger

The total size of log disk of the tenant, in GB.

8.0
UnitLogDiskinteger

The log disk size of each resource unit of the tenant, in GB.

8.0
TenantConnectionsarray<object>

The connection information of the tenant.

TenantConnectionsobject

The connection information of the tenant.

IntranetAddressstring

The intranet address for accessing the tenant.

t4nunwxr0****.oceanbase.aliyuncs.com
IntranetPortinteger

The intranet port for accessing the tenant.

2983
InternetAddressstring

The Internet address for accessing the tenant.

t32a7ru5u****mo.oceanbase.aliyuncs.com
InternetPortinteger

The Internet port for accessing the tenant.

3306
VpcIdstring

The ID of the VPC.

vpc-bp1qiail1asmfe23t****
VSwitchIdstring

The ID of the vSwitch.

vsw-bp1i7b94u2et716yl****
IntranetAddressMasterZoneIdstring

The primary zone corresponding to the address for accessing the tenant.

cn-hangzhou-b
IntranetAddressSlaveZoneIdstring

The standby zone corresponding to the address for accessing the tenant.

cn-hangzhou-g
IntranetAddressStatusstring

The status of the intranet address for accessing the tenant.
The value ONLINE indicates that the address is in service.

ONLINE
ConnectionZonesarray

The list of zones corresponding to the tenant connection.

ConnectionZonesstring

The zone corresponding to the tenant connection.

cn-hangzhou-b
InternetAddressStatusstring

The status of the Internet address for accessing the tenant. Valid values:

  • CLOSED: The address is disabled.
  • ALLOCATING_INTERNET_ADDRESS: An address is being applied for.
  • PENDING_OFFLINE_INTERNET_ADDRESS: The address is being disabled.
  • ONLINE: The address is in service.
CLOSED
TransactionSplitboolean

Specifies whether to enable transaction splitting.

false
AddressTypestring

The type of the address.

  • MASTER: the primary address, which supports both data read and write.
  • READONLY: a read-only address.
  • READWRITE: a read/write splitting address.
  • CLOGSERVICE: a clog service address.
READONLY
EnableTransactionSplitboolean

Specifies whether to enable transaction splitting.

false
ParallelQueryDegreelong

The degree of parallelism (DOP).

1
TenantEndpointIdstring

The ID of the tenant endpoint.

obe-4tw51gp7****
MaxConnectionNumlong

The maximum number of connections.

5000
ConnectionReplicaTypestring

The type of the replica corresponding to the tenant connection.

FULL
ProxyClusterIdstring

The ID of the OceanBase Database Proxy (ODP) cluster.

proxy-xxxxxxx
MaxConnectionLimitlong

The current value set for the maximum number of private connections.

1000
InternetMaxConnectionLimitlong

The upper limit of the maximum number of public connections.

4000
IntranetRpcPortinteger

The port for direct loads of private connections.

3307
InternetMaxConnectionNumlong

The current value set for the maximum number of public connections.

2500
InternetRpcPortinteger

The port for direct loads of public connections.

3307
ConnectionLogicalZonesarray

The logical zones of the endpoints.

ConnectionLogicalZonesstring

The logical zones of the endpoints.

cn-bejing-3-z0,cn-bejing-4-z0
IntranetSqlPortinteger

The port of private SQL connections.

3306
OdpVersionstring

The ODP version.

4.3.1-xxxxxxxxx
TenantZonesarray<object>

The information about zones in the tenant.

TenantZonesobject

The information about zones in the tenant.

TenantZoneIdstring

The ID of the zone.

cn-hangzhou-h
Regionstring

The region where the zone of the tenant resides.

cn-hangzhou
TenantZoneRolestring

The role of the zone of the tenant.

ReadWrite
TenantZoneReplicasarray<object>

The zone replicas of the tenant.

TenantZoneReplicasobject

The zone replicas of the tenant.

ZoneReplicaTypestring

The type of the zone replica.

FULL
ZoneNodesstring

The number of nodes in the zone.

1
LogicZoneNamestring

The name of the logical zone.

cn-shanghai-f-z0
ZoneCopyIdinteger

The ID of the zone replica.

2
FullCopyIdinteger

The ID of the full-featured replica.

3
ReadOnlyCopyIdstring

The ID of the read-only replica.

3
ReadOnlyReplicaTypestring

The type of the read-only replica.

ROW_STORE
ClogServiceStatusstring

The enabling status of the clog service.

  • CLOSED: The clog service is disabled.
  • ONLINE: The clog service is running.
CLOSED
EnableClogServiceboolean

Indicates whether the clog service is available. To enable the clog service, submit a ticket.

false
Charsetstring

The character set.

utf8mb4
Collationstring

The collation.

utf8mb4_general_ci
PrimaryZoneDeployTypestring

The deployment type of the primary zone.

Enumeration Value:
  • RANDOM: RANDOM.
  • STATIC: STATIC.
RANDOM
MasterIntranetAddressZonestring

The zone where the primary node is located.

cn-hangzhou-h
PayTypestring

The type of the payment.

POSTPAY
InstanceTypestring

The type of the instance.

KAFKA_PUBLIC
Seriesstring

The series of the instance.

normal
DiskTypestring

The type of the disk.

cloud_essd_pl1
AvailableZonesarray

The list of zones.

AvailableZonesstring

The list of zones.

["cn-hangzhou-i"]
EnableReadWriteSplitboolean

Indicates whether to enable read/write splitting endpoint.

false
EnableParallelQueryboolean

Indicates whether parallel query can be enabled.

true
MaxParallelQueryDegreelong

The maximum value of DOP.

32
EnableBinlogServiceboolean

Indicates whether the binlog service is available for application.

true
TimeZonestring

The time zone.

Asia/Shanghai
DataMergeTimestring

The major compaction time of the tenant. This parameter is supported only in OceanBase Database V4.0.0 and later.

02:36Z
ReadOnlyResourceobject

The information about read-only resources.

UnitNuminteger

The number of resource units in the tenant.

2
Cpuobject

The number of CPU cores of each replica node in the cluster.

UsedCpufloat

The number of CPU cores used by the cluster.

8
TotalCpufloat

The total number of CPU cores of the tenant.

10
UnitCpufloat

The number of CPU cores in each resource unit of the tenant.

8
Memoryobject

The information about the memory resources of the cluster.

UsedMemoryfloat

The size of memory used by the tenant, in GB.

30
TotalMemoryfloat

The total memory size of the tenant, in GB.

64
UnitMemoryfloat

The memory size of each resource unit of the tenant, in GB.

32
DiskSizeobject

The size of the data disk.

UsedDiskSizefloat

The size of disk space used by the tenant, in GB.

86
CapacityUnitobject

The information about capacity units.

MaxCapacityUnitinteger

The maximum number of capacity units.

16
MinCapacityUnitinteger

The minimum number of capacity units.

1
UsedCapacitinteger

The number of used capacity units.

5
LogDiskSizeobject

The information about the log disk resources of the tenant.

TotalLogDiskinteger

The total log disk size of the tenant, in GB.

8.0
UnitLogDiskinteger

The log disk size of each resource unit of the tenant, in GB.

8.0
EnableReadOnlyReplicaboolean

Indicates whether read-only replicas are supported.

true
RecycleBinStatusstring

The status of the recycle bin in the tenant. Valid values:

  • ON: The recycly bin is enabled.
  • OFF: The recycle bin is disabled.
ON
LowerCaseTableNamesbyte

Indicates whether the table name is case-sensitive. Valid values:

  • 1: The table name is case-insensitive.
  • 0: The table name is case-sensitive.
1
Versionstring

The version information.

4.2.1
OdpVersionstring

The ODP version.

4.3.1-xxxxxxxxx
TenantMaxConnectionsstring

The maximum number of connections allowed in the tenant.

1600
ParameterTemplatestring

The parameter template.

express_oltp

Examples

Sample success responses

JSONformat

{
  "RequestId": "EE205C00-30E4-XXXX-XXXX-87E3A8A2AA0C",
  "Tenant": {
    "TenantId": "t4louaeei****",
    "TenantName": "forMySQLTenant",
    "TenantMode": "MySQL",
    "VpcId": "vpc-bp1d2q3mhg9i23ofi****",
    "Status": "ONLINE",
    "EnableInternetAddressService": true,
    "PrimaryZone": "cn-hangzhou-h",
    "DeployType": "multiple",
    "DeployMode": "1-1-1",
    "Description": "paycore database",
    "CreateTime": "2023-04-21 11:15:47.0",
    "TenantResource": {
      "UnitNum": 1,
      "Cpu": {
        "UsedCpu": 8,
        "TotalCpu": 10,
        "UnitCpu": 8
      },
      "Memory": {
        "UsedMemory": 30,
        "TotalMemory": 64,
        "UnitMemory": 32
      },
      "DiskSize": {
        "UsedDiskSize": 86
      },
      "CapacityUnit": {
        "MaxCapacityUnit": 16,
        "MinCapacityUnit": 1,
        "UsedCapacit": 5
      },
      "LogDiskSize": {
        "TotalLogDisk": 8,
        "UnitLogDisk": 8
      }
    },
    "TenantConnections": [
      {
        "IntranetAddress": "t4nunwxr0****.oceanbase.aliyuncs.com",
        "IntranetPort": 2983,
        "InternetAddress": "t32a7ru5u****mo.oceanbase.aliyuncs.com",
        "InternetPort": 3306,
        "VpcId": "vpc-bp1qiail1asmfe23t****",
        "VSwitchId": "vsw-bp1i7b94u2et716yl****",
        "IntranetAddressMasterZoneId": "cn-hangzhou-b",
        "IntranetAddressSlaveZoneId": "cn-hangzhou-g",
        "IntranetAddressStatus": "ONLINE",
        "ConnectionZones": [
          "cn-hangzhou-b"
        ],
        "InternetAddressStatus": "CLOSED",
        "TransactionSplit": false,
        "AddressType": "READONLY",
        "EnableTransactionSplit": false,
        "ParallelQueryDegree": 1,
        "TenantEndpointId": "obe-4tw51gp7****",
        "MaxConnectionNum": 5000,
        "ConnectionReplicaType": "FULL",
        "ProxyClusterId": "proxy-xxxxxxx",
        "MaxConnectionLimit": 1000,
        "InternetMaxConnectionLimit": 4000,
        "IntranetRpcPort": 3307,
        "InternetMaxConnectionNum": 2500,
        "InternetRpcPort": 3307,
        "ConnectionLogicalZones": [
          "cn-bejing-3-z0,cn-bejing-4-z0"
        ],
        "IntranetSqlPort": 3306,
        "OdpVersion": "4.3.1-xxxxxxxxx"
      }
    ],
    "TenantZones": [
      {
        "TenantZoneId": "cn-hangzhou-h",
        "Region": "cn-hangzhou",
        "TenantZoneRole": "ReadWrite",
        "TenantZoneReplicas": [
          {
            "ZoneReplicaType": "FULL",
            "ZoneNodes": "1",
            "LogicZoneName": "cn-shanghai-f-z0",
            "ZoneCopyId": 2,
            "FullCopyId": 3,
            "ReadOnlyCopyId": "3",
            "ReadOnlyReplicaType": "ROW_STORE"
          }
        ]
      }
    ],
    "ClogServiceStatus": "CLOSED",
    "EnableClogService": false,
    "Charset": "utf8mb4",
    "Collation": "utf8mb4_general_ci",
    "PrimaryZoneDeployType": "RANDOM",
    "MasterIntranetAddressZone": "cn-hangzhou-h",
    "PayType": "POSTPAY",
    "InstanceType": "KAFKA_PUBLIC",
    "Series": "normal",
    "DiskType": "cloud_essd_pl1",
    "AvailableZones": [
      "[\"cn-hangzhou-i\"]"
    ],
    "EnableReadWriteSplit": false,
    "EnableParallelQuery": true,
    "MaxParallelQueryDegree": 32,
    "EnableBinlogService": true,
    "TimeZone": "Asia/Shanghai",
    "DataMergeTime": "02:36Z",
    "ReadOnlyResource": {
      "UnitNum": 2,
      "Cpu": {
        "UsedCpu": 8,
        "TotalCpu": 10,
        "UnitCpu": 8
      },
      "Memory": {
        "UsedMemory": 30,
        "TotalMemory": 64,
        "UnitMemory": 32
      },
      "DiskSize": {
        "UsedDiskSize": 86
      },
      "CapacityUnit": {
        "MaxCapacityUnit": 16,
        "MinCapacityUnit": 1,
        "UsedCapacit": 5
      },
      "LogDiskSize": {
        "TotalLogDisk": 8,
        "UnitLogDisk": 8
      }
    },
    "EnableReadOnlyReplica": true,
    "RecycleBinStatus": "ON",
    "LowerCaseTableNames": "1",
    "Version": "4.2.1",
    "OdpVersion": "4.3.1-xxxxxxxxx",
    "TenantMaxConnections": "1600",
    "ParameterTemplate": "express_oltp"
  }
}

Error codes

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

Change history

Change timeSummary of changesOperation
2024-10-29The response structure of the API has changedView Change Details
2024-08-15The response structure of the API has changedView Change Details
2024-08-01The response structure of the API has changedView Change Details
2024-06-06The response structure of the API has changedView Change Details
2024-04-15The response structure of the API has changedView Change Details
2024-02-02The response structure of the API has changedView Change Details
2023-12-26The response structure of the API has changedView Change Details
2023-10-30The response structure of the API has changedView Change Details
2023-08-25The response structure of the API has changedView Change Details
2023-08-21The response structure of the API has changedView Change Details
2023-08-09The response structure of the API has changedView Change Details
2023-07-04The response structure of the API has changedView Change Details
2023-05-17The response structure of the API has changedView Change Details
2022-09-28The response structure of the API has changedView Change Details
2021-08-19Add OperationView Change Details