Release notes

Feature name

Feature description

References

New data synchronization tasks

Added support for real-time data synchronization between OB_MySQL and OB_Oracle tenants. This feature enables schema, full data, and incremental DML/DDL synchronization between different OceanBase database tenants. This helps you build a unified data platform more easily.

Data synchronization between different tenants of an OceanBase database

Added support for data synchronization from OB_Oracle tenants to Serverless-Oracle instances. This feature enables schema, full data, and incremental DML/DDL synchronization. This helps you use Serverless instances to support your business and reduce costs.

Data synchronization between the same tenants of an OceanBase database

New features

When you migrate data from a PostgreSQL database to an OceanBase database Oracle tenant, you can now dynamically modify migration and synchronization objects. This includes adding or removing objects and modifying matching rules. This feature lets you manage more objects in a single data migration or synchronization task and reduces task maintenance costs.

Migrate data from an RDS PostgreSQL instance to an OceanBase database Oracle tenant

Usability improvements

For frequently-used data migration tasks between OceanBase, Oracle, and MySQL databases, incremental DDL synchronization is now selected by default. This reduces task interruptions that occur when this option is not selected.

Migrate data from a MySQL database to an OceanBase database in MySQL compatibility mode

When you create a MySQL, Oracle, or TiDB data source, the option to configure Database Name/Schema Name is removed. This prevents issues where you cannot select other databases or schemas in a data migration or synchronization task due to misconfiguration.

Create a MySQL data source

Create an Oracle data source

Create a TiDB data source

When you create a data source for a self-managed database instance in a VPC, a fuzzy search feature for the VPC Name is added. This makes it more convenient to configure data sources.

Create a data source

The user interface for releasing data migration tasks is adjusted. It now displays information about the current task, such as the task ID/name, instance ID, specifications, and billing method. This improves the security of the release operation and helps prevent accidental operations.

Release a data migration task

Feature name

Feature description

References

New features

Added support for data migration from PolarDB-O databases to OceanBase database Oracle tenants. You can use the data migration feature to quickly migrate the schema, full data, and incremental data from PolarDB for Oracle to an OceanBase database. You can also ensure migration reliability and data backflow capabilities after the cutover through validation and reverse incremental synchronization.

Migrate data from a PolarDB-O database to an OceanBase database Oracle tenant

Added support for data migration from AnalyticDB for MySQL databases to OceanBase database MySQL tenants. You can use the data migration feature to quickly migrate full data from an AnalyticDB for MySQL database to an OceanBase database to meet the needs of data warehouse replacement scenarios.

Migrate data from AnalyticDB for MySQL to an OceanBase database MySQL tenant

Added support for configuring bidirectional synchronization tasks. When you configure a migration task for MySQL <-> OB_MySQL, Oracle <-> OB_Oracle, or OceanBase <-> OceanBase, you can choose to create a unidirectional or bidirectional synchronization task. If you choose a bidirectional task, you can configure a reverse task when the forward task enters the incremental synchronization phase. The anti-loop configuration for bidirectional replication is automatically implemented. This helps you better implement scenarios such as grayscale cutover and bidirectional parallel operations.

Configure a bidirectional synchronization task

Added a feature to dynamically modify matching rules for migration and synchronization objects. By modifying the matching rules, you can add or remove migration and synchronization objects. This prevents the need to maintain multiple tasks when your business adds new objects, which reduces the cost of using data migration and synchronization.

Configure and modify matching rules

When you synchronize data from an OceanBase database MySQL tenant to DataHub, if you select the Tuple format, DTS_Compatible is added as an option for the serialization format. This option automatically maps the format to DTS-compatible fields in the destination DataHub. Business fields are prefixed with `dts_`, and non-business fields have the same names as those in DataHub tasks created by DTS. This helps you achieve task compatibility with DTS through the data synchronization feature and avoid business transformation.

Synchronize data from an OceanBase database to DataHub

The restriction on tables without non-null unique keys is lifted for all data migration and synchronization task types, except for OceanBase MySQL -> ADB and Lindorm/HBase -> OBKV. Tables without non-null unique keys can be migrated and synchronized normally. For tasks that support hidden columns (Hidden column mechanism of Data Transmission Service), an option is provided for you to choose whether to configure hidden columns to ensure the consistency of migration and synchronization for tables without non-null unique keys.

Data migration module documentation

When you migrate data from a MySQL database to an OceanBase database MySQL tenant, the MySQL `utf8mb3` character set is now automatically mapped to the `utf8mb4` character set of the OceanBase database MySQL tenant. This enables fast migration and synchronization of MySQL databases.

Migrate data from a MySQL database to an OceanBase database in MySQL compatibility mode

Usability improvements

When you configure a data synchronization task, a column search feature is added for selecting synchronization columns.

Data synchronization module documentation

A filtering feature is added for the source and destination databases of index migration objects.

View the details of a data migration task

Feature name

Feature description

References

New data migration tasks

Added support for data migration tasks from ApsaraDB for HBase Enhanced Edition V2.0 and Lindorm to Alibaba Cloud OBKV. You can use the data migration feature to quickly migrate data from ApsaraDB for HBase Enhanced Edition and Lindorm databases on Alibaba Cloud to OBKV. You can also perform reverse data backflow from OBKV to the source database. This helps you quickly and conveniently migrate data to OceanBase KV scenarios and ensures reverse disaster recovery for data after business cutover, guaranteeing a smooth transition.

• Migrate data from HBase Enhanced Edition to OBKV

• Migrate data from a Lindorm database to OBKV

New features

When creating indexes after data migration, two new configuration items are added: DDL Concurrency for a Single Index and Maximum Number of Concurrent Index DDLs. These items control the DDL statement concurrency for index execution and the number of post-migration indexes running simultaneously in the system. This helps control the pressure from indexing and reduces the load on the destination database.

Data migration module documentation

