What's New

1

The optimization diagnosis function is introduced.

GaussDB(DWS) offers a multi-dimensional optimization and diagnosis function to ensure fast and stable operation of user services. This allows you to query, diagnose, and analyze historical data, perform real-time queries and analysis, and conduct real-time session analysis.

Commercial use

Monitoring and Diagnosing Top SQL Statements in a GaussDB(DWS) Cluster

2

The resource pool exception rule function is improved.

The default_memsize exception rule is added.

Commercial use

Exception Rules

3

The SQL editor is optimized.

The following functions are added to the SQL editor:

• Full export: You can export all SQL query results to a specified path in an OBS bucket. By default, the results are exported to a CSV file.

• SQL task submission: You can submit selected SQL statements to the background for execution.

• Data source sharing: Custom data sources can be shared with other IAM users of the same tenant.

Commercial use

SQL Editor Development Tool

4

Support for audit dumping of kernel logs is added.

Audit dumping of kernel logs is supported, which increases storage capacity and enhances the reliability of the Audit Dump feature.

Commercial use

Dumping the Database Audit Logs

5

Cluster parameter export is supported.

Click Parameters and click Export to export cluster configuration parameters.

Commercial use

Modifying Database Parameters

6

Modifications have been made to the cluster creation page for GaussDB(DWS).

The following changes are implemented:

• The standard data warehouse (DWS 2.0) and hybrid data warehouse are renamed as Computing In-Memory (CIM), indicating that data is stored on the local disks of DNs.

• The standard data warehouse (DWS 3.0) is renamed as Decoupled Storage And Compute, indicating that the local disks of DNs are only used for data warehouse cache and metadata storage, while user data is stored in OBS.

Commercial use

Creating a GaussDB(DWS) 2.0 Cluster with Coupled Storage and Compute

Creating a GaussDB(DWS) 3.0 Cluster with Decoupled Storage and Compute

7

9.1.0.210 cluster version is released.

9.1.0.210 cluster version is released.

Commercial use

New Features in 9.1.0.210

9.1.0.x Developer Guide

9.1.0.x SQL Syntax Reference

1

The development and design specifications for GaussDB(DWS) are now live.

These specifications aim to effectively reduce resource consumption, alleviate service congestion, and enhance data development efficiency. Developers are advised to pay special attention to and comply with these specifications during SQL development.

Commercial use

GaussDB(DWS) Overall Development and Design Specifications

1

The DAS function is offline.

The Data Admin Service (DAS) function will be taken offline, and you will no longer be able to log in to the DWS database through DAS. It is replaced by the SQL editor. It supports features such as SQL development and execution, SQL script persistence, SQL diagnosis, and result visualization. It also supports one-click login for IAM users. In the Operation column of the data warehouse cluster list, click Login. The home page of the SQL editor is displayed.

Commercial use

SQL Editor Development Tool

1

9.1.0.100 cluster version

The newest cluster version, 9.1.0.100, is now available in two architectures: DWS 2.0, which combines storage and computing, and DWS 3.0, which separates storage and computing.

When you create GaussDB(DWS) cluster on the console, selecting DWS 2.0 combines storage and computing, and stores data on local DNs. In contrast, choosing DWS 3.0 separates storage and computing, and local DNs are only used for data warehouse cache and metadata storage. User data is stored on OBS.

Commercial use

What Is GaussDB(DWS)?

New Features in 9.1.0.100

9.1.0.x Development Guide

9.1.0.x SQL Syntax

2

Configuring an auto scaling plan

An auto scaling plan creates a logical cluster that facilitates parallel expansion of the storage-compute decoupled (DWS 3.0) architecture. Once such logical cluster is associated with the primary logical cluster, specific queries from the primary logical cluster are routed to the logical cluster, but table creation statements are still executed in the original logical cluster.

Commercial use

Elastically Adding or Deleting a Logical Cluster

1

8.3.0.108 cluster version

Solved some other database problems.

Commercial use

--

2

Enhanced user management

Enabled exporting database user and role lists, along with their respective permissions, directly from the console.

• Added an export function to the user list, allowing you to export a comprehensive list of all users and roles.

• Added a permission export function that allows you to export all permissions associated with a specific user.

Commercial use

Database User Management

3

Enabled database dynamic memory monitoring and alarm reporting.

Added alarm reporting for node instance memory and dynamic memory usage. Tenants can customize alarm thresholds and subscribe to related alarms.

