Scale the DB without scaling your engineers
Rating: 8 out of 10
June 12, 2021
Vetted Review
Verified User
4 years of experience
We use it as the core database for our entire IoT platform and for all our customers.
- We use it as a replacement for having a separate in-memory cache and a traditional disk-based database because SingleStore does both in a single package.
- We also use the row store for storing transactional state and the column store for storing time series data. Having both in the same product is nice.
- We get 7x compression for the time series data, which is really good for scaling.
Cons
- We wish the product had better support for High Availability of the aggregator. Currently the indexes generated by the two different aggregators are not in the same sequential space and so our apps have more burden to deal with HA.
- More tools for debugging issues such as high memory usage would be good.
- The price was the one that kept us away from purchasing for the first few years. Now we are able to afford due to a promotion that gives it at 25% of the list price. Not sure if we'll continue after the promotion offer expires in another 2 years.