检测到您已登录华为云国际站账号，为了您更好的体验，建议您访问国际站服务网站 https://www.huaweicloud.com/intl/zh-cn
不再显示此消息
检测到您已登录华为云国际站账号，为了您更好的体验，建议您访问国际站服务网站 https://www.huaweicloud.com/intl/zh-cn
不再显示此消息
Creating an ECS and GaussDB(DWS) Data Warehouse Creating an ECS Server Creating a DWS Data Warehouse Parent topic: Test Methods
Making Preparations You have purchased a Windows ECS and the Windows Server is running properly. (If the existing ECS or local PC meets the requirements, you do not need to purchase an ECS separately.) You have purchased a GaussDB(DWS) cluster.
Log in to the ECS and run the following command to create a directory for storing the TPC-H tools: 1 2 mkdir -p /data1/script/tpch-kit/tpch1000X mkdir -p /data2/script/tpch-kit/tpch1000X Use SFTP to upload the obtained TPC-H tools to the /data1/script/tpch-kit directory of the ECS
The cloud services used in this practice are GaussDB(DWS), Elastic Cloud Server (ECS), and Virtual Private Cloud (VPC).
If the ECS has a firewall, check the firewall configuration.
If an expired ECS is not renewed, it enters a grace period. If it is not renewed by the time the grace period expires, the ECS will be frozen and enter a retention period.
48 384 Arm ECS/storage-compute decoupling EVS dws2.m6.4xlarge.8 16 128 x86 ECS/EVS dws2.m6.8xlarge.8 32 256 x86 ECS/EVS dws2.m6.16xlarge.8 64 512 x86 ECS/EVS dws2.km1.4xlarge.8 16 128 Arm ECS/EVS dws2.km1.6xlarge.8 24 192 Arm ECS/EVS dws2.km1.8xlarge.8 32 256 Arm ECS/EVS dws2.km1.12xlarge
Creating an ECS Server Create an ECS by referring to the Elastic Cloud Server User Guide. The following table lists the created flavors. TPC-DS and TPC-H data sets occupy large space. For example, TPC-DS 1000X and TPC-H 1000X occupy 930 GB and 1100 GB, respectively.
*:get*", "ecs:*:list*", "ecs:*:start", "ecs:*:stop" Not supported: Enterprise projects Supported: Projects Stopping a cluster "dws:cluster:stopCluster" "dws:*:get*", "dws:*:list*", "ecs:*:get*", "ecs:*:list*", "ecs:*:start", "ecs:*:stop" Not supported: Enterprise projects Supported
(Optional) Public network bandwidth When a yearly/monthly cluster is configured with an EIP billed by bandwidth, the bandwidth is billed by the Elastic Cloud Server (ECS) service in yearly/monthly mode.
*:get*", "ecs:*:list*", "elb:*:list*", "ecs:*:create*", "ecs:*:delete*", "vpc:*:get*", "vpc:*:list*", "vpc:*:create
The key points in communication check are the ECS outbound rule and GaussDB(DWS) inbound rule. The check procedure is as follows: Check the ECS outbound rules: Ensure that the outbound rule of the ECS security group allows access.
(Optional) Preparing an ECS as the gsql Client Server For how to purchase an ECS, see Purchasing an ECS in the Elastic Cloud Server Getting Started. The created ECS must meet the following requirements: ECS and GaussDB(DWS) clusters must belong to the same region and AZ.
(Optional) Preparing an ECS as the gsql Client Server For details about how to purchase an ECS, see Purchasing an ECS in the Elastic Cloud Server Getting Started.
To ensure network connectivity between ECS and DWS, the created data warehouse and ECS must be in the same region, VPC, and subnet.
The driver can connect to the database through an ECS on the Huawei Cloud platform or over the Internet. When using the JDBC driver to connect to the data warehouse cluster, determine whether to enable SSL authentication.
Using an ODBC Driver to Connect to a Database GaussDB(DWS) allows you to use an ODBC driver to connect to the database through an ECS on the Huawei Cloud platform or over the Internet. For details about how to use the ODBC API, see the official document.
Cloud SSDs are not bound to the ECS flavor. Therefore, you can adjust the flavors of cloud SSDs when needed. Local SSDs Local SSDs use ECS local disks as storage media. They have fixed capacity and higher performance but cannot be scaled out.
Using ODBC to Connect to a Cluster GaussDB(DWS) allows you to use an ODBC driver to connect to the database through an ECS on the Huawei Cloud platform or over the Internet. For details about how to use the ODBC API, see the official document.
The driver can connect to the database through an ECS on the Huawei Cloud platform or over the Internet. When using the JDBC driver to connect to the data warehouse cluster, determine whether to enable SSL authentication.