Commercial use

Alarm Management

4

Optimized the cluster upgrade page

Optimization points:

• Changed Cold Storage to Cold Data on the page for creating a DWS 3.0 cluster.

• Changed Cold Data to Cold Partition Data on the DWS 3.0 cluster details page. OBS hot data is changed to cold data.

• Changed Cold Data to Cold Partition Data on the DWS 2.0 cluster details page.

• Changed the OBS hot data package to the cold data package on the page for purchasing discount packages.

Commercial use

Creating a DWS 2.0 Cluster

Creating a DWS 3.0 Cluster

1

Changing a cluster name

After a GaussDB(DWS) cluster is created, you can change the cluster name to a name containing Chinese characters.

Commercial use

Changing a Cluster Name

2

SQL editor

The SQL editor enables connecting to cluster databases from the GaussDB(DWS) console. It provides a detailed view of the database metadata, enables the editing and execution of SQL queries, and presents the results through various chart formats. Additionally, it integrates with OBS for script management, allowing for global configuration and the ability to export SQL queries directly to OBS as text files.

Commercial use

SQL Editor Development Tool

3

Starting and stopping a cluster

If a cluster is no longer used, you can stop the cluster to bring services offline. You can start a stopped cluster to restore cluster services.

Commercial use

Starting and Stopping a Cluster

4

Inspection management

GaussDB(DWS) supports cluster inspection before change operations (scale-out/scale-in, changing all specifications, and upgrade). The change can be started after the inspection is passed. If the inspection fails, you can view the inspection details page to see which items did not pass the inspection. From there, you can handle the inspection items based on the details provided.

Commercial use

Viewing Inspection Results

5

LakeFormation data sources

On the GaussDB(DWS) console, you can create a LakeFormation data source to access metadata on LakeFormation.

Commercial use

Managing LakeFormation Data Sources

6

Intelligent distribution column recommendation

This is an important function in distributed database systems. It enhances data organization and accelerates query processing. Leveraging analysis of past query logs, the system autonomously recommend the ideal distribution column for your data tables. This recommendation is designed to facilitate effective data partitioning and storage within the distributed database, thereby improving query efficiency.

Commercial use

Intelligent Distribution Column Recommendation

7

Exception rules

You can define exception rules. The system automatically terminates or downgrades jobs that meet the exception rules to maintain system stability. You can use SQL syntax to configure exception rules based on your resource and workload conditions, and associate the rules with resource pools.

Commercial use

Exception Rules

8

Hot patch upgrade

The upgrade can be performed by adding a one-digit version number (in the format of 0001-9999) to the current cluster version.

Commercial use

Cluster Upgrade

9

NFS backup media

The NFS backup media can be used as the backup device. Disks can be mounted to the NFS backup media, which depends on the cloud-based SFS-Turbo service.

Commercial use

Snapshots

10

Changing the security group of a cluster

After a GaussDB(DWS) cluster is created, you can change the security group. You can also add, delete, or modify security group rules in the current security group.

Changing the security group of a cluster may cause brief service disruption. Exercise caution when performing this operation. For better network performance, do not select more than five security groups.

Commercial use

Can I Modify the Security Group of a GaussDB(DWS) Cluster?

1

8.3.0.100 cluster version

8.3.0.100 cluster version.

Commercial use

The 8.3.0.x version goes live.

1

Sharing the monitoring view of a data warehouse cluster among accounts

The function allows for seamless sharing of monitoring views across various accounts, avoiding duplicate configurations among different accounts and reducing the risk of configuration errors in read-only accounts.

Commercial use

Performance Monitoring

2

Using the cluster time zone for intelligent O&M scheduling

The intelligent O&M scheduling time supports the time zone of the cluster.

Commercial use

Viewing O&M Tasks

3

Specifying a time zone during cluster creation

When creating a cluster, you can specify the time zone based on the client time zone.

Commercial use

Creating a DWS 2.0 Cluster

4

Enhanced host monitoring capability

You can view the performance metric topology of a single host in the last 1 hour, last 3 hours, last 12 hours, last 24 hours, last 7 days, or last 15 days.

Commercial use

Node Monitoring

5

One-Click Clearing of All Idle Sessions

You can clear all idle sessions by one click.

Commercial use

Real-Time Queries

6

Changed the method of collecting statistics on the memory usage of cluster nodes.

