Data Warehouse Flavors

Standard Data Warehouse (DWS 2.0) Flavors

• A standard data warehouse (DWS 2.0) using cloud disks can be elastically scaled, providing unlimited computing and storage capacity. For details, see Table 1.
• A standard data warehouse (DWS 2.0) using local disks cannot be scaled up. You can only increase capacity by adding nodes. For details, see Table 2.
  

  Step indicates the interval for increasing or decreasing the disk size during cluster configuration change. You need to select a value based on the storage step of the corresponding flavor.

  Table 1 Cloud disk flavors of a standard data warehouse (DWS 2.0)

  Flavor	CPU Architecture	vCPU	Memory (GB)	Storage Capacity Per Node	Default Storage	Step (GB)	Recommended Storage	DN number	Scenario
  dwsx2.xlarge.m7	x86	4	32	20GB ~ 2000GB	100	10	800	1	Suitable for GaussDB(DWS) starters. These flavors can be used for testing, learning environments, or small-scale analytics systems.
  dwsk2.xlarge	ARM	4	32	20GB ~ 2000GB	100	10	800	1
  dwsx2.xlarge.m7n	x86	4	32	20GB ~ 2000GB	100	10	800	1
  dwsx2.2xlarge.m7	x86	8	64	100 GB – 4000 GB	200	100	1600	1	Suitable for internal data warehousing and report analysis in small- and medium-sized enterprises (SMEs).
  dwsk2.2xlarge	ARM	8	64	100 GB – 4000 GB	200	100	1600	1
  dwsx2.2xlarge.m7n	x86	8	64	100 GB – 4000 GB	200	100	1600	1
  dwsx2.4xlarge.m7	x86	16	128	100GB ~ 8000GB	400	100	3200	1
  dwsk2.4xlarge	ARM	16	128	100GB ~ 8000GB	400	100	3200	1
  dwsx2.8xlarge.m7	x86	32	256	100GB ~ 16000GB	800	100	6400	2	Recommended for the production environment. These flavors are applicable to OLAP systems that have to deal with large data volumes, BI reports, and data visualizations on large screens for most companies.
  dwsk2.8xlarge	ARM	32	256	100GB ~ 16000GB	800	100	6400	2
  dwsx2.8xlarge.m7n	x86	32	256	100GB ~ 16000GB	800	100	6400	2
  dwsk2.12xlarge	ARM	48	384	100 GB – 24,000 GB	1200	100	9600	4	These flavors can deliver excellent performance and are applicable to high-throughput data warehouse processing and high-concurrency online query.
  dwsx2.16xlarge.m7	x86	64	512	100 GB – 32,000 GB	1600	100	12800	4
  dwsx2.16xlarge.m7n	x86	64	512	100 GB – 32,000 GB	1600	100	12800	4

Standard Data Warehouse (DWS 3.0) Flavors

• A standard data warehouse (DWS 3.0) using cloud disks can be elastically scaled, providing unlimited computing and storage capacity. For details, see Table 3.
• A standard data warehouse (DWS 3.0) using cloud disks have fixed flavors. You can only expand it by adding nodes. For details about the flavors, see Table 4.

Hybrid Data Warehouse Flavors

• A hybrid data warehouse can be deployed in cluster or standalone mode.
  • Cluster deployment: If the name of the selected node flavor contains h, the hybrid data warehouse can be deployed in cluster mode. You can deploy multiple nodes, scale nodes, and manage resource pools. For more information, see Table 5.
  • Standalone deployment: If the name of the selected node flavor contains h1, the hybrid data warehouse only supports standalone deployment, which does not provide HA capabilities. The storage cost can be reduced by half. A standalone data warehouse can be restored by the automatic reconstruction of ECS, and its data reliability is ensured by the EVS multi-copy mechanism. For more information, see Table 6. It is less expensive than other flavors and is a good choice for lightweight services.

Stream Data Warehouse Flavors