The openGauss core is built on the basis of the PostgreSQL object-relational database management system. Its functionality has been enhanced to meet enterprise-level challenges.
Conceptually, openGauss is a multipurpose database: row storage in it allows you to support services with intensive data updates, column storage speeds up the execution of analytical tasks, and the in-memory engine increases throughput for solving tasks that are sensitive to response time. The solution is being deployed both in containers and on physical servers with x86-64 or Kunpeng processors developed by Huawei.
The official launch of the first version of openGauss took place on July 1, 2020. And already in the middle of autumn, 1.0.1 was released, which included more than twenty improvements.
In its current implementation, openGauss has a wide range of remarkable features. First of all, this is support for multi-core architecture with controlled concurrency. It should also be noted that intelligent parameter tuning, diagnostics of slow SQL, multidimensional self-monitoring of performance and online prediction of SQL execution, greatly simplifies O&M.
The performance metrics of openGauss are worthy of mention. Specifically, the system performs up to 1.5 million tpmC on two 64-core Kunpeng processors, and takes less than 10 seconds to fail over on a node failure.
Let's briefly outline the features of openGauss that determine its benefits.
- . — WALs (write-ahead logs) — . gs_basebackup , . PostgreSQL , . 1.0.1 GUC enable_cbm_tracking ( ).
openGauss Standby , . . - . openGauss , , . Memory-Optimized Tables (MOT) — OLTP- . MOT , openGauss, .
MOT TPC-C .
Materialized View — () , . - (WDR). , enable_wdr_snapshot=on wdr_snapshot_retention_days. , SQL. WDR (snapshots) HTML PDF.
- . Foreign Data Wrappers (FDW). Oracle, MySQL, openGauss.
Global Temporary Tables (GTT). , GTT . . - . ETL .
OpenGauss is licensed under the Mulan PSL v2 , which gives developers the freedom to modify, use, and reference the DBMS code. The source code of the project is fully available in its repository .
Recall that Huawei is a platinum partner of open source software developers Linux, Apache and Openstack, as well as a strategic member of the Eclipse Foundation. We are actively involved in projects to create Open Source solutions, including:
- Linux distribution kit openEuler ;
- framework for deep learning tasks MindSpore ;
- an intelligent platform for ensuring the autonomy of open data SODA ;
- Apache CarbonData big data storage format ;
- Apache ServiceComb microservices platforms ;
- framework for edge computing CNCF KubeEdge ;
- high-performance batch-process control system CNCF Volcano .
We will be glad to answer your questions in the comments!