The Memory Usage metric in the cluster monitoring function of Cloud Eye displays the memory occupied by cache. Post the March 2024 console upgrade, the display of this metric is improved.

Commercial use

Monitoring Clusters Using Cloud Eye

1

GaussDB(DWS) 3.0 is released.

The newly released GaussDB(DWS) 3.0 version provides resource pooling, massive storage, and the MPP architecture with decoupled computing and storage. This enables high elasticity, real-time data import and sharing, and lake warehouse integration.

Commercial use

Data Warehouse Types

Creating a GaussDB(DWS) 3.0 Cluster

Scheduling GaussDB(DWS) 3.0 Logical Cluster Creation and Deletion

2

Cluster version 8.1.3.325 (recommended version) is released.

Solved some other database problems.

Commercial use

--

1

Cluster version 8.1.3.323 (recommended version) is released.

Solved some other database problems.

Commercial use

--

1

Cluster version 8.2.0.107 is released.

Solved some other database problems.

Commercial use

--

2

User permission management is supported.

You can create, delete, and update database users and manage their permissions on the console. This feature enables users to manage database users and user permissions on the console without logging in to databases.

Commercial use

Database User Management

3

The database audit log dump function is optimized.

• The compression type of audit logs is changed from zip to gzip.

• The audit log file can be in CSV format.

• For a cluster upgraded from an early version, a switch is available on the console to control compatibility.

Commercial use

Dumping the Database Audit Logs

4

Multi-AZ clusters are supported.

In a multi-AZ cluster, three AZs can be selected at the same time, and server nodes are evenly allocated to the three AZs.

Commercial use

Creating a GaussDB(DWS) 2.0 Cluster

1

8.1.3.322 cluster version (recommended version) is released.

• By default, the LIMIT statement is allowed to use early stop optimization. The default value of the GUC parameter enable_limit_stop is changed from off to on.

• Added the GUC parameter skip_btree_unsafe_restart_point.

Commercial use

enable_limit_stop

1

The 8.2.0.106 cluster version is released.

Solved some other database problems.

Commercial use

--

1

8.1.3.320 cluster version (recommended version) is released.

• Added support for concurrent TRUNCATE, EXCHANGE, and SELECT operations.

• Added control over whether to enable early stop for LIMIT statements.

Commercial use

--

2

8.2.0.103 cluster version is released.

Solved some other database problems.

Commercial use

--

1

8.2.0.102 cluster version is released.

• Optimized the DN parallel import in the PBE scenario: The GUC parameter enable_parallel_batch_insert is added to determine whether to enable concurrent import of row-store and column-store tables.

• Some other database problems are solved.

Commercial use

--

2

Cluster upgrade on the console

Users can perform cluster upgrade operations on the console.

Commercial use

Cluster Upgrade

3

WebSql operation audit

On the Operation Audit page, you can view the records of the login, logout, creation, deletion, and query operations on the DAS. The records include the Huawei username, function module, operation content, database name, cluster information, login database name, operation time, and execution status.

Commercial use

Using DAS to Connect to a Cluster

4

The database monitoring panel (DMS) supports the comparison of metrics on multiple nodes.

The node monitoring view on the performance monitoring panel displays the metrics of multiple nodes, which help identify the performance curve of abnormal nodes.

Commercial use

Performance Monitoring

5

Adding a CN to a specified node

CNs can be added to a specified node.

Commercial use

Managing CNs

1

8.1.3.310 cluster version (recommended version) roll-out

• The GUC parameter redact_compat_options is added to configure the compatibility of the data masking techniques.

• Some other database problems are solved.

Commercial use

redact_compat_options

2

8.2.0.101 cluster version roll-out

Some other database problems are solved.

Commercial use

--

1

Product name change

Cloud Data Warehouse is changed to Standard Data Warehouse.

Commercial use

Data Warehouse Types

2

The resource management page is reconstructed.

The resource management page is reconstructed and Tiny3 is upgraded. This is to improve the page layout and operation usability.

Commercial use

Resource Management

3

The AS portal is integrated.

The resizing function is renamed as "Changing all specifications", and the flavor change function is renamed as "Changing node flavor".

The entries for changing all specifications, changing node flavors, and changing disk capacity are put under More > Change Specifications in the Operation column in the cluster list. The entries for scale-out, scale-in, and redistribution are put under the More > Scale Node column in the cluster list.