For data migration tasks involving MySQL <-> OB_MySQL, OB_MySQL -> OB_MySQL, Oracle <-> OB_Oracle, and OB_Oracle -> OB_Oracle, migration capabilities for GIS field types are implemented for schema, full data, and incremental data. Data validation for GIS field types is also supported. This provides capability support for data migration of spatial data services.

You can now dynamically modify the filter conditions for data migration or data synchronization tasks. After modification, the task will continue to migrate data using the new filter conditions. This adapts to changing business needs during long-term synchronization.

• View and modify migration objects and their filter conditions

• View and modify synchronization objects and their filter conditions

Feature name

Feature description

References

Database proxy

The SQL Firewall feature is released. It supports blocking specified SQL statements.

SQL Firewall

You can customize the read traffic policy, load balancing policy, and disaster recovery policy for read-only and read/write splitting endpoints.

Database proxy service management

You can create read-only and read/write splitting endpoints for secondary clusters.

Add an endpoint

Resource group management

You can create resource groups within a tenant to set the percentage of CPU that a database USER can use.

Resource isolation management

Resource limit optimization

A single cluster now supports more tenants.

Create a tenant

For tenant specifications, provided that the minimum specification of 1C 4GB is met, the CPU-to-memory ratio is changed from 1:2 to 1:1. For example, you can now create tenants with 2C 4GB or 4C 4GB specifications.

Instance and tenant management

Scheduled upgrades and downgrades for tenant specifications are supported.

Set scheduled tenant specification changes

You can create tenants with the Latin1 character set.

Create a tenant

The maximum length for cluster instance names and tenant names is now 64 characters.

Create a tenant

User permission management supports batch authorization for database users.

Account-related operations

You can call an API to automatically update the validity period of SSL certificates.

ModifyInstanceSSL - Modify SSL configuration

Read replicas support automatic storage expansion.

Set automatic storage scaling

Developer Center Guide

Table-level permission control is added. This allows project members to have different operation permissions for different tables, including query, change, and export operations. This further enhances collaborative control capabilities.

Project collaboration management

Real-time execution analysis is added. It provides a visual and interactive presentation of sql_plan_monitor.

Execution analysis

When you create and edit lock-free schema change tasks, you can set throttling parameters.

Lock-free schema change

Data transmission feature optimization

You can now upgrade the instance specifications for data migration and data synchronization tasks. Upgrading the specifications increases the upper limit of RPS to meet performance improvement requirements for data migration/synchronization tasks when business pressure increases.

Data transmission specifications

When the destination or reverse incremental source is an OceanBase database of V4.3.x or later, you can configure the table schema storage type. The options include default, row store, column store, and hybrid row-column store.

Migrate data from a MySQL database to an OceanBase database in MySQL compatibility mode

Data synchronization tasks from a database to a message queue support selecting synchronization objects using matching rules.

Configure and modify matching rules

You can enable SSL-encrypted connections for MySQL data sources.

Create a MySQL data source

Feature name

Feature description

References

Read replicas

A cluster instance supports the creation of up to 10 read replicas.

Read replica overview

Database proxy

• The database proxy management page is available.

• You can modify the maximum number of connections for a proxy endpoint.

• You can enable the bypass import port.

Database proxy billing

Database proxy service overview

Database proxy service management

Modify the maximum connections for a proxy endpoint

Bypass import

Instance management

The instance topology graph can be switched to a list view to see replica, tenant, and node information.

Cluster instance workbench

Performance monitoring

• The page supports auto-refresh.

• You can set the layout of monitoring charts.

Cluster performance monitoring overview

Tenant performance monitoring overview

Primary/secondary cluster

Secondary clusters support read-only queries.

Create a secondary instance

OpenAPI

Supports tag group and tag management.

CreateTag - Create a tag group

CreateTagValue - Create a tag

DescribeTagValues - Query tags

DeleteTagValue - Remove a tag

DeleteTag - Delete a tag group

ModifyTagValueName - Modify a tag name

ModifyTagName - Modify a tag group name

Backup and restoration

• The local level-1 backup feature for OceanBase 4.x versions supports archive backups.

• The maximum retention period for level-1 backups and geo-redundant backups can be set to 7,200 days.

Backup policy

Backup and restoration overview

Autonomy service

• Root cause analysis for more scenarios is added, and the diagnosis process for anomalies is displayed visually.

• Real-time execution status of SQL is supported, allowing for more accurate identification of bottlenecks in SQL execution during abnormal scenarios and improving diagnostic efficiency.

Emergency response for anomalies

SQL basic information

SQL details

Feature name

Feature description

References

Architecture optimization

OceanBase database clusters can be deployed in regions with only two data centers.

-

Tenant feature optimization

When creating a MySQL tenant, you can set whether table names are case-sensitive.

Create a tenant

Cluster feature optimization

• You can view the merge records of OceanBase database 4.x cluster instances.

• The specification change history of cluster instances is compatible with read replicas.

• OceanBase Standard Edition (Key-Value) clusters support enabling public endpoints.

• The cluster database and table recycle bin interface is optimized.

View merge records

View cluster instance specification change history

Add an endpoint

Cluster database and table recycle bin

Second-level monitoring capability launched

The default monitoring frequency for OceanBase databases is 60s. If your business requires more precise monitoring, you can now set it to 5s (paid service).

Cluster performance monitoring overview

Monitoring billing

Monitoring capability enhancement

• You can view the storage usage of Serverless instances.

• Chart filter interaction and time period comparison capabilities are introduced for cluster instances.

• You can monitor OceanBase data using Prometheus.

Manage Serverless instances

Cluster performance monitoring overview

Monitor OceanBase data using Prometheus

Data security enhancement

Supports the signing and display of cross-border data transfer agreements.

Cross-border data compliance commitment

Backup and restoration enhancement

• When initiating a tenant restoration task, a precheck of the remaining storage space is supported to improve the success rate of backup and restoration.

• Database-level restoration for logical backups is supported.

• OceanBase databases provide yearly/monthly/weekly sparse backup retention policies to minimize backup storage costs and meet backup compliance requirements.

