Shulou(Shulou.com)06/01 Report--

On November 19, 2019, Ant Financial Services Group officially released a brand-new OceanBase2.2 version at a press conference with the theme "Peak Hole see focus on New Financial Technology" held in Beijing. It is reported that OceanBase is the world's first distributed relational database applied to the core financial business developed by Ant Financial Services Group. At present, in addition to supporting Ant Financial Services Group's own business and Alibaba Group's Singles Day traffic test, it also supports the business of dozens of commercial banks and financial institutions, and is at the top in the latest TPC-C test ranking released this year.

The release of OceanBase version 2.2 is a milestone version that is compatible with both MySQL and Oracle modes, and introduces many popular features in Oracle mode, with a significant improvement in performance and stability compared with version 2.0.

What's New in OceanBase 2.2

1) New features

A) stored procedure / client protocol

The first version of PL/SQL compatible with Oracle is officially launched, providing basic PL/SQL capabilities. Subsequent versions continue to enhance the support for PL/SQL. Some Oracle-compatible PL/SQL system packages are available to facilitate Oracle users to support binary prepare statement protocol and improve the performance of application calling database execution.

B) enhanced SQL functionality

Support all Oracle basic data types except binary float/double, as well as BLOB/CLOB (maximum length limited) support MINUS,ROLLUP, GROU;PING and other SQL syntax, as well as a large number of window function support, better support users complex analysis query need to support Oracle compatible NLS series length and time date type settings, provide rich time and date format and conversion support

C) SQL execution plan management

Compatible with the SQL Plan Management function of Oracle management interface, it supports solid management and automatic evolution of execution plan, ensures the stability of system operation and upgrade, and reduces the complexity of operation and maintenance.

D) enhanced transactional capacity

Flashback query Enhancement (Flashback Query), provides historical data query support for serialized isolation level (the strongest transaction isolation level for relational databases), and provides native support for application scenarios with strong transaction isolation requirements

2) Stability improvement

The stability of the cluster is greatly improved, the distributed transaction runs stably, the maximum number of rows in a single table reaches trillions, and the maximum amount of data in a single cluster exceeds 3 PB.

3) scalability improvement

Oracle schema single tables support up to 65536 partitions.

4) compatibility enhancement

Compatible with MySQL 5.6and Oracle 11.2 (ongoing development support).

5) performance enhancement

Compared with version 2.0, the performance of OLTP is improved by more than 50%, and the query optimization and execution ability of some complex scenarios is significantly improved. With all 22 queries in TPC-H, the total execution time of 6 ECS (56 hyperthreading) Server is 730s under the data volume of SF=1000 (1TB).

In addition, this upgrade also supports 150+Oracle compatible functions and expressions, 30 dictionary views, 30 performance views, and so on. Added support for serialized isolation levels to provide better support for scenarios with higher transaction isolation requirements.

Oracle compatibility was previously the focus of the OceanBase team. The goal of the OceanBase team is to achieve a smooth migration of Oracle business in two years without changing a single line of code or making any adjustments to the business. The release of OceanBase 2.2 is a major milestone in the compatibility process, and OceanBase also hopes to serve more customers and partners in the financial industry so that technology can benefit business development.

Iterative History of OceanBase version 2010: founder Yang Zhenkun joined Alibaba and OceanBase officially established the project. 2011: OceanBase 0.1 version was released and officially launched in Taobao favorites, which greatly reduced the number of database servers in Taobao favorites business.

OceanBase version 0.1 architecture diagram

2014: the OceanBase0.5 version was released, introducing the Paxos protocol to ensure that the main database will not lose data when it fails, and successfully replacing Oracle to launch the Alipay trading system, supporting 11.10% of the traffic. 2015: the OceanBase0.5 version was launched in Alipay's transaction base and payment bank, and in the same year, OceanBase launched online merchant bank, becoming the world's first distributed relational database applied to the financial core business system. 2016: the OceanBase1.0 version was launched in Alipay's accounting system, supporting a peak of 120000 payments per second in Singles' Day in 2016.

OceanBase version 1. 0 architecture diagram

2017: OceanBase released version 1.4, with continuous improvement and significant improvement in performance, adding dump function, hierarchical query function, and introducing parallel index creation technology. At the same time, Alipay moved all the core data links, including the account library, to OceanBase for the first time, setting a new record of 42 million database processing peaks per second. In the same year, OceanBase 1.4 was successfully launched in commercial banks other than Alibaba / Ant Financial Services Group. 2018: the OceanBase2.0 version is officially released. The product features are greatly enhanced, supporting global consistent snapshots, global indexes, real-time effective indexes, flashback queries, online partition splitting and other features. At the same time, the compatibility is fully improved, supporting MySQL / Oracle dual compatibility mode, and is also the first native distributed database that supports stored procedures. Compared with version 1.4, the performance of OLTP scenarios is improved by more than 50%, and the storage cost is reduced by 30%. OceanBase version 2.0 comprehensively reduces the technical risk of the financial business's transition to a distributed architecture.

OceanBase version 2.0 architecture diagram

2019: the OceanBase2.2 version was officially released, breaking the world record for database benchmark performance testing with twice the score of Oracle (Oracle), winning the top ranking of TPC-C benchmark performance, and becoming the first distributed shared relational database audited by TPC-C in the world. In Tmall's double 11 in 2019, OceanBase broke the world record again, setting a new record with a peak of 61 million requests per second.

Welcome to subscribe "Shulou Technology Information " to get latest news, interesting things and hot topics in the IT industry, and controls the hottest and latest Internet news, technology news and IT industry trends.