What users are saying about
76 Ratings
<a href='https://www.trustradius.com/static/about-trustradius-scoring#question3' target='_blank' rel='nofollow noopener noreferrer'>Customer Verified: Read more.</a>
25 Ratings
76 Ratings
<a href='https://www.trustradius.com/static/about-trustradius-scoring' target='_blank' rel='nofollow noopener noreferrer'>trScore algorithm: Learn more.</a>
Score 7.9 out of 100

SingleStore (formerly MemSQL)

<a href='https://www.trustradius.com/static/about-trustradius-scoring#question3' target='_blank' rel='nofollow noopener noreferrer'>Customer Verified: Read more.</a>
25 Ratings
<a href='https://www.trustradius.com/static/about-trustradius-scoring' target='_blank' rel='nofollow noopener noreferrer'>trScore algorithm: Learn more.</a>
Score 7.5 out of 100

Likelihood to Recommend

Cassandra

Apache Cassandra is a NoSQL database and well suited where you need highly available, linearly scalable, tunable consistency and high performance across varying workloads. It has worked well for our use cases, and I shared my experiences to use it effectively at the last Cassandra summit! http://bit.ly/1Ok56TKIt is a NoSQL database, finally you can tune it to be strongly consistent and successfully use it as such. However those are not usual patterns, as you negotiate on latency. It works well if you require that. If your use case needs strongly consistent environments with semantics of a relational database or if the use case needs a data warehouse, or if you need NoSQL with ACID transactions, Apache Cassandra may not be the optimum choice.
Rekha Joshi | TrustRadius Reviewer

SingleStore (formerly MemSQL)

SingleStore [formerly (MemSQL)] is very well suited for places- where the components are processing very large amounts of data and requires very low latency.- Columnstore compression of data reduces the time to respond. Compression resulted in quick responses which are not achieved using the other DB tools.- The concept of Rowstore and implementation on frequently used tables results in support of high OLTP.Not suited/less appropriate- The In-memory(Rowstore) and col-store does not share the same language compatibility. When required the transition form other table type more efforts are required.- SingleStore DB (formerly MemSQL) connection between AWS cloud failed when partitioning is higher for data processing.- Administration is sometime bit confusing when providing layered access to different teams.
Anonymous | TrustRadius Reviewer

Feature Rating Comparison

NoSQL Databases

Cassandra
8.0
SingleStore (formerly MemSQL)
Performance
Cassandra
8.5
SingleStore (formerly MemSQL)
Availability
Cassandra
8.7
SingleStore (formerly MemSQL)
Concurrency
Cassandra
7.6
SingleStore (formerly MemSQL)
Security
Cassandra
8.0
SingleStore (formerly MemSQL)
Scalability
Cassandra
9.4
SingleStore (formerly MemSQL)
Data model flexibility
Cassandra
6.7
SingleStore (formerly MemSQL)
Deployment model flexibility
Cassandra
7.0
SingleStore (formerly MemSQL)

Pros

Cassandra

  • Continuous availability: as a fully distributed database (no master nodes), we can update nodes with rolling restarts and accommodate minor outages without impacting our customer services.
  • Linear scalability: for every unit of compute that you add, you get an equivalent unit of capacity. The same application can scale from a single developer's laptop to a web-scale service with billions of rows in a table.
  • Amazing performance: if you design your data model correctly, bearing in mind the queries you need to answer, you can get answers in milliseconds.
  • Time-series data: Cassandra excels at recording, processing, and retrieving time-series data. It's a simple matter to version everything and simply record what happens, rather than going back and editing things. Then, you can compute things from the recorded history.
David Prinzing | TrustRadius Reviewer

SingleStore (formerly MemSQL)

  • Ease of use (installation, managed service, pipelines)
  • Hybrid configuration (on-premise & cloud), analytical and transactional workload
  • ANSI SQL as a standard
  • Runs on any major cloud platform
Erik Fransen | TrustRadius Reviewer

Cons

Cassandra

  • Cassandra runs on the JVM and therefor may require a lot of GC tuning for read/write intensive applications.
  • Requires manual periodic maintenance - for example it is recommended to run a cleanup on a regular basis.
  • There are a lot of knobs and buttons to configure the system. For many cases the default configuration will be sufficient, but if its not - you will need significant ramp up on the inner workings of Cassandra in order to effectively tune it.
Anonymous | TrustRadius Reviewer

SingleStore (formerly MemSQL)

  • Does not provide adequate support for data discovery apps, i.e. Power BI.
  • It would be great to have a native load balancing component for dealing with aggregator failure. Otherwise having a Child Aggregator becomes optional since not all the customers can afford an external balancing solution and does not feel confortable with switching between aggregators manually.
  • They used to have certifications and training in development and administration. That is very important to have, since other competitors does provide access to those sort of things and although they have free tutorials/videos, that doesn't provide an in-depth understanding.