• The display logic for details of complimentary and paid backup storage quotas is optimized.

Initiate restoration

Backup policy

Backup and restoration overview

Autonomy service enhancement

• Seamless integration of monitoring and diagnosis processes is achieved, supporting one-click cluster diagnosis from the cluster or tenant monitoring interface.

• The system fault handling process is upgraded with a new "System Restore" step, creating a complete closed loop from anomaly detection to system restoration. This allows users to roll back operations and restore the state before the emergency response, ensuring service stability.

Tenant performance monitoring overview

Cluster performance monitoring overview

Manage effective Outlines

Data transmission feature optimization

• The reverse incremental synchronization feature is added for migrating homogeneous or heterogeneous databases such as Oracle, OceanBase, and TiDB to OceanBase database V4.2.2. This is mainly used for data backflow after data migration is complete.

• Data migration from OceanBase database V4.2.2 as a source is now supported.

• Data synchronization from OceanBase database V4.2.2 as a source is supported.

Overview

Support for OceanBase Serverless instances is added.

Create an OceanBase data source

For data migration or data synchronization tasks that involve DDL synchronization, you can customize the DDL types to be synchronized.

Customize DDL/DML configuration

Concurrent resource and rate-limiting configurations are added for data migration and data synchronization tasks. By adjusting these configurations, you can control the concurrency and traffic for full migration, incremental synchronization, and reverse incremental synchronization (data synchronization tasks only), ensuring the stability of the source/destination and the task itself.

Migrate data from a MySQL database to an OceanBase database in MySQL compatibility mode

When setting up incremental synchronization for a TiDB data source, a TiDB data format option is added. You can choose between TiCDC or TiDB Binlog formats based on your actual scenario. This meets different TiDB incremental parsing needs and enables quick connection for incremental synchronization from TiDB to an OceanBase database MySQL tenant.

Create a TiDB data source

Feature name

Feature description

References

Serverless instances officially launched

• Serverless instances are based on the multi-tenant feature of OceanBase databases. Combined with the automatic scaling and scheduling capabilities of the cloud, they provide a new product service that better fits the actual usage patterns of businesses.

• When using them, you can select a range of computing resources to place an order. We will bill you with second-level precision based on actual consumption, truly achieving a pay-as-you-go model.

Serverless instances

Serverless billing

Read replica feature officially launched

You can create read replicas for OceanBase database Standard Edition (Cloud Disk) cluster instances. With this feature, you can switch query traffic to read replicas, effectively reducing the load on the primary replica and improving the throughput capacity of the instance.

Read replica management

Read replica billing

Database proxy service supports dedicated specifications

The OceanBase database proxy provides two types of proxy services: shared proxy and dedicated proxy.

• Shared proxy: Shares physical CPU resources, is free of charge for a limited time.

• Dedicated proxy: Occupies dedicated physical CPU resources, is billed on a pay-as-you-go basis, and offers better performance stability.

Database proxy

Database proxy billing

Automatic scaling optimization

The automatic storage expansion mechanism has been optimized and upgraded:

• You can customize the step size for automatic storage expansion based on actual business needs.

• An expansion limit prompt and alert function is introduced.

• The monitoring frequency of storage space usage by the system is displayed.

• You can view the specification change history for automatic expansion.

Set automatic storage scaling

View cluster instance specification change history

Storage type conversion

You can switch the storage type of a cluster instance between ESSD PL1 and ESSD PL0 cloud disks.

Switch storage type

Scheduled tenant specification change

OceanBase databases support setting scheduled tenant specification changes to dynamically adjust tenant resource quotas such as CPU and memory.

Set scheduled tenant specification changes

New specifications for OceanBase Standard Edition (Key-Value) released

In the China (Hangzhou), China (Shanghai), China (Qingdao), China (Beijing), China (Zhangjiakou), and China (Shenzhen) regions, you can select 4-core 16 GB, 8-core 32 GB, 16-core 70 GB, and 24-core 120 GB configuration options for the Standard Edition (Key-Value) series when configuring instance specifications.

Product series

Pricing

Backup and restoration enhancement

• Logical backup (database & table level) supports OceanBase 4.x versions.

• The data backup retention period for level-1 backups can be set from 2 to 365 days.

• The instance recycle bin supports deleting archive backup files of cluster instances.

• Archive backups can be deleted in the cluster recycle bin.

• Product usability is improved, such as specification validation during data restoration, adding recoverable time points for data backups, and adding backup and restoration durations.

• OpenAPIs are available, such as for downloading backup sets, enabling backups, and querying backups.

Backup policy

Instance recycle bin

Back up now

Initiate restoration

CreateBackupSetDownloadLink - Create a download link for a backup task

DescribeDataBackupSet - Query backup set information

Autonomy service feature optimization

• A new monitoring dashboard is added, allowing customers to customize monitoring objects and metrics through the dashboard.

• Supports connecting to tenant instances.

• Real-time diagnosis supports detecting new SQL.

• The capacity center supports inspecting information such as auto-increment primary keys and partition counts.

• A real-time row lock analysis function is added.

Autonomy service overview

SQL basic information

Capacity diagnosis

Session diagnosis

Feature name

Feature description

References

New features

The reverse incremental synchronization feature is added for migrating homogeneous or heterogeneous databases, such as Oracle, OceanBase, and TiDB, to OceanBase 4.2.0/4.2.1. This feature is mainly used for data backflow after data migration is complete.

Data migration module documentation

Data migration from OceanBase 4.2.0/4.2.1 as a source is now supported. This includes data migration between OceanBase 4.2.0/4.2.1 instances and from OceanBase 4.2.0/4.2.1 to a MySQL database.

A single data migration project now supports scenarios with many large objects.

Data migration projects from cloud-based OceanBase database Oracle tenant cluster instances to Oracle databases over a public network or within a VPC are now supported.

Migrate data from an OceanBase database Oracle tenant to an Oracle database

