SingleStore is great and it's there to give a tough fight to others in market.
December 03, 2020

SingleStore is great and it's there to give a tough fight to others in market.

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

Overall Satisfaction with SingleStore (formerly MemSQL)

We are using SingleStore for analytical data processing workflow with [a] huge volume of columnar data set. Recently we started utilizing rowstore for real-time data processing. One thing is evident that SingleStore is really fast for similar data processing conditions compared to competitions. During our journey of adopting SingleStore, we also faced some challenges. We hope that SingleStore [will] be supported on AWS ECS containers. Overall, nice data solution [and] really fast data processing.
  • Columnstore compression of data is awesome. Sometimes we got 85+ % compression.
  • Rowstore is ultrafast.
  • Kafka based pipeline is awesome.
  • Support for running it on AWS ECS containers.
  • It gave our business a jump-start by providing [a] single solution for both analytical and real time workloads.
Redshift was evaluated and was in use for some time, but it lacks the speed which SingleStore has. Its pipeline concept is nice and serves our current requirement of Kafka-based data insert. It would be really great if SingleStore could support exactly-once semantics and provide direct support for protobuf messages.
We do number crunching for historical data ranging from yesterday to 365 days back in time. It helps us in meeting our analytical data processing requirement with simple to use kafka-based pipeline without worry about kafka connection handling or other inner details related to reading data from Kafka topics. It has control parameters to continue rate of consumption of kafka message which is really nice.

Do you think SingleStore (formerly MemSQL) delivers good value for the price?

No

Are you happy with SingleStore (formerly MemSQL)'s feature set?

No

Did SingleStore (formerly MemSQL) live up to sales and marketing promises?

Yes

Did implementation of SingleStore (formerly MemSQL) go as expected?

Yes

Would you buy SingleStore (formerly MemSQL) again?

Yes

It a nice solution if you have kafka-based data processing in your tech-stack. If you are more on ECS container, SingleStore has room for improvement in this area in terms of official support which avoid headache of managing EC2 instances yourselves. Also, SingleStore really shines for huge data storage in columnar store with very effective compression.

SingleStore (formerly MemSQL) Support

We have a desire to see some important features like protobuf support, AWS ECS support, etc. in the upcoming releases of SingleStore. So it's nice overall, but has room for improvement and hence this rating of 8. We are hoping that SingleStore will respond to feature requests soon by prioritizing them in their engineering backlog.

Using SingleStore (formerly MemSQL)

[Until it is] supported on AWS ECS containers, I will reserve a higher rating for SingleStore. Right now it works well on EC2 and serves our current purpose, [but] would look forward to seeing SingleStore respond to our urge of feature in a shorter time period with high quality and security.