What's New

1

Cluster version 8.1.3.325 (recommended version)

Solved some other database problems.

Commercial use

-

2

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
• GaussDB(DWS) 3.0 Developer Guide
• Scheduling GaussDB(DWS) 3.0 Logical Cluster Creation and Deletion

1

Cluster version 8.1.3.323 (recommended version)

Solved some other database problems.

Commercial use

-

2

Enhanced log search

Added the log search content and log filters:

• Added logs related to cms, gtm, roach, upgrade, and scale-out of GaussDB(DWS).
• Logs can be searched by node.

Commercial use

Cluster Log Management

3

Enhanced redistribution

• Added the priority options of databases, schemas, and tables for redistribution.
• After the redistribution is complete, the average rate during the redistribution is displayed.
• The number of concurrent redistribution tasks can be dynamically adjusted during product redistribution.

Commercial use

Viewing Redistribution Details

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

O&M Account on the Cluster Details page

You can perform account authorization on the Cluster Details page to control the operation rights and impact scope of O&M personnel's access to clusters.

Commercial use

O&M Account

2

Creating MRS data source connection as common users

Common user can directly use MRS data sources without requiring the system to create GaussDB(DWS) users by default.

Commercial use

Creating an MRS Data Source Connection

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

-

1

Cluster upgrade on the console

Users can perform cluster upgrade operations on the console.

Commercial use

Cluster Upgrade

2

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

3

Adding a CN to a specified node

CNs can be added to a specified node.

Commercial use

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

1

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

2

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

3

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

4

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.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

Associating and Disassociating ELB

4

Optimized CN addition and deletion.

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

Commercial use

CNs

1

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

2

Snapshot creation can be manually stopped.

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

Commercial use

Stopping Snapshot Creation

3

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

4

Node alias can be modified.

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

Commercial use

Managing Nodes

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

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

7

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

8

Optimized discount packages.

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

Commercial use

Purchasing a Discount Package

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

-

1

First roll-out in Europe

First roll-out in Europe

Commercial use

-