Data migration and data synchronization projects from Alibaba Cloud RDS for PostgreSQL databases to cloud-based OceanBase database Oracle tenant cluster instances are now supported.

• Migrate data from an RDS PostgreSQL instance to an OceanBase database Oracle tenant

• Synchronize data from an RDS PostgreSQL instance to an OceanBase database Oracle tenant

Database-to-database data synchronization projects now support matching rules. This lets you select synchronization objects by configuring wildcard rules, which reduces the cost of selecting synchronization objects.

Configure and modify matching rules

Matching rules now support schema wildcards.

Data synchronization projects from an OceanBase database MySQL tenant to Kafka now support outputting OceanBase data to Kafka in the Avro serialization format. This expands the ways you can connect to downstream big data ecosystems.

Data format description

Eight new OpenAPI interfaces are supported. These interfaces mainly cover RDS for PostgreSQL data sources, adding and removing tables, and transmission instance modules.

Data transmission API reference guide

Feature name

Feature description

References

New features

New ARM architecture specifications released

Standard Edition (Cloud Disk) series ARM architecture clusters are released, supporting specifications including 16C 70GB, 32C 180GB, and 62C 400GB. The corresponding compute instance prices are about 18-20% lower than the same specifications on x86, suitable for customers with different CPU architectures.

Purchase an instance

Overall optimization of cluster specification change capability

The existing specification change capabilities have been further categorized into temporary upgrades, standard upgrades, etc. The ability to convert temporary storage and specifications into permanent ones has been added, providing more flexibility to adapt to business changes for cloud customers.

Configuration overview

Backup and restoration enhancement

• Added support for restoring from full backup sets for clusters of V4.0 and later.

• Supports cluster instance recycle bin.

• New capabilities include database-level logical backup, downloading of database and table logical backup sets, and restoring from archive backups.

• The number of tables supported for logical table backup and restoration is optimized to 200.

Initiate restoration

Backup policy

Instance recycle bin

Feature name

Feature description

References

New features

Automatic storage scaling

You can configure automatic storage scaling rules to achieve automatic resource expansion. The upper limit for automatic scaling is set by the user. When storage is about to overflow, the cluster's storage space can be automatically expanded to ensure the stability of online services. This is mainly suitable for scenarios with large data volumes or frequent and significant fluctuations in business volume.

Set automatic storage scaling

Endpoint optimization

Supports adding two endpoints for multi-data center deployment solutions. When there are two endpoints, only read-only endpoints are supported. When there is one endpoint, the endpoint type can be read-only or read-write.

Add an endpoint

Tenant specification lower limit change

The lower limit for tenant specifications in a cluster instance has been adjusted. The minimum specification for tenants of V3.x and later versions has been changed from the original 2C 5G to 1C 4G. This allows for the creation of more tenants within the same cluster size, which can reduce user costs.

Create a tenant

Backup and restoration enhancement

Supports restoration from a backup set. You can choose a specific point in time to restore from an existing backup set.

Initiate restoration

Backup policy

New region available

The Frankfurt site is now available. It supports the full range of cluster Standard Edition (Cloud Disk) (4C-62C), supports accounts from both Alibaba Cloud China and International websites, and supports pay-as-you-go and subscription billing methods.

Purchase an instance

Feature name

Feature description

References

New features

Temporary upgrade

Subscription cluster instance users can temporarily upgrade their specifications as needed for scenarios such as sales promotions, without affecting the original order discount. They can later gradually scale back to the original specifications.

Schedule a temporary upgrade or downgrade

Temporary upgrade billing

Tenant instance specification change

Supports upgrading and downgrading tenant instances, allowing scaling between 1C and 2C specifications.

Modify package specifications

Modify package specifications for scale-in

Monitoring drill-down and custom monitoring

The monitoring drill-down feature provides data display for the same monitoring metric across different dimensions, assisting in daily O&M analysis.

The custom monitoring capability allows users to configure frequently-used monitoring metrics as a custom monitoring dashboard as needed.

Cluster performance monitoring drill-down

Cluster custom reports

New product

The single data center deployment mode for cluster instances now supports the selection of 3 full-featured replicas (3F).

Purchase an instance

Version adaptation

Version 4.0 is delisted, and version 4.1 is fully available. The corresponding 4C specification is now fully available for purchase.

Purchase an instance

New region available

The Malaysia site is now available.

Purchase an instance

Pricing adjustment

Overall price adjustment, reducing the total price of 4C, 14C, and 24C cluster instances.

Pricing

Feature name

Feature description

References

New features

Added support for schema migration, full migration, incremental synchronization, full validation, and reverse incremental synchronization from MySQL databases to OceanBase database MySQL tenant version 4.1.0 and OceanBase tenant instances.

Migrate data from a MySQL database to an OceanBase database in MySQL compatibility mode

Added support for full validation and reverse incremental synchronization from MySQL databases to OceanBase database MySQL tenant version 4.0.0.

Added support for schema migration, full migration, incremental synchronization, full validation, and reverse incremental synchronization from OceanBase database MySQL tenant versions 2.x and 3.x to OceanBase database MySQL tenant version 4.1.0.

Data migration between OceanBase databases

Added support for schema migration, full migration, incremental synchronization, full validation, and reverse incremental synchronization from TiDB databases to OceanBase database MySQL tenants.

Migrate data from a TiDB database to an OceanBase database MySQL tenant

Added support for full migration, incremental synchronization, and full validation from PolarDB-X 1.0 databases to OceanBase database MySQL tenants.

Migrate data from a PolarDB-X 1.0 database to an OceanBase database MySQL tenant

Added support for nine common batch operations, such as batch start and batch pause, to improve overall O&M efficiency.

Batch operations on data migration tasks

Added support for full and incremental synchronization from OceanBase databases to RocketMQ (Commercial and Community editions).

Synchronize data from an OceanBase database to RocketMQ

Added support for DDL synchronization from OceanBase databases to Kafka. This lets you be promptly aware of schema changes.

