Ecosystem Building: Steady Cloud Adoption — Deep Integration between GBase and VMware, a Leading Commercial Virtualization Product

VMware vSAN is enterprise-grade storage virtualization software. Its vSAN-based hyperconverged infrastructure reduces storage costs by 40% or more compared to traditional server and storage architectures. GBase 8a MPP running on VMware vSAN has passed benchmark performance validation, outperforming traditional physical servers in performance metrics, high availability, and more.

GBase 8a MPP Architecture on VMware vSAN

GBase 8a MPP is deployed on VMs provided by VMware vSphere, using vSAN-based VMDK to store data files. The database deployment architecture diagram is shown below:

High Performance: Superior Performance on vSAN Hyperconverged Infrastructure

In performance testing, TPC-H benchmarks are used to measure query response time in single-user models, query throughput in multi-user models, and data maintenance performance under complex multi-user decision-making.

● Solution 1: Data storage is allocated a large space of 1 TB at a time, using striped storage. Storage policy allows 1 failure - RAID1 (mirroring), meaning data has one replica; the number of disk stripes per object is 7, distributed across 7 disks.
 

● Solution 2: Each VM is allocated 200 GB of storage, and more VM nodes are added to increase storage. Storage policy allows 1 failure - RAID1 (mirroring); the number of disk stripes per object is 1, meaning data resides on only one physical disk.
 

● Solution 3: Each VM is allocated 7 disks of 100 GB, combined into a larger logical volume via LVM within the VM OS. Storage policy allows 1 failure - RAID1 (mirroring); the number of disk stripes per object is 1.
 

Testing GBase 8a MPP with three different VMware vSAN storage strategies, the performance results indicate that all three strategies can outperform the baseline performance of physical servers, with the no-data-redundancy storage strategy achieving the highest write performance.
 

High Availability: GBase 8a MPP Gains Enhanced High Availability with VMware

Thanks to the high availability capabilities provided by VMware, GBase 8a MPP demonstrates significantly better high availability than physical servers on VMware vSphere vMotion (with vSphere HA and DRS enabled and storage policy set to RAID 1). The high availability testing scenarios include:
 

● Compute resources can be adjusted offline;

● Storage resources can be added online;

● Adding nodes aligns with GBase cluster scaling;
 

The GBase 8a MPP solution based on VMware vSAN is optimized and validated for VMware vSAN all-flash SSD workloads, delivering enhanced high performance and high availability for GBase database products. It meets the needs of industry users for massive data storage and processing, ensures the stable operation of critical business, and lays a solid foundation for digital transformation.