This topic describes the features of OceanBase Database on Alibaba Cloud and the OB Cloud console.
Database management
Feature module | Feature | ApsaraDB for OceanBase | OB Cloud on Alibaba Cloud Marketplace |
Instance lifecycle management | Create instance | Supported | Support |
Release instance | Support | Support | |
Retain all backups when releasing an instance | Support | Support | |
Pause instance | Not supported | Not supported | |
Restart instance | Not supported | Support | |
Instance specification management | Upgrade or downgrade compute specifications (migration-based) | Support | Support |
Upgrade compute specifications (in-place) | Supported | Support | |
Scale storage space | Support | Support | |
Add or remove nodes | Support | Support | |
Change storage class | Support | Not supported | |
Switch deployment solution | Supported | Supported for pay-as-you-go. Not currently supported for subscription. | |
Automatic storage expansion for instances | Support | Support | |
View instance specification change history | Support | Supported | |
Subscription: Temporary upgrade or downgrade | Support | Not supported | |
Subscription: Convert temporary specifications to subscription | Support | Not supported | |
Scale out the log disk | Support | Not supported | |
Read-only replica and read-only column-store replica management | Create and delete | Supported | Support |
Scale compute and storage | Support | Supported | |
Add or remove nodes | Support | Support | |
Binary logging service management | Enable and disable the binary logging service | Support | Support |
Tenant management | Create and release tenants | Supported | Support |
MySQL-compatible tenant | Support | Support | |
Oracle-compatible tenant | Supported | Support | |
Upgrade or downgrade tenant specifications | Support | Support | |
Scheduled tenant specification change | Support | Not supported | |
Modify the number of tenant units | Support | Support | |
Migrate tenant units | Support | Supported | |
Modify tenant name | Support | Support | |
Parameter templates (OLTP/OLAP/HTAP) | Support | Support | |
Set table name case sensitivity | Support | Supported | |
Set time zone | Support | Support | |
Modify time zone | Not supported | Supported | |
Set character set | Support | Support | |
Set collation | Support | Support | |
Switch the primary zone for a tenant | Support | Supported | |
Database management | Create database | Support | Support |
Set database character set | Support | Supported | |
Set database collation | Supported | Support | |
Delete database | Supported | Support | |
Account management | Create account | Support | Support |
Delete account | Support | Supported | |
Lock or unlock account | Supported | Support | |
Reset password | Support | Support | |
Quick authorization: ALL, Select, DDL, and DML | Support | Support | |
Customize account permissions | Supported | Support | |
Modify account permissions | Support | Supported | |
Batch account authorization management | Support | Not supported | |
Global account permission authorization | Support | Not supported | |
Require complex passwords | Support | Support | |
Parameter management | Instance parameter management | Support | Support |
Tenant parameter management | Support | Support | |
View parameter modification history | Support | Support | |
Data merge management | Instance-level data merge | Support | Support |
Tenant-level data merge | Supported | Support | |
Merge time for all tenants | Supported | Supported | |
Modify the merge time for a specified tenant | Not supported | Support | |
View data merge records for an instance or tenant | Support | Support | |
Upgrade and maintenance | Set a maintenance window for an instance | Support | Support |
Automatic upgrade of OceanBase Database minor engine version | Available through a support ticket | Available through a support ticket | |
Automatic upgrade of OceanBase Database major engine version | Available through a support ticket | Available through a support ticket | |
Automatic ODP kernel version upgrades | Available through a support ticket | Available through a support ticket | |
Proactive O&M events | Support | Not supported | |
Recycle bin feature | Database instance recycle bin | Support | Support |
Restore an instance from the recycle bin | Support | Not supported | |
Database recycle bin | Support | Support | |
Restore a database | Support | Support | |
Table recycle bin | Support | Support | |
Restore a table | Support | Support | |
Resource isolation | Resource isolation between tenants | Support | Support |
Resource group management within a tenant | Support | Support | |
Tag management | Instance tag management | Support | Supported |
Tenant tag management | Supported | Supported |
Database proxy management
Feature module | Feature | ApsaraDB for OceanBase | OB Cloud on Alibaba Cloud Marketplace |
Address Type | Primary endpoint | Supported | Support |
Read-only endpoint | Support | Supported | |
Read/write splitting endpoint | Support | Support | |
Direct connection endpoint | Supported | Not supported | |
Proxy endpoint connection management | Modify the maximum connections for a proxy endpoint | Support | Support |
Database proxy specification change | General-purpose | Supported | Support |
Dedicated | Support | Support | |
Modify specification type | Support | Support | |
Upgrade or downgrade specifications | Supported | Support | |
Read/write traffic policy | Query a specified type of replica | Support | Support |
Query a specified read-only replica or read-only column-store replica | Support | Support | |
Read traffic policy: Automatic load balancing, zone affinity, and custom weights | Supported | Support | |
Read traffic disaster recovery policy: If a queried replica is unavailable, query the primary replica or a specified read-only replica | Support | Supported | |
Proxy endpoint network configuration | Enable public network access for the primary endpoint | Support | Support |
Enable a bypass import port for the primary endpoint | Support | Not supported | |
Modify the network configuration of a proxy endpoint | Support | Not supported | |
Modify the zone of a proxy endpoint | Support | Not supported | |
Modify the port of a proxy endpoint | Support | Not supported | |
Modify the domain name prefix of a proxy endpoint | Support | Not supported |
High availability management
Feature module | Feature | ApsaraDB for OceanBase | OB Cloud on Alibaba Cloud Marketplace |
Instance high availability management | Switch the primary zone for a tenant | Support | Support |
Switch the primary zone for a tenant in a single-data-center deployment | Supported | Not supported | |
Switch the zone for an instance | Support | Support | |
Switch the deployment solution for an instance (single-data-center, dual-data-center, or multi-data-center deployment) | Support | Support | |
Primary/secondary disaster recovery | Cross-region primary/secondary disaster recovery | Support | Support |
Primary/secondary switchover | Support | Supported | |
Automatic failover to the secondary instance | Not supported | Not supported | |
Decouple primary and secondary instances | Support | Support | |
Primary/secondary latency monitoring | Supported | Support | |
Add a primary endpoint and an access endpoint for a secondary instance tenant | Supported | Support | |
Read/write splitting for primary and secondary instances | Support | Support | |
Cross-cloud primary/secondary disaster recovery | Create cross-cloud primary and secondary instances | Not supported | Supported |
Decouple cross-cloud primary and secondary instances | Not supported | Support |
Security management
Feature module | Feature | ApsaraDB for OceanBase | OB Cloud on Alibaba Cloud Marketplace |
Security Center | Security and compliance assessment | Support | Support |
ActionTrail | Historical events | Support | Supported |
IP whitelist | Cluster whitelist | Support | Support |
Tenant whitelist | Support | Support | |
Whitelist group management | Supported | Support | |
Security group | Support | Not supported | |
SSL-encrypted connection | Enable SSL | Support | Support |
Disable SSL | Not supported | Support | |
Manually renew the SSL certificate | Supported | Support | |
Automatically renew the SSL certificate | Support | Supported | |
Default SSL certificate validity period | 1 year | 1 year | |
Enforce SSL | Support | Not supported | |
Download CA certificate | Support | Supported | |
View certificate update history | Support | Support | |
Transparent Data Encryption (TDE) | Enable TDE | Support | Supported |
Disable TDE | Support | Supported | |
Create an encrypted tablespace | Supported | Support | |
Use a key provided by OB Cloud | Support | Supported | |
Use a KMS key provided by the cloud vendor | Support | Not supported | |
Service account authorization (Grant permissions to OceanBase technical support) | Grant permissions to OceanBase technical support | Support | Support |
Modify the authorization expiration date | Support | Supported | |
Revoke authorization | Support | Support | |
Query permission (table schema, index) | Support | Support | |
SQL emergency response (SQL binding, throttling, etc.) | Support | Support | |
Database permission (read-only select) | Support | Supported | |
Emergency session kill | Support | Support | |
Configuration permission (modify instance configuration) | Supported | Support | |
SQL firewall | SQL firewall that uses a blacklist to block SQL statements that match specified rules | Supported | Not supported |
Performance monitoring
Feature module | Feature | ApsaraDB for OceanBase | OB Cloud on Alibaba Cloud Marketplace |
Performance monitoring | Database performance monitoring | Support | Supported |
Database host monitoring | Support | Supported | |
Database proxy performance monitoring | Supported | Support | |
Database proxy host monitoring | Support | Support | |
Multi-dimensional metrics (cluster/tenant/replica/node) | Support | Support | |
Custom monitoring reports | Custom monitoring report for an instance | Support | Supported |
Custom monitoring report for a tenant | Support | Support | |
Monitoring dashboard (Aggregated monitoring for multiple instances) | Support | Not supported | |
Monitoring management | Set monitoring frequency | Supported | Supported |
Time range comparison | Support | Supported | |
Linkage chart | Support | Support | |
Auto-refresh page | Support | Support | |
Adjust chart layout | Supported | Support | |
Metric drill-down | Support | Supported | |
Export monitoring data in Prometheus format | Support | Supported | |
Monitoring and alerts | Custom alert rules | Support | Supported. Uses the OB Cloud alerting feature. |
Backup and recovery
Feature | ApsaraDB for OceanBase | OB Cloud on Alibaba Cloud Marketplace |
Physical backup: Data backup and log backup | Not currently supported | Support |
Recovery granularity: Tenant, database, or table level | Supported | Partially supported (Table-level recovery is not supported for V3.x databases) |
Backup region: Local backup | Support | Support |
Backup region: Geo-redundant backup | Support | Support |
Sparse backup policy | Support | Support |
Backup download | Support | Support |
Instance recycle bin | Support | Not supported |
Logical backup and recovery | Not supported | Not supported |
Logical backup deletion | Support | Not currently supported |
Archive backup | Support | Not currently supported |
Diagnostics
Feature | ApsaraDB for OceanBase | OB Cloud on Alibaba Cloud Marketplace |
Real-time diagnostics - SQL diagnostics - Slow SQL | Support | Support |
Real-time diagnostics - SQL diagnostics - Suspicious SQL | Support | Support |
Real-time diagnostics - SQL diagnostics - High-risk SQL | Support | Support |
Real-time diagnostics - SQL diagnostics - New SQL | Supported | Support |
Real-time diagnostics - SQL diagnostics - Top SQL comparison (by host/time) | Support | Support |
Real-time diagnostics - SQL diagnostics - Request analysis | Support | Supported |
Real-time diagnostics - Session management - Real-time sessions | Support | Supported |
Real-time diagnostics - Session management - Session statistics | Support | Supported |
Real-time diagnostics - Session management - Deadlock detection | Support | Support |
Real-time diagnostics - Session management - Real-time lock analysis | Support | Not currently supported |
Optimization center - SQL optimization suggestions | Supported | Support |
Optimization center - Schema optimization suggestions | Support | Support |
Optimization center - Optimization history | Support | Support |
Capacity center - Capacity risks | Support | Supported |
Capacity center - Capacity usage trends (cluster/tenant/database/table) | Supported | Support |
Capacity center - Disk usage prediction | Support | Support |
Security Center - SQL audit | Support | Support |
Autonomy center - Quick diagnostics | Support | Support |
Autonomy center - Root cause analysis for anomalous activities | Support | Support |
Data import, migration, and replication
Feature | ApsaraDB for OceanBase | OB Cloud on Alibaba Cloud Marketplace |
Disparate data sources: MySQL, RDS, and PolarDB | Support | Support |
Disparate data source: Oracle | Support | Supported |
Disparate data source: Kafka | Support | Support |
Homogeneous one-way replication: OceanBase to OceanBase | Support | Support |
Homogeneous bidirectional replication: OceanBase <> OceanBase, MySQL <> OceanBase, and Oracle <> OceanBase | Support | Support |
Disparate data sources: PostgreSQL, TiDB, PolarDB-X, and Lindorm | Supported | Not currently supported |
Disparate data destinations: DataHub, RocketMQ, and AnalyticDB | Support | Not currently supported |
Migration types: Object migration, full data, and incremental data | Supported | Support |
Task management: Dynamically add or remove tables, clone links, and configure alerts | Supported | Support |
Cross-cloud and cross-region synchronization | Not currently supported | Support |
Data validation | Support | Support |
Offline data import: Import files in SQL, ORC, and Parquet formats | Not currently supported | Supported |
Import files from cloud storage (OBS, COS, OSS, S3) | Not currently supported | Support |
Import sample data | Not currently supported | Support |
Data development
Feature | ApsaraDB for OceanBase | OB Cloud on Alibaba Cloud Marketplace |
SQL Console: Data source | Cloud-based OceanBase databases | Cloud-based OceanBase databases |
SQL Console: Design, view, and edit database objects | Support | Support |
SQL Console: Design, edit, and execute SQL, and set session variables | Support | Support |
SQL Console: View, edit, and export result sets | Supported | Supported |
SQL Console: View, edit, compile, and execute PL | Supported | Support |
SQL Console: PL debugging | Support | Not currently supported |
SQL Console: Personal settings for the SQL window | Support | Not currently supported |
SQL Console: Script management | Supported | Not currently supported |
SQL Console: Code snippets | Support | Not currently supported |
SQL Console: View execution plans | Support | Support |
SQL Console: End-to-end diagnostics at the SQL level | Support | Support |
SQL Console: Real-time SQL profiling | Supported | Support |
SQL Console: SQL Copilot | Not currently supported | Supported |
Test data generation | Support | Support |
SQL plan (database change) | Supported | Support |
Data cleanup | Support | Support |
Data archiving | OceanBase | MySQL Oracle OceanBase |
Partitioning plan | Supported | Support |
Lock-free schema evolution | Support | Not currently supported |
Change risk control: SQL check | Support | Not currently supported |
Change risk control: Change approval | Supported | Not currently supported |
Change risk control: Change rollback | Support | Not currently supported |
Data security and compliance: Data masking | Supported | Not currently supported |
AP data warehouse development: DAG, workflow, ETL task, and data report | Not currently supported | Supported |
Third-party ecosystem
Alibaba Cloud ecosystem products | Can connect to OB Cloud and ApsaraDB for OceanBase clusters |
ECS | Yes |
DMS | Yes |
DataWorks | Yes |
Flink | Yes |
DTS | Yes |