Help Center> GaussDB(DWS)> Service Overview> Version Description
Updated on 2023-11-27 GMT+08:00

Version Description

This section describes the cluster version update records of GaussDB(DWS).

V8.2.0.106

Release date: August 14, 2023

Kernel version: 8.2.0

  1. The O&M account management module is added to the cluster details page. Authorized accounts are used to control the operation rights and impact scope of O&M personnel's access to the cluster.
  2. Common user permission configurations are supported during the creation of MRS data source connection in a cluster.

V8.2.0.101

Release date: April 27, 2023

Kernel version: 8.2.0

  1. Allow users to deliver cluster upgrade operations on the console.
  2. WebSql supports operation audit.
  3. Metrics of multiple hosts can be displayed in a node-dimension monitoring view on the DMS monitoring panel.
  4. The CN can be added to a specified node.

V8.2.0.100

Release date: February 15, 2023

Kernel version: 8.2.0

  1. The product type "Cloud data warehouse" is changed to "Standard data warehouse".
  2. The resource management page is reconstructed.
  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.
  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.
  5. You can configure the parameters for creating and restoring a snapshot.
  6. DMS can monitor locks and report alarms.

V8.1.3.300

Release date: December 20, 2022

Kernel version: 8.1.3

  1. A topology is added to show all the nodes in a cluster. You can check the node statuses, processes, and IP addresses.
  2. A cluster can be bound to the ELB in a different enterprise project or VPC.
  3. CNs can be added or deleted online. Multiple CNs can be added concurrently.

V8.2.0

Release date: November 23, 2022

Kernel version: 8.2.0

  1. 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.
  2. Workload Management is renamed Resource Management, and its usability is enhanced.
  3. Optimized resource pool exception rules. You can configure the data spilled to disk per DN and the average CPU usage per DN.
  4. The table diagnosis page is added to DMS to 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.

V8.1.3.200

Release date: November 15, 2022

Kernel version: 8.1.3

  1. The resizing function is added. You can adjust the specifications of the current cluster or change the cluster topology.
  2. Snapshots can be restored to the current cluster.
  3. Snapshot creation can be manually stopped.
  4. The database monitoring can show server-level trends.
  5. On the node management page, you can modify the alias of a node.
  6. Enhanced the features of database kernel version 8.1.3. For details, see 8.1.3 New Database Features.

V8.1.3.101

Release date: August 23, 2022

Kernel version: 8.1.3

  1. GaussDB(DWS) supports connection to clusters based on DAS.
  2. Logical clusters support resource management.
  3. You can use the Windows gsql client to connect to a cluster.
  4. In GaussDB(DWS), you can connect to a cluster from the Python libraries psycopg2 and PyGreSQL.
  5. New function in database kernel version 8.1.3: 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.

V8.1.3.100

Release date: June 20, 2022

Kernel version: 8.1.3

  1. Used consistent description for the workload management plane and for the kernel CPU sharing quota.

V8.1.1.500

Release date: June 20, 2022

Kernel version: 8.1.1

  1. Key problems on the live network are resolved. No document updates are involved.

V8.1.3

Release date: April 15, 2022

Kernel version: 8.1.3

  1. The intelligent O&M function is added to help you intelligently execute O&M tasks. You can select a proper time window and concurrency to execute tasks based on the cluster workloads.
  2. Cluster redistribution can be scheduled. Tables are redistributed only within the time window you configured.
  3. Added support for database kernel version 8.1.3. For details, see 8.1.3 New Database Features.

V8.1.1.300

Release date: April 15, 2022

Kernel version: 8.1.1

  1. During scale-out, you can configure the number of concurrent redistribution tasks.
  2. You can create a data source connection for a user-defined MRS 3.0.x cluster.
  3. The cluster scale-in function is added. You can reduce the computing and storage resources used by your GaussDB(DWS) cluster.
  4. The online scale-out function is added for logical clusters.
  5. Added the Log Tank Service (LTS) function. You can view collected cluster logs or dump logs in LTS.
  6. You can check the snapshot capacity, monitoring statistics, and cold data capacity.
  7. DMS is updated and the following functions are added:
    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 definitions.
    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.
  8. Alarms can be generated for resource pool queue congestions.

