The SingleStore cluster environment that is used for this solution, consists of multiple VMs. The implementation divides the server VMs into two broad categories: aggregator and leaf VMs. Each VM type has a configuration optimized for its role in the cluster.
The following tables list the VM definitions and configurations:
Table 3. VM definition
Aggregator | 2 | An aggregator is a node that routes the queries to the leaves, aggregates intermediate results, and sends the results back to the client. There are two types of aggregators: master and child. |
Leaf [1-6] | 3-6 | A leaf is a node that stores a subset of a cluster’s data. It functions as a storage and compute node. To optimize performance, SingleStore automatically distributes the data across leaf nodes into partitions. Each leaf contains several partitions. |
Table 4. VM configurations
Master aggregator | 16 | 64 GB |
Child Aggregator | 16 | 64 GB |
Leaf [1-6] | 16 / 32 | 64/160/256 GB |
