Version Description
This section describes the cluster version update records of GaussDB(DWS).
V9.0.2
Release date: November 15, 2023
Matching kernel version: 9.0.2
The cloud-native data warehouse GaussDB(DWS) 3.0 is provided. It uses the decoupled storage and compute architecture, solving the problem that computing and storage resources must be scaled proportionally. This feature enables users to quickly and independently scale computing capabilities during peak and off-peak hours. Storage can be expanded without limitation and paid on-demand to quickly and agilely responds to service changes with higher cost-effectiveness.
V8.2.0.107
Release date: October 7, 2023
Kernel version: 8.2.0
- GaussDB(DWS) supports user permission management. You can create, delete, and update database users and manage their permissions on the console.
- 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.
V8.2.0.106
Release date: August 14, 2023
Kernel version: 8.2.0
- 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.
- 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
- Allow users to deliver cluster upgrade operations on the console.
- WebSql supports operation audit.
- Metrics of multiple hosts can be displayed in a node-dimension monitoring view on the DMS monitoring panel.
- The CN can be added to a specified node.
V8.2.0.100
Release date: February 15, 2023
Kernel version: 8.2.0
- The product type "Cloud data warehouse" is changed to "Standard data warehouse".
- The resource management page is reconstructed.
- 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.
- 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.
- You can configure the parameters for creating and restoring a snapshot.
- DMS can monitor locks and report alarms.
V8.1.3.300
Release date: December 20, 2022
Kernel version: 8.1.3
- A topology is added to show all the nodes in a cluster. You can check the node statuses, processes, and IP addresses.
- A cluster can be bound to the ELB in a different enterprise project or VPC.
- 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
- 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.
- Workload Management is renamed Resource Management, and its usability is enhanced.
- Optimized resource pool exception rules. You can configure the data spilled to disk per DN and the average CPU usage per DN.
- 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
- The resizing function is added. You can adjust the specifications of the current cluster or change the cluster topology.
- Snapshots can be restored to the current cluster.
- Snapshot creation can be manually stopped.
- The database monitoring can show server-level trends.
- On the node management page, you can modify the alias of a node.
- Enhanced the features of database kernel version 8.1.3. For details, see .
V8.1.3.101
Release date: August 23, 2022
Kernel version: 8.1.3
- GaussDB(DWS) supports connection to clusters based on DAS.
- Logical clusters support resource management.
- You can use the Windows gsql client to connect to a cluster.
- In GaussDB(DWS), you can connect to a cluster from the Python libraries psycopg2 and PyGreSQL.
- 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
- 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
- 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
- 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.
- Cluster redistribution can be scheduled. Tables are redistributed only within the time window you configured.
- Added support for database kernel version 8.1.3. For details, see .
V8.1.1.300
Release date: April 15, 2022
Kernel version: 8.1.1
- During scale-out, you can configure the number of concurrent redistribution tasks.
- You can create a data source connection for a user-defined MRS 3.0.x cluster.
- The cluster scale-in function is added. You can reduce the computing and storage resources used by your GaussDB(DWS) cluster.
- The online scale-out function is added for logical clusters.
- Added the Log Tank Service (LTS) function. You can view collected cluster logs or dump logs in LTS.
- You can check the snapshot capacity, monitoring statistics, and cold data capacity.
- DMS is updated and the following functions are added:
- 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.
- Query monitoring is changed to real-time query. It displays real-time information about all the queries and sessions running in the cluster.
- Session monitoring is changed to historical query. It displays all the historical query information in the current cluster.
- 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.
- The SQL probe function is added. You can upload and verify SQL probes, execute probe tasks in one click, and periodically execute probe tasks.
- 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.
- Alarms can be generated for resource pool queue congestions.
V1.7.1
Release date: March 20, 2020
- 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
- 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.
- 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.
Feedback
Was this page helpful?
Provide feedbackThank you very much for your feedback. We will continue working to improve the documentation.