1. Home
  2. Relational Databases
  3. SingleStore Reviews
  4. User Review of SingleStore
SingleStore provides for customer-facing internal users but fails for production usage
August 30, 2021

SingleStore provides for customer-facing internal users but fails for production usage

Anonymous | TrustRadius Reviewer
Score 8 out of 10
Vetted Review
Verified User

Overall Satisfaction with SingleStore (formerly MemSQL)

SingleStore is used for 2 main use cases:
  • In-house developed A/B testing analysis tool uses this to fetch raw data in real-time when end users analyse the tests using the UI.
  • Machine learning models fetch the raw data and calculate needed features in real-time instead of preprocessing the data by the data engineers.
  • Return results of complex queries scanning TBs of data in sub-seconds.
  • Customer support team answer tickets quickly and provide guidance.
  • MySQL engine which allows to query using simple MySQL drivers from different clients.
  • Queries profiling is easy to use and helps investigating performance.
  • Loading batch data using pipelines is complex.
  • No native monitoring and alerts of resources (CPU, RAM, etc.).
  • Performance is strongly coupled with number of nodes (sometimes extra nodes hurt the performance).
  • Very expensive compared to other databases.
  • Hurt production tests when CPU was high cause a query was stuck but no alert was sent on it.
  • Helps providing internal users with fast results in order to take more data oriented decisions.
SingleStore provides a solution for working with larger amount of data (vs. MySQL) with better performance (vs. BigQuery) without having to preprocess the data (vs. MongoDB), so basically it does better for specific use cases.
Using it for production data science models without preprocessing the data Using it for "live" dashboards in order to see fresh data Using it for analysing lots of data fast so the end user doesn't have to wait for complex queries.
We didn't scale up/down, we did have a case of a very simple query on top of a small dataset which didn't perform well because there were too many nodes and we had to create another smaller cluster for it to perform well.

Do you think SingleStore delivers good value for the price?

Not sure

Are you happy with SingleStore's feature set?

Yes

Did SingleStore live up to sales and marketing promises?

No

Did implementation of SingleStore go as expected?

Yes

Would you buy SingleStore again?

Yes

SingleStore is well suited for analyzing big raw data in order to provide users with timely fashioned answers, as well as helping less technical teams to be independent of engineering teams and use simple SQL in order to use this data. The problem is that when there's a need to support more than a few TBs the price is very expensive and therefore it will be harder to use for applications in production when sub-second (less than 20ms) response is required.