Commercial use

Changing Specifications

4

You can view historical versions and roll back parameter modifications.

If you cannot determine which parameters have taken effect after multiple modifications, you can check the parameter modification history.

Commercial use

Modifying Database Parameters

5

Snapshot parameter configuration

You can specify parameters for creating a snapshot and restoring a snapshot to optimize the snapshot function.

Commercial use

Configuring a Snapshot

6

Lock monitoring and alarm reporting on the monitoring panel (DMS)

In a specified period, the DMS alarm module detects that VACUUM FULL has been running for a long time in the cluster and blocks other operations. This alarm is generated if there are other SQL statements in the lock wait state and some restrictions are violated.

Commercial use

Alarm Management

1

8.2.0.100 cluster version roll-out

HStore tables, dirty page monitoring view optimization, cost estimation enhancement, and analyze sampling adaptation.

Commercial use

8.2.0 Version

1

8.1.3.300 cluster version rollout

The 8.1.3.300 kernel has been rolled out on a large scale and is used as the recommended version.

Commercial use

--

2

Cluster topology page

This page displays the topology of all nodes in a cluster, helping users view the status, processes, and IP addresses of each node.

Commercial use

Cluster Topology

3

Binding a cluster to an ELB in another VPC or enterprise project

Currently, ELBs can be bound in the same VPC or across VPCs.

Commercial use

https://support.huaweicloud.com/intl/en-us/mgtg-dws/dws_01_0822.html

4

Optimized CN addition and deletion.

You can add or delete CNs online or add multiple CNs concurrently.

Commercial use

Managing CNs

1

Optimized discount packages

Discount packages can be shared in all projects under a single account.

Commercial use

Purchasing a Discount Package

2

8.2.0 cluster rollout

The 8.2.0 kernel has been rolled out.

Commercial use

8.2.0 Version Changes

3

The table diagnosis page is added to DMS

You can monitor and analyze data table statistics in a cluster. You can view information about tables with skew rate higher than 5%, tables with dirty page rate higher than 50%, or top 50 tables in size.

Commercial use

Table Diagnosis

4

The usability of resource management is improved

1. Workload Management is renamed Resource Management.

2. Optimized resource exception rules. You can configure the data spilled to disk per DN and the average CPU usage per DN.

Commercial use

Resource Management

5

Added support for OBS data sources

GaussDB(DWS) can access data on OBS by using an agency. You can create a GaussDB(DWS) agency, grant the corresponding permissions to the agency, and bind the agency to an OBS data source you created. In this way, you can access data on OBS by using OBS foreign tables.

Commercial use

Managing OBS Data Sources

6

Node alias can be modified

CNs can be associated with CN aliases on the node management page.

Commercial use

Managing Nodes

7

Database monitoring can show server-level trends

You can view the performance metric topology of a specific node in the last 1 hour, 3 hours, 12 hours, or 24 hours.

Commercial use

Node Monitoring

8

Snapshot creation can be manually stopped

After a snapshot is created, you can manually stop the snapshot.

Commercial use

Stopping Snapshot Creation

9

Snapshots can be restored to the current cluster

If a cluster is faulty or data needs to be rolled back to a specified snapshot version, you can specify a snapshot to restore data to the current cluster.

Commercial use

Restoring a Snapshot to the Original Cluster

10

Added support for cluster resizing

Resizing a cluster is similar to migrating an old cluster to a new cluster with changed flavors or nodes. It is relatively heavyweight and has a great impact on services.

Commercial use

Resizing a Cluster

1

8.1.3.200 cluster rollout

The 8.1.3.200 kernel has been rolled out on a large scale and is used as the primary version.

• The GUC parameter ddl_lock_timeout is added to specify the DDL lock timeout interval.

• Added the views PGXC_WAIT_DETAIL and PGXC_LOCKWAIT_DETAIL.

• Columns including wait_on_pid and query_id are added.

• Optimized some other issues.

Commercial use

8.1.3

1

Workload management for logical clusters

You can manage the workloads of logical clusters.

Commercial use

Managing Workloads (for Logical Clusters)

2

8.1.3 kernel function enhancement: 8.1.3.110 cluster version

If a number is divided by zero, NULL will be returned. The compatibility option enable_division_by_zero_mysql is added to the behavior_compat_options parameter.

Commercial use

behavior_compat_options

3

