This product(
OceanBasePro/2019-09-01) OpenAPI adopts RPC Signature style, see signature details Description of the signature mechanism. We have packaged SDKs for common programming languages for developers. Developers can directly call the OpenAPI of this product by downloading the SDK without paying attention to the technical details. If the existing SDK cannot meet the usage requirements, you can connect through the signature mechanism. It will take about 5 working days. Therefore, it is recommended to join our service nail group (11370001915) and sign under the guidance of experts. Before using the API, you need to prepare your identity account and access key (AccessKey) to effectively access the API through client tools (SDK, CLI, etc.). For details see getAccessKey.
Cluster management
| API | Title | Description |
|---|---|---|
| CreateInstance | CreateInstance | You can call this operation to create an OceanBase database cluster. |
| ModifyInstanceName | ModifyInstanceName | You can call this operation to change the name of an OceanBase cluster. |
| DescribeInstance | DescribeInstance | You can call this operation to query the detailed information of an OceanBase cluster. |
| DescribeInstances | DescribeInstances | You can call this operation to obtain the list of OceanBase clusters. |
| DescribeInstanceTopology | DescribeInstanceTopology | You can call this operation to query the topology of an OceanBase cluster. |
Tenant management
| API | Title | Description |
|---|---|---|
| CreateTenant | CreateTenant | You can call this operation to create a tenant. |
| CreateTenantReadOnlyConnection | CreateTenantReadOnlyConnection | You can call this operation to create a read-only address for a specified tenant. |
| DeleteTenants | DeleteTenants | You can call this operation to delete one or more tenants from an OceanBase cluster. |
| ModifyTenantPrimaryZone | ModifyTenantPrimaryZone | You can call this operation to switch the primary zone of the tenant. |
| ModifyTenantResource | ModifyTenantResource | You can call this operation to modify the specifications of a tenant in an OceanBase cluster. |
| DescribeTenants | DescribeTenants | You can call this operation to query the tenants in an OceanBase cluster. |
| DescribeInstanceTenantModes | DescribeInstanceTenantModes | You can call this operation to query the modes of tenants. |
| DescribeTenant | DescribeTenant | You can call this operation to query the information of a specific tenant in a specific cluster. |
| DescribeAvailableCpuResource | DescribeAvailableCpuResource | You can call this operation to query the CPU resources available for a tenant. |
| DescribeAvailableMemResource | DescribeAvailableMemResource | You can call this operation to query the available memory resource of an OceanBase Database tenant. |
| DescribeCharset | DescribeCharset | You can call this operation to query the character set of an OceanBase Database tenant. |
| DescribeInstanceCreatableZone | DescribeInstanceCreatableZone | You can call this operation to query the zones of a cluster that can be set as the primary zone. |
| DescribeTenantZonesRead | DescribeTenantZonesRead | You can call this operation to query the information about read-only zones of a tenant. |
| DescribeTimeZones | DescribeTimeZones | You can call this API to query the time zones supported by an OceanBase Database tenant. |
| DescribeZones | DescribeZones | You can call this operation to learn of zones where a cluster can be created in an Alibaba Cloud region. |
Tenant user management
| API | Title | Description |
|---|---|---|
| CreateTenantUser | CreateTenantUser | You can call this operation to create an account in a tenant that has access to a database. |
| DeleteTenantUsers | DeleteTenantUsers | You can call this operation to delete one or more database accounts. |
| ModifyTenantUserDescription | ModifyTenantUserDescription | You can call this operation to modify the description of a specified account in a tenant. |
| ModifyTenantUserPassword | ModifyTenantUserPassword | You can call this operation to change the logon password of a specified account in a tenant. |
| ModifyTenantUserRoles | ModifyTenantUserRoles | You can call this operation to modify the database privileges of a specified account in a tenant. |
| DescribeTenantUsers | DescribeTenantUsers | You can call this operation to query all accounts in a tenant that have access to the database. |
| DescribeTenantUserRoles | DescribeTenantUserRoles | You can call this operation to obtain the account authorization information of the tenant. |
Database management
| API | Title | Description |
|---|---|---|
| CreateDatabase | CreateDatabase | You can call this operation to create a database in a tenant. |
| DeleteDatabases | DeleteDatabases | You can call this operation to delete one or more tenants from an OceanBase cluster. |
| DeleteInstances | DeleteInstances | You can call this operation to release an OceanBase cluster. |
| ModifyDatabaseDescription | ModifyDatabaseDescription | You can call this operation to modify the description of an OceanBase database. |
| ModifyTenantUserStatus | ModifyTenantUserStatus | You can call this operation to lock or unlock a specified database account. |
| DescribeDatabases | DescribeDatabases | You can call this operation to query databases in a tenant. |
| ModifyDatabaseUserRoles | ModifyDatabaseUserRoles | You can call this operation to modify the privileges of an account on a database. |
Parameter management
| API | Title | Description |
|---|---|---|
| ModifyParameters | ModifyParameters | You can call this operation to modify the parameters of a cluster or tenant. |
| DescribeParameters | DescribeParameters | You can call this operation to query the information of cluster or tenant parameters. |
| DescribeParametersHistory | DescribeParametersHistory | You can call this operation to query the modification history of cluster or tenant parameters. |
Security settings
| API | Title | Description |
|---|---|---|
| CreateSecurityIpGroup | CreateSecurityIpGroup | You can call this operation to create an IP address whitelist group. |
| DeleteSecurityIpGroup | DeleteSecurityIpGroup | You can call this operation to delete an IP address whitelist group of an OceanBase cluster. |
| ModifySecurityIps | ModifySecurityIps | You can call this operation to modify the IP address list in a group. |
| DescribeSecurityIpGroups | DescribeSecurityIpGroups | You can call this operation to view the list of IP address whitelist groups. |
Metrics management
| API | Title | Description |
|---|---|---|
| DescribeNodeMetrics | DescribeNodeMetrics | You can call this operation to query the detailed metrics information of an OceanBase Database node. |
| DescribeTenantMetrics | DescribeTenantMetrics | You can call this operation to query the metrics of a specified OceanBase Database tenant. |
Diagnostic management
| API | Title | Description |
|---|---|---|
| DescribeAnomalySQLList | DescribeAnomalySQLList | You can call this operation to obtain the list of SQL statements that may have performance problems according to the diagnostic system. |
| DescribeOutlineBinding | DescribeOutlineBinding | You can call this operation to query the outline binding information or throttling information of an SQL statement in the database based on an SQLID. |
| DescribeRecommendIndex | DescribeRecommendIndex | You can call this operation to query the index recommended by the diagnostic system based on an SQL ID. |
| DescribeSlowSQLHistoryList | DescribeSlowSQLHistoryList | You can call this operation to query the execution history of an SQL statement by SQL ID that is determined as a slow SQL statement during a specified period of time. |
| DescribeSQLDetails | DescribeSQLDetails | You can call this operation to query the SQL text of an SQL statement based on the SQL ID. |
| DescribeSlowSQLList | DescribeSlowSQLList | You can call this operation to query the list of slow SQL statements |
| DescribeSQLHistoryList | DescribeSQLHistoryList | You can call this operation to query the execution history of an SQL statement in a specified period based on an SQL ID. |
| DescribeSQLPlans | DescribeSQLPlans | You can call this operation to query the information about the SQL execution plans stored in the diagnostic system based on an SQL ID. |
| DescribeTopSQLList | DescribeTopSQLList | You can call this operation to query SQL execution performance data collected by the diagnostic system. |
Data migration
| API | Title | Description |
|---|---|---|
| CreateOmsMysqlDataSource | You can call this operation to create a MySQL data source. | |
| CreateOmsOpenAPIProject | CreateOmsOpenAPIProject | You can call this operation to create a data synchronization project. |
| StartOmsOpenAPIProject | StartOmsOpenAPIProject | |
| StopOmsOpenAPIProject | StopOmsOpenAPIProject | |
| ResumeOmsOpenAPIProject | ResumeOmsOpenAPIProject | You can call this operation to resume a data synchronization project. |
| ResetOmsOpenAPIProject | ResetOmsOpenAPIProject | You can call this operation to reset a data synchronization project. |
| ReleaseOmsOpenAPIProject | ReleaseOmsOpenAPIProject | You can call this operation to release a data synchronization project. |
| DeleteOmsOpenAPIProject | DeleteOmsOpenAPIProject | You can call this operation to delete a data synchronization project. |
| DeleteOmsOpenAPIProject | DeleteOmsOpenAPIProject | |
| DescribeOmsOpenAPIProject | DescribeOmsOpenAPIProject | |
| DescribeOmsOpenAPIProjectSteps | DescribeOmsOpenAPIProjectSteps | |
| SearchOmsOpenAPIMonitorMetric | SearchOmsOpenAPIMonitorMetric | |
| SearchOmsOpenAPIProjects | SearchOmsOpenAPIProjects |