Data Warehouse Flavors¶
Flavors for Storage-Compute Coupled Clusters¶
A storage-compute coupled data warehouse using cloud disks with a vCPU to memory ratio of 1:8 can be elastically scaled, providing unlimited computing and storage capacity. For details, see Table 1.
Flavor | CPU Architecture | vCPU | Memory (GB) | Storage Capacity Per Node | Default Storage | Step (GB) | Recommended Storage | Number of DNs | Scenario |
|---|---|---|---|---|---|---|---|---|---|
dwsx2.xlarge.m7n | x86 | 4 | 32 | 20 GB-2,000 GB | 100 | 10 | 800 | 1 | Suitable for GaussDB(DWS) starters. These flavors can be used for testing, learning environments, or small-scale analytics systems. |
dwsx2.2xlarge.m7n | x86 | 8 | 64 | 100 GB-4,000 GB | 200 | 100 | 1600 | 1 | Suitable for internal data warehousing and report analysis in small- and medium-sized enterprises (SMEs). |
dwsx2.4xlarge.m7n | x86 | 16 | 128 | 100 GB-8,000 GB | 400 | 100 | 3200 | 1 | |
dwsx2.8xlarge.m7n | x86 | 32 | 256 | 100 GB-16,000 GB | 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. |
dwsx2.16xlarge.m7n | x86 | 64 | 512 | 100 GB-32,000 GB | 1600 | 100 | 12800 | 4 | These flavors can deliver excellent performance and are applicable to high-throughput data warehouse processing and high-concurrency online query. |