2021 OceanBase Open Source Semi-Annual Report | Don't forget the original intention, be grateful to the peers

On June 1, 2021, OceanBase was officially open sourced.

Looking back at the past 213 days, with the support and co-construction of more than 23,000 community users, OceanBase has started to walk fast from a stumbled open source "school child".

In 2021, OceanBase Community Edition has received positive comments from many developers and industry users, reaching more industries and application scenarios. It has been tried and used in the production environment of users in the Internet, banking, insurance and other industries. 100 customers have carried out in-depth practice, more than 100 developers have joined, attracted 23,000 community users, won the recognition of more than 4,000 developers around the world, and generated more than 640 technical collisions (Commits).

01. Open source original intention, do difficult and right things

OceanBase CEO Yang Bing once pointed out: "There is no shortage of a database company in China, but there is a lack of a high-end database that can really complete the core upgrade. OceanBase has been doing difficult and correct things since its inception. We insist on open source, and hope to be able to We will share with you the technologies accumulated by OceanBase over the past 12 years, connect more developers, and better explore the distributed field together. We also hope that our products can go to a wider range of scenarios and further promote the development of database technology. "

On June 1, 2021, OceanBase announced the official open source and established the OceanBase open source community. "Open source is a very good way to combine upstream and downstream and ecological partners to polish the product, which can not only make the product more mature, but also make the product more vigorous," said Feng Zhongyan, OceanBase Open Source R&D Director.

02. Seriously polish each version and continuously optimize the service experience

With everyone's positive feedback, OceanBase Community Edition has been continuously enriched and improved. Up to now, OceanBase has released a total of three versions, which have greatly improved usability and ease of use.

Version 3.1.0: It marks the open source of the OceanBase kernel. It adopts the Mulan public protocol to open 3 million lines of core code, and builds ecological tools through open source OBDeploy/OBClient/OBProxy;

Version 3.1.1: Compatible with MySQL 5.7, support Table API, upgrade 30+ kernel features, complete 20+ ecological tool adaptation, 10 minutes one-click installation and deployment;

Version 3.1.2: Seckill performance in e-commerce scenarios has been improved by 100%, in-depth optimization of row lock waiting has been completed, online rolling upgrade has been added, and version upgrades can be performed without stopping. The ecological adaptation is fully accelerated, supports the re-expansion of the Hbase API big data ecosystem, is compatible with the independent operating system UOS, and obproxy fully supports mainstream operating systems. Launched the community version OCP/ODC/OMS tool system: providing complete functions such as white screen cluster management, tenant management and control, development and debugging, data synchronization, import and export;

Open source co-creation and co-construction, the OceanBase open source community is inseparable from the joint maintenance and creation of every developer. OceanBase will always stand with developers, constantly improve the quality and experience of products in practice, and constantly upgrade open source versions. Good performance and a more convenient user experience to give back to the community.

03. Open and transparent, accelerate embrace and support the open source ecosystem

In 2021, in terms of open source, we will solve the problem of OceanBase's usability at the core. While actively embracing the ecology and making various tools, we will practice "internal skills" and write user manuals (documents) to continuously optimize the service experience.

Open source for 213 days, we listened to the voices of our community partners. With the support of our community partners, we have developed a variety of practical components and tools. Currently, we have supported 20+ open source ecological tools, all of which have been open sourced and contributed to community developers. .

In June, OBClient was incubated in the Mulan community;

In July, the ecological tool projects Canal, DataX, DBeaver were launched;

In September, OBAgent was developed to support the connection between Prometheus and Grafana, and to deploy OceanBase database using Docker;

In December, K8S docking was realized.

......

In the future, we look forward to working with more community developers to continuously optimize the service experience.

04. Financial scenarios are moving towards multiple scenarios, and products and services are constantly being upgraded

Helping enterprises avoid detours and make good use of the advantages of open source to realize business value is the focus of OceanBase. From finance, but not limited to finance, we aim to help companies continue to innovate and improve, grow and progress together with them.

Nearly 300 times faster, OceanBase Community Edition helps Hexaprism achieve a new leap in performance

With the continuous growth of the data volume of Hexaprism, when the data is written into the MySQL environment after being cleaned and processed by the big data cluster, the writing time increases with the increase of the data volume, the concurrency increases, the time-consuming time becomes longer and longer, and timeouts, Performance bottlenecks such as task interruption, and data transfer into and out of the warehouse also become slow and inefficient.