Synchronize data from an OceanBase database to Kafka

The destination Kafka, DataHub, or RocketMQ now supports the Debezium JSON format, which facilitates integration with downstream big data ecosystems.

Data format description

You can now set the `cluster_id` (serialization methods: Default/DefaultExtendColumnType) to handle different situations. This feature is suitable for business scenarios such as data cleansing and archive databases.

Added support for dynamic modification of project names, which makes project management easier.

Modify the name of a data migration task

Modify the name of a data synchronization task

Added support for data migration and data synchronization between different Alibaba Cloud accounts.

Cross-account authorization

Added support for tag management. This lets you manage projects and perform batch operations based on tags.

Manage data migration tasks using tags

Manage data synchronization tasks using tags

Added support for removing non-compliant objects during the precheck step. This makes it easier to create projects and improves product usability.

Data migration module documentation

Added support for selecting an incremental synchronization offset when you choose incremental synchronization without full migration.

Feature name

Feature description

References

New features

Binlog service

The Binlog service is used to collect OceanBase transaction logs and convert them into MySQL Binlog format, mainly for scenarios such as real-time data subscription. The Binlog service provides tenant-level activation and management functions and is currently free for a limited time.

Binlog overview

Binlog-related operations

Tenant isolation optimization

Supports cgroup isolation mechanism. With cgroup, CPU resource isolation between tenants can be achieved, along with CPU resource sharing between regular tenants and meta tenants, and request processing prioritization.

Purchase an instance

Cluster instance workbench

Standard Edition (Key-Value)

Standard Edition (Key-Value) is OceanBase's NoSQL database model, which can bypass the SQL engine to directly read data from the storage engine. It also provides a variety of simpler and more efficient non-relational API interfaces, fully leveraging the advantages of the new architecture where NoSQL and SQL coexist to meet the diverse data needs of users in different scenarios. Currently, only 32C and 64C specifications are supported.

Product series

Purchase an instance

Decouple secondary instances

Supports decoupling a secondary instance into a new cluster instance that is independent of the existing primary cluster. This can improve resource utilization and is generally used for scenarios such as business splitting.

Decouple a secondary instance

Convert subscription to pay-as-you-go

Supports changing the billing method from subscription to pay-as-you-go.

View instance list

New version released

New version V4.1.0.0 is released, supporting 2F1A replica mode, which can reduce user costs.

--

Feature name

Feature description

References

New features

Cluster instance scale-in

Cluster instances support scale-in operations, including node scale-in, specification scale-in, and storage scale-in. This is supported for both subscription and pay-as-you-go instances on both Alibaba Cloud China and International websites.

Modify storage capacity for scale-in

Modify package specifications for scale-in

Delete nodes for scale-in

Database and table recycle bin

The recycle bin is mainly used to store information about deleted databases and tables. Users can restore database and table data from the recycle bin. Items in the recycle bin still occupy physical space and can be set to be automatically cleared after a certain period or manually purged.

Cluster database and table recycle bin

Tenant recycle bin

Tenant instance recycle bin

Backup and restoration

Supports local archive backup function, reducing the cost for users to retain backup files for a long time. Files transferred to archive backup must be stored for at least 60 days; if less than 60 days, they will be billed for 60 days. Archive backups do not currently support downloading.

Backup and restoration billing

Backup and restoration overview

Backup policy

Feature description

References

Developer Center Guide

Supports data masking, providing a static data masking function. Data masking policies can be enabled in scenarios such as data export and result set export.

For example: ODC supports built-in masking rules for data such as mailboxes, bank card numbers, fixed-line phones, mobile phones, and ID card numbers. Masking policies are configured by specifying the matching range of database_name.table_name.field_name where the masking rules take effect.

In addition to built-in rules, you can also configure custom masking rules. ODC supports masking algorithms such as redaction, character replacement, format preservation, hash encryption, rounding, and nullification.

Data masking management

Supports shadow table synchronization, which automatically creates and synchronizes the shadow table structure in the same database based on the source table's structure.

Shadow table synchronization

Shadow table synchronization task

Supports partition plan function, which automatically pre-creates and deletes expired RANGE and RANGE COLUMNS partitions.

Partition plan

Partition plan task

Supports SQL plan tasks, which allow for the scheduled, periodic execution of user-created SQL scripts to meet the needs of periodic database development and O&M tasks.

SQL plan

SQL plan task

Supports automatic authorization rules. Administrators of the public resource console can automatically grant specific roles or permissions to users who meet certain criteria, such as name, department, or logon method, upon their initial logon or user creation. This avoids many redundant authorization operations.

Automatic authorization rules

SQL window optimization:

• Before executing an SQL statement, you can choose whether to enable Get result set column information. When a table has many columns, disabling this option will prevent the query from fetching column comments and editable column information, thus reducing SQL execution time.

• When editing a result set, the size limit for CLOB large objects is adjusted (text within 2 MB, hexadecimal within 200 KB, and images within 20 MB).

• When editing a result set, you can output specified rows to the clipboard.

• The status bar of the result set supports displaying field types and field remarks.

• Supports SQL specification checks. When editing SQL statements in the SQL window, creating database change tasks, and creating tables, SQL specification checks are supported.

SQL window

Import and export:

• Supports skipping the first row when importing a single table from a CSV file.

• When exporting only the structure, supports merging DDL into a single SQL file and sorting it according to foreign key dependencies.

• When exporting, you can set a size limit for a single file, including unlimited, 64 MB, 512 MB, 1024 MB, and 2048 MB.

• Uses TO_DATE and TO_TIMESTAMP functions when exporting SQL statements for date types.

Batch export and import

Single table export and import

Export and import task list

Export task

Feature name

Feature description

References

New features

Backup and restoration

Supports restoring a cluster to the region where the geo-redundant backup is located using the geo-redundant backup file. Supports initiating a restoration from a destination cluster using the geo-redundant backup file of another cluster in the same region.

Logical backup supports incremental data backup, ensuring data consistency of tables without downtime.