Version V8.1.1.205

Release date: March 30, 2022

Kernel version: 8.1.1

  1. Key problems on the live network are resolved. No document updates are involved.

Version V8.1.1.203

Release date: March 18, 2022

Kernel version: 8.1.1

  1. The disk capacity expansion function is added to the console page. You can expand your disk capacity to quickly remove storage resource bottlenecks.
  2. The hybrid data warehouse supports distributed deployment, and provides the same capabilities as the standard data warehouse does. The capabilities of a standalone data warehouse remain unchanged.

Version V8.1.1.202

Release date: February 24, 2022

Kernel version: 8.1.1

  1. Added the Hybrid data warehouse cluster type, applicable to hybrid transaction/analytical processing (HTAP). A database can be used for both production and analysis.
  2. Added the switchback function to the console. You can perform a primary/standby switchback for a cluster in the Unbalanced state to restore cluster performance.
  3. A stream warehouse can be bound to Elastic Load Balance (ELB) to avoid single-CN failures in an IoT data warehouse.
  4. Extended the range of GUC parameters supported on the console. New GUC parameters can be modified on the console.

Version V8.1.1.200

Release date: December 9, 2021

Kernel version: 8.1.1

  1. Added the database monitoring function to support fine-grained monitoring on nodes, performance, databases, sessions, queries, instances, and load metrics.
  2. Added the alarm management function to allow users to view alarms triggered by DMS on the console.
  3. Added the phase-based scale-out function. The phases include node addition, cluster scale-out, and database redistribution.
  4. More GUC parameters can be configured on the console.

Version V8.1.1.100

Release date: July 30, 2021

Kernel version: 8.1.1

  1. Added the function of managing CNs. The maximum number of CNs in a cluster has changed from 5 to 20. CNs can be added or deleted on the management console.
  2. Added the online scale-out function. During cluster scale-out, data can be continuously imported to the database.
  3. Protected mission-critical operations. A credential for identity verification is required if users want to perform a mission-critical operation on the management console.
  4. Added the dual-cluster DR function. A homogeneous GaussDB(DWS) DR cluster can be deployed in another AZ within the same region as the original cluster to ensure service continuity.
  5. Released database kernel 8.1.1. For details, see What's New.

V8.1.0.100

Release date: May 15, 2021

Kernel version: 8.1.0

  1. Added the logical cluster function. Tables in a database can be allocated to different logical nodes based on the logical cluster. A logical cluster can contain tables from multiple databases.
  2. Changed the default database name to gaussdb during cluster creation.
  3. Released database kernel 8.1.0. For details, see What's New.

V8.0.1.100

Release date: July 31, 2020

Kernel version: 8.0.0.1
  1. Added the Stream data warehouse cluster type to provide time-series computing and compression services.
  2. Added the resource management function so that two types of jobs can be executed at the same time without affecting each other.
  3. Added the gs_dump and gs_dumpall data export tools.

V1.7.1

Release date: March 20, 2020

  1. Added the following functions for the database kernel:
    • UPDATE now supports alias and table name reference.
    • You can specify a schema when creating an index. The specified schema must be the same as that where the base table resides.
    • Added the alter table modify null/not null syntax.
    • Added the support for the alter sequence maxvalue operation.
    • Limited the temporary tablespace and operator disk flushing space.
    • Removed the sub-statement records from Top SQL.
    • Added the support for recording lightweight CN statements.
    • Processed the aging data in the information tables of historical top SQL.
    • Supported stored procedures and function statements of the CN retry function.

V1.5.200

Release date: August 8, 2019

  • Optimized Functions
    1. Increased the backup frequency of automated snapshots. By default, automated snapshots are created three times a day, starting from 00:00 (UTC). You can set the snapshot execution period when creating a cluster or modify the existing automated snapshot policy for a cluster.
    2. 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.