DAS connections to DWS databases

You can connect to a database through DAS.

DAS is a service on HUAWEI CLOUD that allows users to manage DB instances on a web console where users can perform basic SQL operations, advanced database management, and intelligent O&M, making work easy, secure, and intelligent.

Commercial use

Using DAS to Connect to a Cluster

4

Connections from the Windows gsql clients to clusters

The database connection command line tool gsql supports Windows.

Commercial use

Using the Windows gsql Client to Connect to a Cluster

5

Cluster connections from the Python libraries psycopg2 and PyGreSQL

In GaussDB(DWS), you connect to a cluster from the Python libraries psycopg2 and PyGreSQL.

Commercial use

Using the Python Library psycopg2 to Connect to a Cluster

Using the Python Library PyGreSQL to Connect to a Cluster

1

Cluster versions 8.1.1.500 and 8.1.3.100

• 8.1.1.500: Improved features and fixed known issues.
• 8.1.3.100: Improved hint bit logging and MySQL compatibility.

Commercial use

8.1.3 Version Changes

1

Specifications Change

You can change your node specifications on the management console. For example, you can change to higher specifications before service peak hours to quickly improve the computing capability of the cluster, and change to lower specifications afterwards to reduce costs.

Commercial use

Modifying Specifications

2

Snapshot type display

You can check whether a snapshot is an incremental or full snapshot on the management console.

Commercial use

Viewing Snapshot Information

3

GUI improvement

The cluster details page is improved. The product specifications display on the pages for creating a data warehouse cluster and purchasing a discount package is improved.

Commercial use

Viewing Cluster Details

Creating a Cluster

1

Logical cluster scale-out online

Logical clusters can be scaled out online.

Commercial use

Scaling Out Logical Clusters

2

8.1.3 database kernel

8.1.3 database functions are supported.

Commercial use

8.1.3 Version Changes

3

Enhanced DMS

1. The cluster dashboard page is displayed. You can view the cluster status, real-time resource consumption, top SQL statements, cluster resource consumption, and key database metrics.
2. Query monitoring is changed to real-time query. It displays real-time information about all the queries and sessions running in the cluster.
3. Session monitoring is changed to historical query. It displays all the historical query information in the current cluster.
4. The DDL audit function is added. DDL audit is used to check whether DDL metadata is standard, helping users detect potential problems in table definition.
5. The SQL probe function is added. You can upload and verify SQL probes, execute probe tasks in one click, and periodically execute probe tasks.
6. The Workload Diagnosis Report (WDR) function collects and analyzes database performance data. You can create workload snapshots to record cluster workload data in a specified period.

Commercial use

Database Monitoring Overview

4

Cluster scale-in

Cluster scale-in is supported.

Commercial use

Scaling In a Cluster

5

Concurrency configuration for scale-out

During scale-out, you can configure the number of concurrent redistribution tasks.

Commercial use

Cluster Scale-out

6

Support for 3.x MRS data source connections

You can create a data source connection for a user-defined MRS 3.0.x cluster.

Commercial use

Creating an MRS Data Source Connection

7

Intelligent O&M

Intelligent O&M helps GaussDB(DWS) users with O&M tasks. With this feature, you can specify the proper time window and number of tasks to execute based on the cluster workload. Besides, Intelligent O&M can adjust task execution policies according to service changes in a timely manner to reduce the impact on services. Periodic tasks and one-off tasks are supported, and you can configure the time window as required.

Only clusters of 8.1.3 and later versions support this function.

Commercial use

Intelligent O&M

8

Offline redistribution scheduling

Cluster redistribution can be scheduled. Tables are redistributed only within the time window you configured.

Only clusters of 8.1.3 and later versions support this function.

Commercial use

Redistributing Data

9

Cluster capacity display

You can check the snapshot capacity, monitoring statistics, and cold data capacity.

Commercial use

Viewing Basic Cluster Information

10

Interconnection with Log Tank Service (LTS)

You can view the collected cluster logs or dump logs on LTS.

Commercial use

Log Management Overview

11

Resource pool queue congestion alarm

Alarms can be generated for resource pool queue congestions.

Commercial use

Alarm Management

1

Disk capacity expansion

You can expand the disk capacity of cloud data warehouse clusters on the console.

Commercial use

Disk Capacity Expansion

2

The hybrid data warehouse supports distributed deployment.