Initiate restoration

Back up now

Data backup

Security assessment

A security assessment menu has been added to the security settings. It supports detecting and assessing the overall database security, including cluster and tenant check items. Users can navigate to the specified module for security configuration based on the assessment recommendations.

Security assessment

New specifications released

Large specification 104C is released. The list of expansion specifications has been adjusted and is controlled by a whitelist.

Purchase an instance

Increase the number of nodes

Node expansion can go up to 45 nodes, i.e., 15-15-15. The previous maximum was 18 nodes.

Delete nodes for scale-in

OceanBase 4.0 version

Expanded purchase options: Supports various specifications such as 4C, 8C, 14C, 24C, 30C, 62C, and 104C, giving users more choices.

All specifications support expansion: Supports specification expansion, storage expansion, and node expansion capabilities, helping invitational preview users and those who purchased small specifications to smoothly transition to higher specifications for production use.

Purchase an instance

Delete nodes for scale-in

Modify storage space

Modify package specifications

Standby instance

Supports adding a secondary instance to a cluster instance to form a primary-multiple-secondary cluster network. Data is synchronized between the primary and secondary instances through asynchronous log replication. When the primary instance is unavailable, the secondary instance can take over the service, providing disaster recovery capabilities and minimizing service downtime.

Cluster instance workbench

Add a secondary instance

Add a primary endpoint for a secondary instance tenant

Autonomy service

Supports summarizing the capacity risks of all existing clusters, reflecting resource shortages, assessing whether expansion is needed, whether there is operational pressure, and reminding users to perform O&M operations in advance to avoid capacity risks.

Capacity diagnosis

Feature name

Feature description

References

New features

Tenant instance (MySQL mode)

Tenant instances (1C 4G and 2C 8G) can be used independently as a database instance. Under a tenant instance, you can create databases and tables separately, providing services to upper-layer applications independently.

This is mainly for developer users or scenarios with small data volumes that do not have very high availability requirements. It is not recommended for enterprise core business or other high-availability scenarios.

Free trial for small-specification tenants

Tenant instance workbench

Common operations for tenant instances

Read/write splitting

Supports read/write splitting, where reads are by default allocated to secondary replicas and writes to the primary replica. This achieves replica separation for read and write operations, enabling multi-endpoint, multi-replica load balancing and better separation of read and write transactions.

Add an endpoint

Primary zone distribution

Supports the distribution of primary zones in multi-node scenarios and the ability to modify primary and read-only endpoints. This works with read/write splitting to add functionality for read and write access endpoints.

Switch primary zone

Feature name

Feature description

References

New features

Added support for smooth migration and synchronization from MySQL 5.5 to OceanBase databases.

MySQL database migration

The display of full migration and validation performance data and baseline data is now available. This makes it easier for you to identify performance issues.

Start a data migration project

Added support for the partition import function, which improves full migration performance and saves overall migration time.

Full validation provides a new data validation method, which improves full validation efficiency.

Added support for one-click skipping of unsupported incremental DDL statements. This simplifies user operations and improves link stability.

Added support for displaying incremental synchronization performance data, which makes it easy for you to identify performance issues.

Added support for displaying incremental synchronization DML/DDL statistics. This provides an intuitive experience of link efficiency and change object tracking.

Added support for importing and exporting objects and object settings in CSV format. This allows for easy batch settings and cross-environment migration, which improves work efficiency.

Download and import migration object configurations

Download and import synchronization object configurations

Eleven common OpenAPI interfaces are now available to meet your automation needs.

API overview

Added support for Kafka cross-cloud transmission scenarios.

Create a data source (Kafka)

Enhanced guidance is provided for setting project alerts to achieve real-time project monitoring and assurance.

Set alerts

Feature name

Feature description

References

New features

Autonomy service

This section describes how to connect to the autonomy service. You can connect clusters that are in the running state to the autonomy service.

Multi-tab writing

This section describes how to use real-time diagnosis. The real-time diagnosis page lets you view SQL running status, session analysis, and more.

Real-time diagnosis overview

This section describes how to use the capacity center. The capacity center shows you the data volume trend of system tables.

Capacity diagnosis

This section describes how to use security management. Security management provides you with the SQL Audit feature.

Security assessment

This section describes how to use optimization records. By querying optimization records, you can view the operation history of cluster plan binding and index binding.

Optimization records

Feature name

Feature description

References

New features

Data migration

Added support for data migration from OB_MySQL (Alibaba Cloud instance) to MySQL (RDS, PolarDB, VPC, Database Gateway, or public network).

Create a data migration project from an OceanBase database MySQL tenant to a MySQL database

Added support for data migration from an OceanBase (Alibaba Cloud instance) to another OceanBase (Alibaba Cloud instance).

Create a data migration project from an OceanBase database to an OceanBase database

Added support for migrating tables without unique keys from MySQL to OB_MySQL.

MySQL database migration

Added support for automatic database creation from MySQL to OB_MySQL.

Data synchronization

Added support for data synchronization from OceanBase databases to DataHub (VPC or public network).

Create a data synchronization project from an OceanBase database to DataHub

Added support for data synchronization from OB_MySQL (Alibaba Cloud instance) to OB_MySQL (VPC).

Create a data synchronization project from an OceanBase database to an OceanBase database

Usability improvements

Optimized the process so that table processing failures during schema migration, full migration, and full validation do not affect project operations.

--

A forced character set conversion capability is now available to support more data source character set compatibility scenarios.

--

Feature name

Feature description

References

New features

Archive database

To solve the problem of reading and updating historical data, an archive database is provided to store archived data. A low-cost storage solution that uses large-capacity mechanical disks effectively reduces the storage cost of historical data. The archive database also includes a query function, which lets you enjoy the cost-effectiveness benefits of the archive database.

Standard Edition (Archive Database)

Support for local disks

Added support for locating the database storage and database engine on the same node. This provides high I/O performance and low read/write latency to meet the high IOPS performance requirements of some business systems.