Diego Montúfar | TrustRadius Reviewer

Likelihood to Renew

Cassandra

Cassandra 8.6
Based on 16 answers
I would recommend Cassandra DB to those who know their use case very well, as well as know how they are going to store and retrieve data. If you need a guarantee in data storage and retrieval, and a DB that can be linearly grown by adding nodes across availability zones and regions, then this is the database you should choose.
Anonymous | TrustRadius Reviewer

SingleStore (formerly MemSQL)

SingleStore (formerly MemSQL) 5.0
Based on 1 answer
I still want to see the performance about using latest version of spark and memsql. About renewal, if there is a new and better version of spark-memsql connector, then maybe.
Tianwen Chu | TrustRadius Reviewer

Usability

Cassandra

Cassandra 7.0
Based on 1 answer
It’s great tool but it can be complicated when it comes administration and maintenance.
Glen Kim | TrustRadius Reviewer

SingleStore (formerly MemSQL)

SingleStore (formerly MemSQL) 7.7
Based on 6 answers
[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.
Anonymous | TrustRadius Reviewer

Support Rating

Cassandra

Cassandra 7.0
Based on 2 answers
Sometimes instead giving straight answer, we ‘re getting transfered to talk professional service.
Glen Kim | TrustRadius Reviewer

SingleStore (formerly MemSQL)

SingleStore (formerly MemSQL) 7.7
Based on 6 answers
Very responsive to trouble tickets - Often, I think, the SingleStore's monitoring systems have already alerted the engineers by the time I get around to writing a ticket (about 10 - 20 mins after we see a problem). I feel like things are escalated nicely and SingleStore takes resolving trouble tickets seriously. Also SingleStore follows up after incidents to with a post mortem and actionable takaways to improve the product. Very satisfied here.
John Barry | TrustRadius Reviewer

Alternatives Considered

Cassandra

We evaluated MongoDB also, but don't like the single point failure possibility. The HBase coupled us too tightly to the Hadoop world while we prefer more technical flexibility. Also HBase is designed for "cold"/old historical data lake use cases and is not typically used for web and mobile applications due to its performance concern. Cassandra, by contrast, offers the availability and performance necessary for developing highly available applications. Furthermore, the Hadoop technology stack is typically deployed in a single location, while in the big international enterprise context, we demand the feasibility for deployment across countries and continents, hence finally we are favor of Cassandra
yixiang Shan | TrustRadius Reviewer

SingleStore (formerly MemSQL)

I guess the main difference is how the memory is used for stacking and storing data until it reaches the final destination, the performance is awesome compared with others and when you have a real time business with a certain complexity. The development team would be more familiarized with the SQL environment and there’s practically a zero learning curve, when you compare this with other data bases you’re going to find that there’s a huge saving in time and money.
Jacob Ortega | TrustRadius Reviewer

Return on Investment

Cassandra

  • I have no experience with this but from the blogs and news what I believe is that in businesses where there is high demand for scalability, Cassandra is a good choice to go for.
  • Since it works on CQL, it is quite familiar with SQL in understanding therefore it does not prevent a new employee to start in learning and having the Cassandra experience at an industrial level.
Anonymous | TrustRadius Reviewer

SingleStore (formerly MemSQL)

  • License cost is lower than many of its competitors.
  • Requires very little administration. We are getting by without even hiring an admin.
  • Integrating the pipelines and the DB engine simplifies the solution architecture, which means less infrastructure is needed, less license cost, and shorter development cycle.
Anonymous | TrustRadius Reviewer

Screenshots

Pricing Details

Cassandra

General

Free Trial
Free/Freemium Version
Premium Consulting/Integration Services
Entry-level set up fee?
No

Cassandra Editions & Modules

Additional Pricing Details

SingleStore (formerly MemSQL)

General

Free Trial
Yes
Free/Freemium Version
Yes
Premium Consulting/Integration Services
Yes
Entry-level set up fee?
Optional

SingleStore (formerly MemSQL) Editions & Modules

Edition
OnDemand0.691
  1. per hour
Additional Pricing Details

Rating Summary

Likelihood to Recommend

Cassandra
6.7
SingleStore (formerly MemSQL)
7.8

Likelihood to Renew

Cassandra
8.6
SingleStore (formerly MemSQL)
5.0

Usability

Cassandra
7.0
SingleStore (formerly MemSQL)
7.7

Support Rating

Cassandra
7.0
SingleStore (formerly MemSQL)
7.7

Implementation Rating

Cassandra
7.0
SingleStore (formerly MemSQL)

Add comparison