The hybrid data warehouse supports distributed deployment, and provides the same capabilities as the cloud data warehouse does. The capabilities of a standalone data warehouse remain unchanged.

Commercial use

Data Warehouse Types

1

Switchback

In a cluster in Unbalanced state, there are too many primary instances on part of the nodes, making the nodes heavily loaded. In this case, the cluster can still run properly, but its performance is not as good as that in the balanced state. In this case, you can perform a primary/standby switchback for the cluster during off-peak hours to improve performance.

Commercial use

Performing a Primary/Standby Switchback

2

Real-time data warehouse

• The data warehouse provides high-concurrency, high-performance, and low-latency transaction processing capabilities based on large-scale data query and analysis capabilities. It is suitable for hybrid transaction/analytical processing (HTAP). A database can be used for both production and analysis. Currently, HA features are not supported. It can be deployed only in standalone mode, which is cost-effective and can be used for lightweight, non-core services, such as learning and testing.
• Changed the data warehouse name from "real-time data warehouse" in OBT to "stream data warehouse".

Commercial use

Data Warehouse Types

3

Stream data warehouses can be bound to Elastic Load Balance (ELB).

Stream data warehouses can be bound to Elastic Load Balance (ELB) to avoid single-CN failures.

Open beta testing

Associating and Disassociating ELB

4

Extended the range of GUC parameters supported by the console.

New GUC parameters can be modified on the console.

Commercial use

Modifying Database Parameters

1

Database monitoring

Fine-grained database monitoring on nodes, performance, databases, sessions, queries, instances, and load metrics.

Commercial use

Database Monitoring Overview

2

Phase-based scaling

Added the phase-based scale-out function. The phases include node addition, cluster scale-out, and database redistribution.

• Note addition: This function is more suited for large-scale scale-out. Nodes can be added in batches in advance.
• Cluster scaling: The added nodes can be used for scale-out.
• Data redistribution: Data in existing nodes is evenly allocated to the new nodes after you scale out a cluster. Data redistribution is a time-consuming yet crucial task that accelerates service response.

Commercial use

Node Management

Cluster Scale-out

Redistributing Data

3

Clusters can be bound to Elastic Load Balance (ELB).

If the internal IP address or EIP of a CN is used to connect to a cluster, the failure of this CN will lead to cluster connection failure. If a private domain name is used for connection, connection failures can be avoided by polling. However, private domain names cannot be used for public network access, and requests cannot be forwarded in the case of a CN failure. Therefore, ELB is used to avoid single CN failures.

Commercial use

Associating and Disassociating ELB

4

More GUC parameters can be configured on the console.

More GUC parameters can be modified on the console.

Commercial use

Modifying Database Parameters

5

Alarm

Added the alarm management function to allow users to view alarms triggered by DMS on the console.

Commercial use

Alarm Management

1

8.1.1.100 database kernel

• Query bands in resource pool queues
• Slow node detection
• Fine-grained backup and restoration
• Full build optimization
• Supported primary keys in column storage.
• Supported single-column CU update in column-based storage, greatly improving update performance.
• Supported reused free space on data pages and optimized the performance of the AUTOVACUUM index.
• Provided a tool to automatically deploy GDS. GDS monitors traffic.
• Added the feature of storing cold data in internal OBS tables.
• Added table-level authorization of ANALYZE.
• Supported SM4 CBC.
• Supported WDRs.
• Added the features that the base table can be modified directly and related views support automatic update and cascade update.
• Enhanced the log audit function. Transactions and O&M operations are audited. DDL operations are audited only once. Internal database operations can be filtered.
• Enhanced the data masking function. Data masking rules can be customized.
• After the password expires, a user can log in to the database only after changing the password.
• Improved SQL performance: Enlarged hash tables to reduce conflicts, changed local redistribution to batch copy, and optimized row2vec.
• Disabled SMP adaptation by default. Related parameters can be adjusted based on the cluster flavor for optimal performance.
• Improved MySQL compatibility: Supported UPSERT, distinguished between NULL and empty strings, and supported limit offset, count, and concat functions.
• Returning NULL when TO_DATE and TO_TIMESTAMP process empty strings
• Supported INSERT OVERWRITE during online scale-out, which does not block services. When online scale-out is performed, no error is reported for adding the DROP column during partition exchange.
• Adapted to DLI foreign table modification.
• Hot loading of MRS data sources
• Added the percentile_cont and percentile_disc functions.