Standard Edition (Local Disk)

TDE integration with Alibaba Cloud KMS

Added support for hosting TDE keys in Alibaba Cloud KMS to meet relevant regulatory compliance requirements.

Enable TDE transparent encryption

Feature optimizations

Data Transmission

Added support for automatic synchronization of incremental DDL when you migrate from MySQL to OceanBase MySQL. Added support for reverse incremental synchronization back to MySQL after you switch to OceanBase MySQL.

Create a data migration project from a MySQL database to an OceanBase database MySQL tenant

Data synchronization efficiency is significantly improved, with support for synchronization to different topics in a single project. Full migration performance is enhanced. For example, indexes are created after full migration, and reading and writing data by partition is supported.

Create a data synchronization project from an OceanBase database to DataHub

The capability of synchronizing data from OceanBase to AnalyticDB for MySQL is continuously optimized and enhanced, with support for partial automatic DDL synchronization from OceanBase MySQL to AnalyticDB for MySQL.

Create a data synchronization project from an OceanBase database MySQL tenant to AnalyticDB for MySQL

Usability and user experience are optimized. The user interface for renaming databases and tables is optimized. The display of incremental synchronization data volume and latency monitoring curves is supported. The product is now fully internationalized.

Data development

Enterprise-level control functions are provided, such as task flow change management, risk data determination and operation audit, and SQL audit, to ensure the security of your data assets and meet various audit requirements.

Data development (log on to a database)

Task flow management

Operation record management

Export and import task list

Export task

Analog data task

Database change task

Added support for ODP (Sharding) OceanBase MySQL data sources. Recycle bin management capabilities are provided. The SQL execution window now has an independent session design. Support for exporting functions and stored procedures and uploading multiple script files is added.

Create a data source

Public connection management

Use the recycle bin

SQL window

Saved scripts

Optimized PL/SQL execution details.

Run a PL statement

Usability is improved. Added support for online editing of CLOB fields smaller than 200 KB.

The system is optimized to display more effective prompt information, such as line numbers and positions, when a PL compilation error occurs.

The product is now fully internationalized.

Result tab

PL editing area

Feature name

Feature description

References

New feature

First release of OMA on public cloud

OMA is a database compatibility assessment tool provided by OceanBase. It offers precise compatibility assessment, SQL assessment optimization, and application transformation suggestions for migrating to OceanBase, helping users achieve an efficient and smooth migration to the distributed database OceanBase.

What is OceanBase Migration Assessment

Feature name

Feature description

References

Feature upgrade

OceanBase data synchronization to ADB

Upgraded OceanBase MySQL tenant data synchronization to ADB. Supports schema synchronization, full data synchronization, and incremental data synchronization. Provides database and table renaming, custom partition keys and distribution keys, and partial DDL synchronization capabilities.

Create a data synchronization project from an OceanBase database MySQL tenant to AnalyticDB for MySQL

Feature name

Feature description

References

New features

Support for SQL Audit capability

For internal compliance scenarios, supports operation audit of SQL records in the cluster console by database, node, keyword, time range, username, operation type, etc. Also supports exporting SQL records.

Diagnosis overview

SQL basic information

Fast storage expansion

Supports fast expansion of ESSD cloud disks, improving customer experience.

Purchase a cluster

OceanBase data synchronization to Kafka

Added support for real-time data synchronization from OceanBase instances to Alibaba Cloud Kafka instances and self-managed Kafka instances in a VPC. Provides five types of JSON serialized message formats.

Create a data synchronization project from an OceanBase database to Kafka

Feature name

Feature description

References

New features

Commercialization of backup and restoration

The OceanBase backup and restoration features are free to use, but backup files occupy a certain amount of storage space. The storage medium is OSS.

After successfully purchasing a cluster, a backup and restoration order will be generated for you.

Backup and restoration billing

New service account authorization feature

You can use the service account authorization feature to grant permissions for configuration, index querying, data, etc., to Alibaba Cloud technical support personnel.

Service account authorization

Feature name

Feature description

References

New

New OpenAPI

Supports users managing clusters through OpenAPI, including creating and deleting tenants, users, and databases under the cluster. Users can manage OceanBase clusters on their existing O&M management platform.

API overview

Developer Center supports permission control

Administrators can configure permissions for regular users (including whether to allow creating personal connections, whether they have access to public connections, and read/write control over public connections).

Overview

Supports data synchronization between OceanBase MySQL tenants

The OceanBase data transmission feature supports synchronizing data from physical or logical tables of an OceanBase database MySQL tenant to another OceanBase database MySQL tenant.

Create a data synchronization project from an OceanBase database to an OceanBase database

Feature name

Feature description

References

New

8C 32G model released, significant cost-performance improvement

Supports the sale of 8-core 32G models. Currently available for sale in the Hangzhou non-finance region, supporting single data center deployment mode, which greatly lowers your entry barrier.

Pricing

Supports multi-Unit deployment for tenants

When creating a tenant, you can select the number of Units to deploy the same tenant across multiple Units, improving the tenant's distributed capability.

Create a tenant

New data synchronization feature

The data synchronization feature helps you achieve real-time data synchronization between OceanBase physical tables and self-managed Kafka, RocketMQ message queues, expanding message processing capabilities. It also supports real-time data synchronization between Sybase ASE and self-managed RocketMQ terminals.

Supported databases and migration types

Other

Product usability improvement

The cluster and tenant management functions have been redesigned. Through a graphical interface, they provide you with clearer O&M information.

--

Quick BI/DataV supports OceanBase data source

OceanBase cloud service supports using OceanBase as a data source in Quick BI and DataV products, and supports data interaction via internal network.

--

Feature name

Feature description

References

Database development and management

SQL window supports DBMS output

The SQL window supports DBMS output. When running a PL statement in the SQL window, the result tab supports displaying the return information of the DBMS statement.

SQL window

Result set interaction optimization

In the result set, you can drag column names to adjust the column order, filter and sort fields by value, and use the Copy and Set to Null operation keys.

