SingleStore multiple aggregators?

Off-Topic
1

So from what I can tell, SingleStore truly is the most scalable database as of right now, AND it’s nearly perfect for analytics.

I’ve seen and admired the SingleStore Trillion Rows/sec blog post for quite some time now, but I have one question that I can’t seem to find an answer for.

Does SingleStore work only with 1 master aggregator, or can you use multiple? In the blog post, it appears as if SingleStore only used 1 Master Aggregator, but I was wondering if there’s a way to scale that to prevent less stress and possibly aggregate from different locations. I think this would be massively scalable while using hardware load balancing. Is it possible?

2

Hi @trent27on. Glad to see you back on the forums. Sure, you can configure SingleStore with multiple aggregators. Only one can be the master at a time. But queries and updates and DDL can be processed from any aggregator.

You can put a load balancer in front of the aggregators if you like, or load balance directly from your app.

Here’s a diagram showing multiple agregators.

3

Thank you! That total total sense!