What's New
The tables below describe the functions released in each GaussDB(DWS) version and corresponding documentation updates. New features will be successively launched in each region.
September 2024
No. |
Feature |
Description |
Phase |
Document |
---|---|---|---|---|
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 |
August 2024
No. |
Feature |
Description |
Phase |
Document |
---|---|---|---|---|
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 |
|
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 |
July 2024
No. |
Feature |
Description |
Phase |
Document |
---|---|---|---|---|
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.
|
Commercial use |
|
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 |
|
4 |
Optimized the cluster upgrade page |
Optimization points:
|
Commercial use |
May 2024
No. |
Feature |
Description |
Phase |
Document |
---|---|---|---|---|
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 |
|
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 |
|
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 |
|
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 |
|
5 |
LakeFormation data sources |
On the GaussDB(DWS) console, you can create a LakeFormation data source to access metadata on LakeFormation. |
Commercial use |
|
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 |
|
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 |
|
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 |
|
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 |
|
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 |
April 2024
No. |
Feature |
Description |
Phase |
Document |
---|---|---|---|---|
1 |
8.3.0.100 cluster version |
8.3.0.100 cluster version. |
Commercial use |
March 2024
No. |
Feature |
Description |
Phase |
Document |
---|---|---|---|---|
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 |
|
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 |
|
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 |
|
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 |
|
5 |
One-Click Clearing of All Idle Sessions |
You can clear all idle sessions by one click. |
Commercial use |
|
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 |
November 2023
No. |
Feature |
Description |
Phase |
Document |
---|---|---|---|---|
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 |
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 |
-- |
October 2023
No. |
Feature |
Description |
Phase |
Document |
---|---|---|---|---|
1 |
Cluster version 8.1.3.323 (recommended version) is released. |
Solved some other database problems. |
Commercial use |
-- |
September 2023
No. |
Feature |
Description |
Phase |
Document |
---|---|---|---|---|
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 |
|
3 |
The database audit log dump function is optimized. |
|
Commercial use |
|
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 |
August 2023
No. |
Feature |
Description |
Phase |
Document |
---|---|---|---|---|
1 |
8.1.3.322 cluster version (recommended version) is released. |
|
Commercial use |
July 2023
No. |
Feature |
Description |
Phase |
Document |
---|---|---|---|---|
1 |
The 8.2.0.106 cluster version is released. |
Solved some other database problems. |
Commercial use |
-- |
May 2023
No. |
Feature |
Description |
Phase |
Document |
---|---|---|---|---|
1 |
8.1.3.320 cluster version (recommended version) is released. |
|
Commercial use |
-- |
2 |
8.2.0.103 cluster version is released. |
Solved some other database problems. |
Commercial use |
-- |
April 2023
No. |
Feature |
Description |
Phase |
Document |
---|---|---|---|---|
1 |
8.2.0.102 cluster version is released. |
|
Commercial use |
-- |
2 |
Cluster upgrade on the console |
Users can perform cluster upgrade operations on the console. |
Commercial use |
|
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 |
|
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 |
|
5 |
Adding a CN to a specified node |
CNs can be added to a specified node. |
Commercial use |
March 2023
No. |
Feature |
Description |
Phase |
Document |
---|---|---|---|---|
1 |
8.1.3.310 cluster version (recommended version) roll-out |
|
Commercial use |
|
2 |
8.2.0.101 cluster version roll-out |
Some other database problems are solved. |
Commercial use |
-- |
February 2023
No. |
Feature |
Description |
Phase |
Document |
---|---|---|---|---|
1 |
Product name change |
Cloud Data Warehouse is changed to Standard Data Warehouse. |
Commercial use |
|
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 |
|
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 |
|
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 |
|
5 |
Snapshot parameter configuration |
You can specify parameters for creating a snapshot and restoring a snapshot to optimize the snapshot function. |
Commercial use |
|
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 |
January 2023
No. |
Feature |
Description |
Phase |
Document |
---|---|---|---|---|
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 |
December 2022
No. |
Feature |
Description |
Phase |
Document |
---|---|---|---|---|
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 |
|
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 |
November 2022
No. |
Feature |
Description |
Phase |
Document |
---|---|---|---|---|
1 |
Optimized discount packages |
Discount packages can be shared in all projects under a single account. |
Commercial use |
|
2 |
8.2.0 cluster rollout |
The 8.2.0 kernel has been rolled out. |
Commercial use |
|
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 |
|
4 |
The usability of resource management is improved |
|
Commercial use |
|
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 |
|
6 |
Node alias can be modified |
CNs can be associated with CN aliases on the node management page. |
Commercial use |
|
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 |
|
8 |
Snapshot creation can be manually stopped |
After a snapshot is created, you can manually stop the snapshot. |
Commercial use |
|
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 |
|
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 |
October 2022
No. |
Feature |
Description |
Phase |
Document |
---|---|---|---|---|
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.
|
Commercial use |
August 2022
No. |
Feature |
Description |
Phase |
Document |
---|---|---|---|---|
1 |
Workload management for logical clusters |
You can manage the workloads of logical clusters. |
Commercial use |
|
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 |
|
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 |
|
4 |
Connections from the Windows gsql clients to clusters |
The database connection command line tool gsql supports Windows. |
Commercial use |
|
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 |
June 2022
No. |
Feature |
Description |
Phase |
Document |
---|---|---|---|---|
1 |
Cluster versions 8.1.1.500 and 8.1.3.100 |
|
Commercial use |
May 2022
No. |
Feature |
Description |
Phase |
Document |
---|---|---|---|---|
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 |
|
2 |
Snapshot type display |
You can check whether a snapshot is an incremental or full snapshot on the management console. |
Commercial use |
|
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 |
April 2022
No. |
Feature |
Description |
Phase |
Document |
---|---|---|---|---|
1 |
Logical cluster scale-out online |
Logical clusters can be scaled out online. |
Commercial use |
|
2 |
8.1.3 database kernel |
8.1.3 database functions are supported. |
Commercial use |
|
3 |
Enhanced DMS |
|
Commercial use |
|
4 |
Cluster scale-in |
Cluster scale-in is supported. |
Commercial use |
|
5 |
Concurrency configuration for scale-out |
During scale-out, you can configure the number of concurrent redistribution tasks. |
Commercial use |
|
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 |
|
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 |
|
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 |
|
9 |
Cluster capacity display |
You can check the snapshot capacity, monitoring statistics, and cold data capacity. |
Commercial use |
|
10 |
Interconnection with Log Tank Service (LTS) |
You can view the collected cluster logs or dump logs on LTS. |
Commercial use |
|
11 |
Resource pool queue congestion alarm |
Alarms can be generated for resource pool queue congestions. |
Commercial use |
March 2022
No. |
Feature |
Description |
Phase |
Document |
---|---|---|---|---|
1 |
Disk capacity expansion |
You can expand the disk capacity of cloud data warehouse clusters on the console. |
Commercial use |
|
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 |
February 2022
No. |
Feature |
Description |
Phase |
Document |
---|---|---|---|---|
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 |
|
2 |
Real-time data warehouse |
|
Commercial use |
|
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 |
|
4 |
Extended the range of GUC parameters supported by the console. |
New GUC parameters can be modified on the console. |
Commercial use |
December 2021
No. |
Feature |
Description |
Phase |
Document |
---|---|---|---|---|
1 |
Database monitoring |
Fine-grained database monitoring on nodes, performance, databases, sessions, queries, instances, and load metrics. |
Commercial use |
|
2 |
Phase-based scaling |
Added the phase-based scale-out function. The phases include node addition, cluster scale-out, and database redistribution.
|
Commercial use |
|
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 |
|
4 |
More GUC parameters can be configured on the console. |
More GUC parameters can be modified on the console. |
Commercial use |
|
5 |
Alarm |
Added the alarm management function to allow users to view alarms triggered by DMS on the console. |
Commercial use |
July 2021
No. |
Feature |
Description |
Phase |
Document |
---|---|---|---|---|
1 |
8.1.1.100 database kernel |
|
Commercial use |
|
2 |
CN management |
The number of manageable CNs increased from 5 to 20. CNs can be added or deleted on the console. |
Commercial use |
|
3 |
Online scale-out |
During cluster scale-out, data can be continuously imported to the database. |
Commercial use |
|
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 |
|
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 |
May 2021
No. |
Feature |
Description |
Phase |
Document |
---|---|---|---|---|
1 |
8.1.0 kernel version |
Made the following changes:
|
Commercial use |
|
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 |
February 2021
No. |
Feature |
Description |
Phase |
Document |
---|---|---|---|---|
1 |
Optimized discount package page |
Supported monthly and yearly discount packages. |
Commercial use |
|
2 |
Optimized flavor page of second-generation clusters |
Cloud or standard data warehouses can be selected during cluster creation.
|
Commercial use |
December 2020
No. |
Feature |
Description |
Phase |
Document |
---|---|---|---|---|
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 |
July 2020
No. |
Feature |
Description |
Phase |
Document |
---|---|---|---|---|
1 |
Workload management |
Workload management enables concurrent and independent execution of two types of jobs. |
Commercial use |
|
2 |
gs_dump, gs_dumpall |
|
Commercial use |
April 2020
No. |
Feature |
Description |
Phase |
Document |
---|---|---|---|---|
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 |
|
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 |
December 2019
No. |
Feature |
Description |
Phase |
Document |
---|---|---|---|---|
1 |
Added the request parameter Enterprise Project. |
Added the Enterprise Project parameter to the API. |
Commercial use |
August 2019
No. |
Feature |
Description |
Phase |
Document |
---|---|---|---|---|
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 |
|
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 |
February 2019
No. |
Feature |
Description |
Phase |
Document |
---|---|---|---|---|
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 |
Feedback
Was this page helpful?
Provide feedbackThank you very much for your feedback. We will continue working to improve the documentation.See the reply and handling status in My Cloud VOC.
For any further questions, feel free to contact us through the chatbot.
Chatbot