SQL window

Schema switching

In Oracle mode, after entering a connection, you can perform a schema switch operation in the navigation bar at the top of the workbench.

Manage connections

Asynchronous execution

An asynchronous execution tool has been added. When a synchronously executed statement in the SQL window runs for too long, an execution timeout may occur. You can use the asynchronous execution tool to run time-consuming SQL statements to avoid statement execution timeouts.

Asynchronous execution

Analog data

ODC provides an analog data feature for you to quickly generate data based on the field types in a table, for scenarios that require a large amount of simulated data, such as testing database performance or verifying functions.

Analog data

Feature name

Feature description

References

Support for log replicas

By setting the third replica as a log replica, storage and computing resource costs are reduced without affecting performance, improving cost-effectiveness.

Standard Cluster Edition

Standard Edition (Archive Database)

New security group whitelist grouping feature

Supports whitelist grouping and editing.

Whitelist

New SSL link encryption feature

ApsaraDB for OceanBase supports SSL link encryption to ensure secure data transmission between the client and the server.

SSL link encryption

New TDE transparent encryption feature

ApsaraDB for OceanBase supports Transparent Data Encryption (TDE), which can encrypt data at rest.

Enable TDE transparent encryption

Experience optimization

Includes improvements to monitoring capabilities and experience optimizations for operations such as lists and searches. For details, log on to the OceanBase console to experience.

--

Feature name

Feature description

References

New Basic Edition series service

Supports hourly billing for storage capacity based on actual usage.

Create a cluster

Optimized backup and restoration feature

• Optimized display information in the backup list

• Optimized backup policy

• Added off-peak operation prompt text in backup policy and immediate backup

Backup and restoration overview

Initiate restoration

Back up now

Data backup

Backup policy

Data restoration

New merge feature

Supports manual merging of cluster data.

Tenant overview

Feature name

Feature description

References

New tenant parameter management feature

Lets you view the tenant's parameter list, modify parameters, and view parameter modification history.

View tenant parameter list

Supports vertical scaling, storage space expansion, and subscription renewal

• You can expand storage space only when all tenants in the cluster are in the Running state. The expansion process causes a brief service interruption. Perform this operation during off-peak hours.

• Supports monthly renewal.

Cluster workbench overview

Added resource tag feature

Each cluster can have up to 10 tags. You can also add or delete tags through Manage Tags.

Cluster list

Database development and management

The Config URL connection method for OceanBase database in MySQL mode has been removed.

Create a connection

Optimized the connection password modification method.

Manage connections

Supports viewing execution plans in text format.

SQL window

Feature name

Feature description

References

New cluster parameter management feature

The parameter management feature lets you view the parameter list, modify parameters, and view parameter modification history.

View parameter list

Modification history

Parameter list description

Supports displaying disk usage

Monitors cluster node data and supports monitoring of disk usage.

Monitor a cluster

Added account permissions

Multiple permissions have been added to the account types, and user permission settings are supported in RAM access control.

Create an account

Permission policy management

Supports purchasing across multiple zones

When deploying in multiple data centers, you can deploy three nodes in three different zones to achieve cross-zone disaster recovery at no extra charge.

Create a cluster

Feature name

Feature description

References

Monitoring and alerting feature

Supports creating alert rules and managing them by viewing, adding, modifying, or disabling them.

Add an alert rule

Manage alert rule list

Whitelist modification entry optimization

An entry has been added to the page, allowing you to directly manage the whitelist.

Cluster workbench overview

Subscription purchase type displays expiration time

Provides service expiration date reminders or expiration notices.

Cluster workbench overview

Database development and management

Creation and management of package objects

Provides a visual interface for creating and managing package objects.

Package overview

Create a package

Manage packages

Creation and management of sequence objects

Provides a visual interface for creating and managing sequence objects.

Sequence overview

Create a sequence

Manage sequences

Table creation optimization

• Optimized the interaction for column editing during table creation.

• Optimized the interaction for partition settings during table creation.

Create a table

SQL window optimization

• Supports using delimiters to edit PL statements in the window.

• Some common tools have been added to the window toolbar. Also, right-clicking a window tab provides a list of common management operations.

• Supports directly dragging windows in the workbench to adjust their order.

• Supports flexible selection and copying of data from the result tab to an external file.

• When the data in a result set cell is too long to be fully displayed, you can hover the mouse pointer over the target cell to preview all the data in the cell.

SQL window

Anonymous block window

A workspace for database developers to edit anonymous block scripts. Supports editing and running PL statements.

Anonymous block window

Connection creation optimization

Supports advanced information configuration, allowing customization of timeout and sys view access users.

Create a connection

Connection management optimization

• Optimized the connection configuration card, which now directly displays the current connection status.

• Added an automatic session save feature. When a connection is forcibly disconnected, the last edited window is automatically restored upon reconnection.

Manage connections

Manage sessions

• Supports viewing and fuzzy searching of database sessions.

• Supports closing sessions individually or in batches.

• Supports closing the current query of a session individually or in batches.

Session management

Recycle bin management

• Supports viewing and fuzzy searching of recycle bin objects.

• Supports emptying the recycle bin.

• Supports purging objects individually or in batches.

• Supports restoring objects individually or in batches.

Use the recycle bin

Improved database object management

• Supports creating and viewing PRIMARY KEY constraints.

• Supports creating, viewing, and deleting UNIQUE constraints.

• Supports displaying, compiling, and running structure tree information for functions, stored procedures, and package objects.

Create a table

Table list

Table attribute management

Manage views

Manage functions

Manage stored procedures

Manage sequences

Manage packages

SQL console: Comprehensive features

• Displays the execution plan of an SQL statement.

• Views the actual execution plan of an executed SQL statement.

• Views the resource consumption during SQL execution.

• Supports editing operations such as adding, deleting, or modifying the result set.

• Supports viewing query results and supports column mode.

• Supports exporting the result set.

SQL window