SingleStore as an analytics database
April 19, 2022

SingleStore as an analytics database

Ruslan Smirnov | TrustRadius Reviewer
Score 10 out of 10
Vetted Review
Verified User

Overall Satisfaction with SingleStore (formerly MemSQL)

SingleStore is perfect for running data analytics workloads due to how easy it is to get data in & out. The performance and ease of use of the product are almost unmatched, which saves us a tremendous amount of time over having to spin up custom RDS instances for data analytics.

Pros

  • I was amazed at the ability to connect to the cluster with third-party clients, including native vendor-supplied MySQL command line tools.
  • The ease of exporting data from an existing MySQL database and loading it into SingleStore is impressive.
  • Speed and ease of use. Everything is streamlined for you to hit the ground running with minimal learning curve.

Cons

  • The mysqldump file required some manual massaging before it could be ingested. This was expected, and I am surprised how little manual modification is needed, but nonetheless -- this could be improved.
  • Some GUI database tools (such as MySQL Workbench) have trouble connecting and need additional configuration.
  • Too early to say, but it definitely has the potential to save substantial amounts of time in spinning up custom data analytics instances and moving data into them.
It seems good at being able to handle complex queries against large datasets out of the box. In the past, we've had to do quite a bit of manual configuration and database performance-tuning, but SingleStore (so far) has seemed to require minimal configuration in this aspect. Both data imports/exports, as well as queries against the data, run very fast.
We've been using it exclusively for analytics so far, but I can definitely see this as something to explore in the future.
The SQL dialect seems to be pretty compatible, and I especially appreciate that you can connect to it with native MySQL tooling.

Do you think SingleStore delivers good value for the price?

Yes

Are you happy with SingleStore's feature set?

Yes

Did SingleStore live up to sales and marketing promises?

Yes

Did implementation of SingleStore go as expected?

I wasn't involved with the implementation phase

Would you buy SingleStore again?

Yes

Insofar, it seems perfect for data analytics workloads and ad-hoc queries against large datasets. What we particularly like is the ease with which data can be ingested, and the speed/performance of the product. Everything is very streamlined and in one place. I am not sure where it would be inappropriate as I haven't used it long enough, but so far I like everything.

Comments

More Reviews of SingleStore

  1. Home
  2. Relational Databases
  3. SingleStore Reviews
  4. User Review of SingleStore