By smoothly migrating MySQL data to OceanBase, it helps Hexagon reduce costs and improve efficiency: storage space usage is greatly reduced, operation and maintenance are more convenient, resource utilization is improved, and high availability is guaranteed.

Write performance increased by an average of 3 times, OceanBase Community Edition helps Ctrip reduce costs and improve efficiency

With the diversification of technology and the continuous development of business, MySQL has gradually been unable to meet the needs of Ctrip. It is mainly reflected in: the diversification of business data models, the need for remote multi-active deployment, operation and maintenance costs, resource flexibility management, and application stability. Database technology has put forward new requirements. The MySQL solution has obvious performance bottlenecks on a single machine. At the same time, the sub-database sub-table solution brings increased operation and maintenance complexity and maintenance costs.

Facts have proved that after preliminary testing and later practice, OceanBase's technical features and architecture are relatively in line with Ctrip's project requirements. Ocean Base's multi-site multi-site multi-writing, large-scale promotion of flexible expansion, and high-availability switching have little impact on business, all of which are very suitable for Ctrip's needs. At the same time, it has achieved good benefits in terms of performance and cost: in terms of performance, the OceanBase solution improves the read performance by an average of 2 times and the write performance by an average of 3 times; in terms of cost, the OceanBase solution saves 2/3 of storage resources and greatly reduces the hardware cost.

In addition to the above case scenarios, OceanBase also leverages its own technical and experience advantages to help companies solve technical problems together in e-commerce, new energy, short video and other fields, and enhance their business value.

05. Expand the talent ecology and accelerate talent training

It is better to teach a man to fish than to give him a fish. OceanBase hopes to help more database enthusiasts to apply what they have learned and promote the development of talents in domestic databases.

Based on this, OceanBase continues to launch a variety of projects and activities to achieve a full-coverage training model from tutorials, lesson plans, teaching aids, teachers, training bases, competitions, and certification to help every developer and help society cultivate database talents. In 2021, through open source, OceanBase will contribute 1500+ certified talents to the society.

1 set of tutorials: The first introductory practical tutorial for native distributed databases, explaining in simple terms how to quickly master the practical skills of OceanBase and enhance the core competitiveness of the workplace.

3 sets of teaching plans and teaching materials: jointly develop distributed database professional teaching materials and practical plans in cooperation with Northeastern University, Fudan University and Wuhan University.

Teaching aids: Cooperate with Professor Yang Xiandi of Wuhan University to develop MiniOB practical teaching aids to enhance the practical ability of college students in database development and lower the threshold for learning databases.

6 talent training bases in colleges and universities: East China Normal University, Wuhan University, Zhejiang University, Northeastern University, Zhejiang Sci-Tech University, Huazhong University of Science and Technology.

1 competition: The first OceanBase database competition attracted a total of 246 universities and 200 companies to sign up to participate, and a total of 1,842 contestants from 1,179 teams competed fiercely.

06. Improve the community ecology and nurture an active open source community

Since its open source on June 1, the OceanBase open source community has gathered more than 23,000 community users, and has output in-depth solutions, technical principle interpretation and case practice sharing around "OceanBase use and development". These sharings endow the OceanBase community with stronger activity and influence, inspiring more people to actively participate in community contributions.

In 2021, in terms of technical evangelism, OceanBase will work with users to share the most cutting-edge technical views, and successively hold 4 offline Meetups, 6 live tutorials, 12 technical summits, share 300+ technical topics, and connect 3500+ Developers.

In terms of developer contributions, OceanBase continuously improves technical documents, and together with community users, has completed the output of 750+ technical documents, aiming to help developers lower the threshold for learning and use. After 7 months of improvement and hard work, we have gradually gained 4000+ Stars on Gitee and GitHub, generated 860+ Forks, nearly 500+ Issues, 640+ Commits, 230+ Pull Requests, and accumulated more than 4,600 questions and answers. Repeated interactions and technical exchanges, gathering all over the sky, are becoming more and more firm in our open source footsteps. (*The 2021 OceanBase Open Source Semi-Annual Report is attached below)

In 2021, OceanBase open source has just started,

Behind this transcript,

It is the efforts of every partner involved in community co-construction,

Because of your trust and support,

Because of your infinite love and contribution,

Only with every progress we make.

In 2022, we will be grateful,

Working hand in hand with community partners,

Believe that we can create something extraordinary together!