检测到您已登录华为云国际站账号，为了您更好的体验，建议您访问国际站服务网站 https://www.huaweicloud.com/intl/zh-cn
不再显示此消息
检测到您已登录华为云国际站账号，为了您更好的体验，建议您访问国际站服务网站 https://www.huaweicloud.com/intl/zh-cn
不再显示此消息
For example, if an ECS (settled by hour) is deleted at 08:30, the fees generated during 08:00 to 09:00 are usually deducted at about 10:00. In the Billing Center, choose Billing > Expenditure Items.
Compute Insufficient CPU or memory capacity Use a larger ECS flavor. The cluster needs to restart once. No need for data migration. Can be completed within 5 to 10 minutes.
Procedure Before using GDS to import or export data, see "Preparing an ECS as the GDS Server" and "Downloading the GDS Package" in Tutorial: Using GDS to Import Data from a Remote Server.
For details, see Logging In to an ECS in the MapReduce Service User Guide.
Procedure Preparing an ECS as the gsql Client Host. Download the gsql client and use an SSH transfer tool (such as WinSCP) to upload it to the Linux server where gsql is to be installed. For details, see Downloading the Client.
Local SSD: Local disks in ECS flavors serve as data storage media, offering fixed capacity and superior performance. However, disk scale-out is not supported. For more information, see What Are the Differences Between Cloud SSDs and Local SSDs?
Local SSD: Local disks in ECS flavors serve as data storage media, offering fixed capacity and superior performance. However, disk scale-out is not supported. For more information, see What Are the Differences Between Cloud SSDs and Local SSDs?
Using Shell Scripts to Automatically Execute Queries and Collect Results Log in to the ECS, go to the /opt directory, and run the vim commands to generate two script files query.conf and run_query.sh. The script content is as follows. After editing the script, press :wq!
Table 3 Advanced settings Parameter Example Value Tag test01 Hostname Prefix (Optional) Prefix for the name of an ECS or BMS in the cluster. Auto Scaling Retain the default value. Bootstrap Action Retain the default value. MRS 3.x does not support this parameter.
Starting or stopping a cluster After the cluster is stopped, ECS basic resources (vCPUs and memory) are no longer reserved. When you start the service again, it may fail to be started due to insufficient resources. In this case, wait for a while and try again later.
version number of GDS, run the following command in the GDS decompression directory: gds -V To view the database version, run the following SQL statement after connecting to the database: 1 SELECT version(); Procedure Before using GDS to import or export data, see "Preparing an ECS
Procedure Preparing an ECS as the gsql Client Host. Download the gsql client and use an SSH transfer tool (such as WinSCP) to upload it to the Linux server where gsql is to be installed. For details, see Downloading the Client.
version number of GDS, run the following command in the GDS decompression directory: gds -V To view the database version, run the following SQL statement after connecting to the database: 1 SELECT version(); Procedure Before using GDS to import or export data, see "Preparing an ECS
Interconnecting GaussDB(DWS) with Power BI Describes how to install Power BI on a Windows ECS and connect it to GaussDB(DWS) using an on-premises data gateway.
Replace the IP address with the private network IP address of ECS to ensure that GaussDB(DWS) can communicate with GDS through this IP address. The port numbers are 5000 and 5001 for TPC-H and 5002 and 5003 for TPC-DS.
STOPPED sub_status String Node sub-status READY: The ECS on the node is ready. PREPARED: The node software has been installed. INITED: The cluster has been created.
Scaling Out with Idle Nodes To ensure reliability, prepare ECS first by referring to Adding Nodes for a large-scale cluster, and scale out the cluster using idle nodes.
For instance, if two primary and two standby DNs are deployed on an ECS, at least four 500 GB disks must be mounted to the ECS. Cost-sensitive customers: At least 200 GB (160 MB/s per disk) is mounted to each primary/standby DN.
Using Commands to Generate TPC-H Test Sets The SQL statements of the 22 standard TPC-H queries can be generated as follows: Log in to the ECS and run the following commands: 1 2 3 4 5 6 7 8 cd /data1/script/tpch-kit/TPC-H_Tools_v3.0.0/dbgen cp qgen queries cp dists.dss queries cd
Replace the IP address with the private network IP address of ECS to ensure that GaussDB(DWS) can communicate with GDS through this IP address. The port numbers are 5000 and 5001 for TPC-H and 5002 and 5003 for TPC-DS.
