openGauss 3.1.1 is compatible with the features and functions of previous versions
Published: 2023-03-13 02:23:11

version introduction
3.1.1 is compatible with the features and functions of previous versions, the main functions are as follows:

Inherited function:
Basic functions: SQL standard syntax, data types, tables (including temporary tables, global temporary tables, external tables), views, materialized views, foreign keys, indexes (including btree indexes, Gin indexes, hash indexes), sequences, functions, triggers Operator, aggregate function median, ROWNUM, UPSERT, jsonb data type, GB18030 character set.
Stored procedure: Stored procedure, commit/rollback in stored procedure, parameter stored procedure/function call omission (), stored procedure debugging.
Security functions: authentication, authority management, network communication security, database auditing, fully confidential database, dynamic data desensitization, national secret algorithm, tamper-proof ledger database, built-in role and authority management, transparent encryption, ANY authority management, etc.
High availability: active and standby dual machines, cascaded standby machines, logical replication, extreme RTO, standby machine expansion, based on Paxos distributed consistency protocol (DCF), two regions and three centers for cross-Region disaster recovery.
SQL engine enhancements: range partitioning, global partitioning index, LIST partitioning, HASH partitioning, automatic extended partitioning based on range partitioning, row storage conversion quantization, autonomous transactions, parallel query, Global Syscache, IPv6 protocol, postgis plug-in.
Storage engine enhancements: Delayed standby database, standby machine supports logical replication, parallel logical decoding, grayscale upgrade, rolling upgrade, Hash index, column storage table primary key unique constraint, Ustore storage engine, segment page storage, publish subscription, row storage table Compression, MOT memory table, NUMA-aware high-performance optimization, etc.
Backup recovery: full physical backup, logical backup, standby backup, incremental backup and recovery, recovery to a specified point in time (PITR).
AI capabilities: parameter self-tuning, slow SQL discovery, AI query time prediction, database index collection prediction and exception monitoring, DBMind autonomous operation and maintenance platform, intelligent optimizer, intelligent index recommendation, AI algorithm in deepSQL library, AI algorithm support in library XGBoost, multiclass, and PCA.
Operation and maintenance capabilities: WDR diagnosis report adds database operation indicators, standby machine slow SQL diagnosis view, unique sql automatic elimination.
JDBC: Support JDBC client load balancing and read-write separation.
CM: Support CM cluster management, CM supports custom resource management and control, and supports external status query and push capabilities.
Tool chain: development tool DataStudio, data migration tool chameleon.
Middleware: shardingSphere, openLookeng.
Peripheral ecology: dblink, supports openEuler, CentOS, Ubuntu, FusionOS systems
Others: cmake script compilation, containerized deployment, kubernetes
new features:
Primary and secondary shared storage
Enhanced MySQL compatibility
CM deployment and database deployment are decoupled, and CM supports incremental upgrades
Enhanced MOT memory table capability
Among them, the feature of active and standby shared storage is an important feature introduced in version 3.1.X. Let's focus on it.