openGauss Officially Release Version 2.0.0

2021-03-31 openGauss

openGauss 2.0.0 is the first release version by the openGauss community. While the version 2.0.0 is compatible with the previous version, it also adds many new features, especially in the construction of high performance, high security and intelligence.

Kunpeng NUMA architecture optimization to achieve industry-leading performance

openGauss2P4PDegree Of Linearity
After Architecture Optimization150230150%

4P Kunpeng’s performance has reached 2.3 million tpmC (transaction per minute, which is widely used in the industry to measure the transaction processing capacity of computer system), reaching the linearity of 1.5 times. The single machine TP performance keeps leading in the industry. At the same time, it also proves that openGauss is enough to support the new core business system scenario in the financial industry.

  • According to the characteristics of Kunpeng processor’s multi-core NUMA architecture, openGauss has carried out a series of optimizations. On the one hand, it reduces the delay of cross core memory access, on the other hand, it gives full play to the advantages of Kunpeng multi accounting, and greatly improves the processing performance of transaction load system through key technologies such as log lock free parallel insertion, SQL ByPass and dynamic pruning.

  • openGauss is based on the architecture used by Kunpeng 920. It uses LSE extended instruction set to achieve efficient atomic operation and effectively improve CPU utilization, thus improving the performance of inter thread synchronization and xlog writing.

  • openGauss implements hot data access optimization based on L3 CacheLine provided by Kunpeng 920, effectively improves cache access hit rate, reduces cache consistency maintenance overhead, and greatly improves the overall data access performance of the system.

Fully secret and AI features, leading the new direction of database development

Break through the key technology of ciphertext query and calculation of pure soft data, and provide a full dense retrieval scheme with better performance
  • The performance degradation of fully dense data processing (including data dense insertion, update and expression equivalent filtering) is less than 5%.

  • openGauss is used for the implementation of the secret equivalent query, which comprehensively promotes the implementation of the full secret technology standard industry, and opens the secret computing ecology.

Strengthen the database self-tuning and self diagnosis ability of AI4DB, and break through the machine learning mechanism in the original database of DB4AI
  • Index recommendation

    It can effectively solve more than 90% of slow queries caused by improper index configuration; 60% of SQL statements in tpc-ds benchmark dataset can achieve different degrees of performance improvement.

  • Monitoring and anomaly detection

    Compared with manual on call, the efficiency of problem discovery is twice as high, and the problem recall rate under manual fault injection scenario is more than 90% on TPC-C benchmark data set.

  • MADLib compatible

    Support 60+ MADLib ecological algorithm.

Add a lot of enterprise features, continue to build openGauss database competitiveness

  • Simplified Installation

    The Simplified Installation does not contain cluster management tools, provides binary files of the database kernel, can quickly start the database instance, simple installation and configuration, suitable for individual developers.

  • Delayed standby databases

    Delays the time for a standby node to replay XLOG records, compared with the primary node.

  • Logical replication of standby nodes

    Supports logical decoding on a standby node,this can reduce host pressure.

  • Enhanced capacity expansion tool

    Optimizes the scale-out tool to support online scale-out without interrupting services and allows the standby node to be scaled out as a cascaded standby node.

  • Gray upgrade

    Optimizes the upgrade tool and support business online upgrade. Currently, only the gray upgrade from version 1.1.0 to 2.0.0 is supported.

  • Backup machine IO write amplification optimization

    Optimize the IO of the standby machine, smooth the IO volume of the standby machine checkpoint brushing, and solve the problem that the large amount of standby machine IO affects the query performance.

  • WDR diagnostic report adds database operation indicators

    Adds four database running metrics: Effective CPU, WalWrite NoWait, Soft Parse, and Non-Parse CPU.

  • Features of the Data Studio client tool

    Data Studio supports multiple features of the openGauss kernel. The details are as follows:

    • The pldebugger debugging function is added.

    • The rollback of the pldebugger debugging function is added. Before using Data Studio for debugging, add an option to ensure that the debugging function is rolled back after data is modified.

    • The XML and serial types are supported. Columns are added to the table. The column type can be XML or serial(big|normal|small).

    • Foreign table objects can be created and displayed in Data Studio.

    • The partial_cluster_key constraint of column-store tables is supported.

    • Global temporary tables support DDL display and export.

    • The LOCAL and GLOBAL flags are supported when a partitioned table is created.

    • The MOT table is displayed.

Open governance, multiple partners to join the community, community organization structure is more perfect

Beijing Chaotu Software Co., Ltd., Beijing Youxuan Software Co., Ltd., Beijing fast Cube Technology Co., Ltd. and other companies have signed CLA, officially joined openGauss community, and more and more forces have joined in community construction.

So far, openGauss has set up 11 special interest groups (SIG) including OM, in place update, IOT, AI, etc., including massive data, cloud, enmo, industrial and Commercial Bank of China, Tsinghua University and other organizations, initiated or participated in the sig groups of the community, leading the members to expand the technical direction, contribute new features, and realize the next version of technical planning. At the same time, the Community Technical Committee has also started to operate, and the openGauss community open governance framework is becoming more and more perfect.

