The following table shows the details of the scenarios evaluated using the TPC-DS benchmark tool where all 99 queries were run in random order:
No of leaf nodes
vCPUs per leaf node
Memory per leaf node
The test was conducted starting with three leaf node virtual machines, 32 vCPUs per node, and 256 GB memory per leaf node. The number of leaf node VMs were increased gradually from 3 to 6 with a different number of vCPUs and memory per node to understand the variation in the performance. The execution time for the total 99 queries was captured for every scenario.
The current configuration supported the scaling of up to six leaf node VMs on four PowerFlex HCI nodes. Customers can add more PowerFlex nodes relative to the SingleStore leaf node VMs.
Note: SingleStore does not recommend overcommitting the vCPUs for the leaf nodes.