Double Leap in Usability and Ease of Use | OceanBase Community Edition 3.1.2 Officially Released

On January 6, at the DC2021 Distributed Database Developer Conference, OceanBase CTO Yang Chuanhui announced the official release of OceanBase Community Edition 3.1.2.

The new version includes three core technology upgrades :

First, the spike performance has been improved by 300%; second, the ecological adaptation has been fully accelerated, supporting Hbase docking capabilities; third, the new community version tool system (community version OCP, community version ODC, community version OMS) has been launched to provide white screen Complete functions such as cluster management, tenant management and control, development and debugging, data synchronization, import and export, help community users to get started quickly.

New version features and user value express

• Launched the community version of ODC, a graphical application development tool for developers
• Launched the community version of OCP, a database enterprise management platform for administrator users
• Launched the community version of OMS, a graphical data migration tool for enterprise application migration
• Row lock waiting is deeply optimized, and the lock time is greatly shortened on the premise of ensuring data consistency, and the performance of e-commerce seckill scenarios is greatly improved by 300%
• Added online rolling upgrade capability, providing online cross-version upgrade capability, the entire upgrade process requires no manual intervention and does not affect business operations

01. Launched the community version of ODC, a graphical application development tool for developers

OceanBase Community Edition ODC (Developer Center) is a development platform tailored for OceanBase database. It provides database developers with a variety of capabilities such as visual management of database objects, intelligent grammar, session management, recycle bin management, import and export, and unified management of resources and permissions.

The core functions of the Community Edition ODC are as follows:

multi-window development mode: Community Edition ODC provides SQL window, anonymous block window and command line window development mode. You can choose to open the corresponding mode window for development according to your own habits. The SQL window and anonymous block window support advanced functions such as intelligent association prompts, syntax highlighting, and formatting.

Rich result set management: supports the interactive operation of the result set table, and can export all and part of the query result set in the SQL window.

Flexible import and export: supports files in SQL, CSV and other data formats, and can import and export single-table, multi-table or whole database data at one time. Supports separate or mixed import and export of defined objects and table data.

Collaboration management: built-in management and control platform, you can edit the roles and permissions of user groups, manage connection resources, and improve the efficiency of enterprise collaboration management.

02. Launched the community version of OCP, a database enterprise management platform for administrator users

The Community Edition OCP (Operation and Maintenance Monitoring Tool) is an enterprise-level database cluster management platform tool tailored for the OceanBase database. Users can manage and operate resources such as hosts, networks, software packages, etc. through the Community Edition OCP, manage the full life cycle of clusters and tenants, and reduce IT operation and maintenance costs. The core functions of the Community Edition OCP are as follows:

Cluster Management : Supports functions such as cluster installation, operation and maintenance, performance monitoring, configuration, upgrade, deletion, host addition and deletion.

Tenant management: supports tenant creation, structure topology, performance monitoring, session management and parameter management.

monitoring alarms: supports monitoring alarms in three dimensions: cluster, tenant, and host. You can use built-in alarm items or custom configuration alarm items, and you can select HTTP channel or script channel to deliver alarm messages.

system management: supports viewing and managing running tasks, and configures them according to business-defined parameters.

Security: supports creating, modifying or deleting database users and roles, granting and reclaiming role permissions. You can manage the personal settings, passwords, and alert subscriptions of community edition OCP users through the User Center.

03. Launched the community version of OMS, a graphical data migration tool for enterprise application migration

Users can implement data migration between heterogeneous databases and OceanBase databases through the Community Edition OMS (Data Migration Tool). The community version of OMS supports the continuous online migration of heterogeneous databases to the OceanBase database. At the same time, after the application is switched to the OceanBase database, all the changed data on the database are synchronized to the source database before the switch in real time. You can use the management console to create data transfer projects, customize task configurations, and monitor operational transfer components. The core functions of the Community Edition OMS are as follows:

• Support database object migration, including automatic export, conversion and creation of tables, constraints, and indexes.
• Full data migration is supported.
• Support incremental data migration: Migrate real-time incremental data from the source to the target through log parsing.
• Support full data verification: data comparison of all fields of source and target table data, and provide revised SQL statements for inconsistent data.
• Support reverse incremental migration after switching: When the business switches the application to the (source) target data source, the incremental data of the target end is synchronized back to the source end in real time.
• MySQL 5.6 and 5.7 are supported.
• Support user-defined alarm settings.
• Support operation and maintenance monitoring: including host monitoring, component monitoring, and component operation and maintenance.

04. Row lock waiting is deeply optimized, and the performance of seckill scenes is greatly improved by 300%

In the business scenarios of enterprise users such as the Internet and e-commerce, the concurrent update processing of hot data has extremely important appeals and applications, although it can be achieved by intrusive modification of business logic or merger optimization in the transmission link. However, the hot update performance of the database kernel has always restricted the rapid development of the business. OceanBase Community Edition improves the concurrent update performance of OceanBase in processing hot data from 3000 TPS to 9000 TPS by optimizing the lock for write locking logic and releasing row-level locks before filling the log, greatly expanding the hotspot update capability by releasing row lock technology in advance. The upper limit can help the enterprise business resist traffic peaks, and can also reduce the cost of adaptation development in the long-term business development process.

05. Added online rolling upgrade capability to support cross-version upgrades

With the gradual increase in the application of OceanBase Community Edition, we found that database online upgrade technology is no longer an exclusive demand for core business scenarios such as finance and operators. Improving data service capabilities and quality is related to the product competitiveness of various businesses. OceanBase Community Edition provides online kernel version upgrade capability. Users can easily upgrade and replace the kernel of a database cluster with the obd cluster upgrade command. Thanks to OceanBase's majority protocol and multi-copy strategy, OBD automatically identifies the optimal cross-version upgrade path strategy based on matching the specified upgrade target, adjusts the business response priority by switching the Primary Zone status, and upgrades the Zones one by one. Realize the upgrade plan with non-stop data service and non-stop business.

Every release is a fresh start

On June 1, 2021, OceanBase officially announced open source. Through the joint efforts of the community, within 7 months, the community will work together to complete 3 version iterations. The 3.1.2 version released this time further optimizes the kernel, improves the performance of e-commerce scenarios, accelerates the improvement of ecological adaptation, and launches the community version tool system, which greatly improves usability while consolidating usability.

Here, I would like to thank every developer in the OceanBase open source community for their contributions and every OceanBase user for their valuable suggestions for product improvement. Every release is a new beginning. OceanBase Community Edition will continue to accelerate iteration and optimization in subsequent versions to meet more scenarios and bring users a better experience.