Commercial use

8.1.1

2

CN management

The number of manageable CNs increased from 5 to 20. CNs can be added or deleted on the console.

Commercial use

CNs

3

Online scale-out

During cluster scale-out, data can be continuously imported to the database.

Commercial use

Cluster Scale-out

4

Protection for mission-critical operations

Protected mission-critical operations. A credential for identity verification is required if users want to perform a mission-critical operation on the management console. For account security, you are advised to enable operation protection. The setting will take effect for both the account and its users.

Commercial use

Protection for Mission-Critical Operations

5

Dual-cluster DR

A homogeneous GaussDB(DWS) DR cluster is deployed in another AZ. If the production cluster fails to provide read and write services due to natural disasters in the specified region or cluster internal faults, the DR cluster becomes the production cluster to ensure service continuity.

Commercial use

DR Overview

1

8.1.0 kernel version

Made the following changes:

• Optimized cost estimation.
• Enhanced ANALYZE for temporary tables and single-transaction operations.
• Improved performance of the vectorized executor.
• Alleviated the problem that partition pruning can be performed only for constants but not the variables that need to be calculated.
• Added schema-level full backup and table- and schema-level fine-grained restoration.
• Supported third-party user-defined data conversion of GDS.
• Optimized RTO.
• Reconstructed CM for feature enhancement and interface modification.
• Supported data export in ORC format using OBS foreign tables. Foreign tables can read Parquet data.
• Supported XML function parsing.
• Supported automatic job migration when a CN fails.
• Supported smooth upgrade of C functions.
• Synchronized the time zone with the IANA Time Zone Database (tz).
• Supported Teradata DSQL compatibility of gsql.

Commercial use

8.1.0

2

Logical cluster

A physical cluster can be divided into logical clusters that use the node-group mechanism.

Users can associate a logical cluster to create tables. Tables in a database can be allocated to different physical nodes by the logical cluster, and a logical cluster can contain tables of multiple databases.

Commercial use

Logical Cluster Management

1

Optimized discount package page

Supported monthly and yearly discount packages.

Commercial use

Purchasing a Discount Package

2

Optimized flavor page of second-generation clusters

Cloud or standard data warehouses can be selected during cluster creation.

• Standard: User-defined storage class or capacity is not supported.
• Cloud: The storage class and capacity of EVS disks can be set. CDR storage of EVS disks is billed independently in the second generation cluster.

Commercial use

Creating a Cluster

1

Added the second generation of the EVS storage type. Users can set the storage type and storage capacity.

When creating a cluster, you can select Second Generation as required. This flavor is used for EVS disks. You can set the storage type and storage capacity, and storage resources are billed independently.

Commercial use

Creating a Cluster

1

Workload management

Workload management enables concurrent and independent execution of two types of jobs.

Commercial use

Managing Cluster Workloads

2

gs_dump, gs_dumpall

• gs_dump: Exports a single database or its objects.
• gs_dumpall: Exports all databases in a cluster or common global objects each database.

Commercial use

Using gs_dump and gs_dumpall to Export Data

1

Fine-grained permission control

The IAM service provides fine-grained access control.

On IAM, the administrator (that is, a user in the admin user group) can create a custom policy containing various required permissions. After a policy is granted to a user group, users in the group can obtain all permissions defined by the policy.

Commercial use

Fine-Grained Policies

2

Canceling read-only status on the console

The read-only status of a cluster can be canceled on the management console. Only v8.0.1.100 or later support this feature.

Commercial use

Canceling Read-only Status

1

Added the request parameter Enterprise Project.

Added the Enterprise Project parameter to the API.

Commercial use

Creating a Cluster

1

Increase in automatic snapshot frequency

By default, automated snapshots are token three times each day, starting from 00:00:00 (UTC). You can set the snapshot execution period during cluster creation or modify the existing automated snapshot policy.

Commercial use

Configuring an Automated Snapshot Policy

2

Support for manual snapshot creation

In the cluster list, you can click More in the Operation column of a cluster to select the Create Snapshot operation to manually create a snapshot.

Commercial use

Manually Creating Snapshots

1

Transparent encryption and decryption

In GaussDB(DWS), you can enable database encryption during cluster creation to protect static data. After you enable encryption, data of the cluster and its snapshots is encrypted.

Commercial use

Encrypting GaussDB(DWS) Databases