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
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.
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