After more than half a year of development and precipitation, openGauss has entered a period of rapid growth in terms of technology evolution, community ecological establishment and business landing. In the future, openGauss will continue to build more competitiveness around customer scenarios and needs, and build an enterprise level database open source community.

Thanks to openGauss community contributors, let’s build a warm community together

(the following list comes from the gitee account of the community developer in no particular order)

wanfang5, chendong76, liumin35, sqyyeah, zhanghuan96, yangweiqiang, zhang_xubo, zhangjianjun_code, daiguatutu, jia_junfeng1, scarbor_fair, lvmiao1229, tiantianxiangshang2020_admin, wanggzzs, zzzzzdb, lee1002, opengauss-bot, solinin, zhangzhijingMY, haomeng802, gaojia629, gitwangxx, zhanglu626, aiyotian, struggle_hw, wuyuechuan, hongyehongye1, vastbase_yzhang, xiangxinyong, yunlongg, blue_dwwc, cyw-0-ng, yansong_lee, zhouxiongjia, Alacebat_admin, guoweibiao, qumin201452, wenbling, zhang-tingting27, llzx373, zha_hw, anikikong, chenguojie, gongsiyi150, justbk, liushengxi, liyang0608, pan-jun, totaj, willemjiang, wind-rain-gs, zhangxiaohai928, chenxiaobin19, cui-zhenyu, gentle_hu, liang_-123, sun_xu_zong, wan005, wang-tq, y1309639, baiyejuan, emmajiang, houjhibofa, husthxd, kivaking, li-jun056, lijiangbei, lvhui123456, otis4631, xixicat, yangyang374, zhanglf-zkfr, diagon-alley, hillseas, jerome-duomi, jin_li, li_jianqiu, liao-shiting, lys6676, nifinity, qinzhiyan, ricardo_cui, sundan0108, vastdata_admin, wangpy_1092, xiezhipeng1, yidianjiujin, yinzhishu, you-and-me, ywzq1161327784, alienmoe, bang1232, bzhaoop, dolphin-m, du-yuying, eloce, enbokang, gauss__gaoshi, giteegauss, grozazz, gwx5327679, haowen17, hemny, hthinks, huzhengce, jane_minjun, jia-weili, johnnyzhou, kexulin, kixiong, like11, luo_zihao5524, ningyali, nwen_hw, pikeTWG, qian-dan, realzhouqingqing, reganhe_xx, siven_dev, unicorn_penq, vinothv, weim-123, willloong, wustczx, xh19, xianhongye, xiong_xjun, xue_meng_en, yang558, ylfan96, yutang1, zbxue, Adoube_548, RayH2020, april01xxx, barbedcc, bertliu, big_pig_123, bosihouzi, bowen9799, catofpei, chen_chenn, chennaidong, chenzang, chunlei007, cylfsbm, dikk123, eumenide5, flytigerman, fss567, gwchengcheng, huanglongjun1, husan1024, iambowen1984, initlove, jcc123, jeffee, jie_lei, jimmyhujiming, jinyu_opengauss, jitao10, kamusis, karna, krircc, lazpf, liangweii, lilexun, linxiaoxu131415, liuwei37218, lizhenfeng123, lj-it, lmte3e4, lorand, luyao201, ma_xiaodi, matrix0xcc, nanmu2018, nonolili527, open__gs__2020, ouruiting, panchenbo, puti_a, qq45068, romber, s36326, seulingfeng, shi-dongrong, stanleyren, su-zixin, sun_madman, tbing8803, templingfeng, tomas__junny, tonyhehe, toyato, trollzhao, wang_deng_yang, wangrui_rui, wei-haixu, weihan666, wjmcat, wjzeng, wn952000, wotchin, wu-yaxin, wuyi1405, xinmiaomiao, xmgps, xzyinyong, yang-zhen-a, yangkang52, yikunkero, ympc, yuwenboj, yuzhenglin, yz_db, zfy1110, zhaorenhai, zhongjun2, zhouzhishan, zilf, zju_hzd, zmm0810, zp123456, zumingjiang, zzcyd, 282656323, Cairo-SR8, Datrilla, Hsiung_xcw, I-1688, I-am-a-robot, IreneByron, JuhuaCan, MartinChoo, MrVulcan, OAGroup, QiuyeLin, ShawDa, VickyGroup, Xiao__Ma, YangHao666666, a-i-c, aaronwell, abelit, acidxyz, alan10, alexchar, andrewj, angelyoyou, anormalcell, aocool, aranadall, ariesdevil, aristophanes, ashnah0, awesomeleo, banpo_code_guest, bigDataEngine, bihua111, bluegenius, boleynsu, boz01, buter, castleBo, cevinc, cgo6, changxidb, chaocat, charleyw, chenchen746, chengfa110, chenhao7253886, chenlinfeng3, chenxiaobin6o9, chinapenglin, chla, chosending, chshfei, click2cloud_beta, click2cloud_ninja, coca, code_wolf, codewithselena, creationos, cting66, cyj10727, cyqw, dabudaqiu, danqu722, database_structure, ddwolf, deadsec, dengxuyue, dercury, ding_jie_001, docker_ming, drdstech, dreamr126, duoketang, duomibabi, duyanrong, echo3301, edollar, enmotech, eric-yuanhui, ericwangpeng, ericyuanhui, fenghui111, flyly, frankdemo, fuhm_star, fyw, gaiguoqiang12, gaoyunlong12, garyhuc, gauppo, gauss2, georgecao, ginin, git-dancer, glowd, guldan1982, guoliang_li, guoxinying123, gwp2464, gyt0221, handan_new_port_network_867494626, hangjin2020, hanxinke, he_ray, hellozuochao, hezhixiang1, hiha2120290476, hitmr_12, hljhnu, hly_rick_sanchez, hongfeiq, honglubaba, houlei0055, huangchengcheng1, huangning2, huangyinfu, huangzijian888, huawei_8, huaweigauss, hust_lilin, huxiangyu, igingo, iloveuever, infomation1, ironlee123, isoftstar, isupermap, isxiaoze, jackchenchenchen, jarekzhang, jianfenglee, jiang_jianyu, jiangxiangbo, jiaruozhi, jiawen1987, jiazongxiu, jidedong, jixi_hexi, jjjtheripper, joe2hpimn, junhangis, kcana, kidd__cn, king-gao, lance5401, lansehanbing, leerway, lesliexx, less_sleep, lhfree, li_songfeng, liheng188, lihongda12, linianA, lionxu_admin_admin, lisa100, lishifu_db, lishuaituan, littleFuBaby, liu_hui0228, liu_hui199828, liu_yang_ywxkhhh, liujunchigo, liuxu34, liuyu85cn, lixianlin01, liyifeng-seu, lllllllly, looplocked, lpbeijing, lqd-holy, lqkitten, luciferfgy, luo0303, luohongbins, maceatmore, majianboopengauss, meimeidtt, minshengyunwei, mobnet, moonjer, morinson, mujinqiiang, mxl_123456, mywind_code, nkuacac, nu_58212367, null_254_0217, opengauss_yanghaiyan, opengaussorg, opgauss, oscqascan, pei-jisheng, pengweijunPanda, pfzheng, pig_man3393, pizero, pku__lisihao, plusvolcano, popastin, powerqy, pure_qsh, qin-wei, qindongqd, qqleee, real_zychen, redflag, refactor_liu, reliance, romberli, shaga, shashwati-mishra, shenyuflying, shenzhen_panda_1515019109, shiddan, shinestarstar, shirley12qiu, shirley_zhengx, shiyaXA, sl0915, sneha-bhiwankar, song-zhenyu0612, song_haidong, souffle, ssnoda, ststshuitao, suniumo, suoren, susircode, sword-fairy-water-easy, sword_fairy_water_easy, szshfy, tangyibo, tedlz123, testHpro, th__under, the_real_fengfuming, thexiong7, thundercw, tianbing8803, toolscreator, travelliu, tuohai666, turquesalan, tuzouzhi999, viashaw, victor-zhc, victoryGroup, vincent1988, voyllente, wang-zhenzhen27, wang-zili, wang_pei_heng, wangdengke6, wangxinlian, wangzhijun2018, wcting163, wei_chao_xu, weidongkl, winginsky, winsty, wumizhang, wuxue77, wuzisanshengshi, wx_422c5b54d5, xiaomayifg, xiaotao-huang, xiepy, xiliu_h, xinhe65045, xiongdaofu, xq_gitee, xu_hong_liang, xue-weijing, xukunpeng, xulijie09, xushiyao, xzx666, yangdi07, yanghaos, yangshaoxing1001, yangyingchao, yaoyaoo2011, yeah_lang, yin-jue-song, yipianyouzi, yl_lisen, yonglehou, yongzhuli, youtubezou, ysenmiao, yuejiashen, yujiangaaa, yukai_k, yunmeng, yuzhang_li, yxotis, yyt030, yzk630, z0wang, zag2020, zankyfun4, zengchen1024, zerodefect, zha__hw123, zhang_jiecr7, zhang_yangeng, zhangfengzhi123, zhangshujie82, zhangtong1204, zhangxinyao1986, zhangy13, zhangyulong34, zhao_fangyang, zhaodu, zhaowx_admin, zheng_zelin, zhengchengguang, zhengtongyan, zhengyang168, zhengyuhanghans, zhouqinsupermap, zhouqinsupermap_admin, zhouzhiwei1992, zhu_jinwei, zhuzhijiao, zooah, zou_jinda, zsfxy, zwgiles