SingleStore DB

Aggregator to Leaf Ratio

The minimal setup for a SingleStore DB cluster is just one aggregator (the master aggregator) and one leaf. You can add more aggregators, which will read metadata from the master aggregator, and can run DML commands on the leaves.

The number of deployed aggregator and leaf nodes determines the storage size and performance of a cluster. Typical deployments have a 5:1 ratio of leaf:aggregator nodes. In a well-designed cluster:

  • Applications that require higher connection capabilities from application servers have a higher aggregator-to-leaf node ratio.

  • Applications with larger storage requirements have a higher leaf-to-aggregator node ratio.