SingleStoreDB supports Flexible Parallelism, which allows multiple cores on the same node to access the same database partition.
With Flexible Parallelism, as database partitions are created they are divided into sub-partitions.
As an example, if you are currently at one partition per core with Flexible Parallelism, doubling the size of your workspace and then rebalancing will result in two cores for each partition.
Typically, analytic or hybrid transactional/analytic workloads will gain some benefits from Flexible Parallelism, especially over time as you add more hardware and rebalance workspaces.
As you add cores to your SingleStore system, you can reach a point where you have more cores than database partitions on each leaf node.
When Flexible Parallelism is enabled, all new databases created will use Flexible Parallelism.
Flexible Parallelism is enabled by default for new workspaces in SingleStoreDB Cloud with the following settings:
One physical partition per leaf core at database creation time
16 sub-partitions per physical partition
One thread per leaf core
If you’re an existing customer who began using SingleStoreDB Cloud before May 2022, and wish to have Flexible Parallelism enabled for new databases, contact Support.
Last modified: June 29, 2023