Compare Cassandra vs. MemSQL

Cancel
You must select at least 2 products to compare!
Cassandra Logo
4,642 views|3,688 comparisons
MemSQL Logo
3,260 views|2,951 comparisons
Most Helpful Review
Use Cassandra? Share your opinion.
Quotes From Members

We asked business professionals to review the solutions they use. Here are some excerpts of what they said:

Pros
"The technical evaluation is very good."

More Cassandra Pros »

"MemSQL supports the MySQL protocol, and many functions are similar, so the learning curve is very short."

More MemSQL Pros »

Cons
"Interface is not user friendly."

More Cassandra Cons »

"There should be more pipelines available because I think that if MemSQL can connect to other services, that would be great."

More MemSQL Cons »

Pricing and Cost Advice
Information Not Available
"I would advise users to try the free 128GB version."

More MemSQL Pricing and Cost Advice »

report
Use our free recommendation engine to learn which NoSQL Databases solutions are best for your needs.
442,283 professionals have used our research since 2012.
Answers from the Community
Morten Calisch
author avatarC Dove
Real User

I haven't used SQream personally. However, if you are only considering GPU based rdbms's please check the following
https://hackernoon.com/which-gpu-database-is-right-for-me-6ceef6a17505

author avatarYuval Klein
Real User

SQreamDB is a GPU DB. It is not suitable for real-time oltp of course.

Cassandra is best suited for OLTP database use cases, when you need a scalable database (instead of SQL server, Postgres)
SQream is a GPU database suited for OLAP purposes. It's the best suite for a very large data warehouse, very large queries needed mass parallel activity since GPU is great in massive parallel workload.

Also, SQream is quite cheap since we need only one server with a GPU card, the best GPU card the better since we will have more CPU activity. It's only for a very big data warehouse, not for small ones.

author avatarTristan Bergh
Real User

Your best DB for 40+ TB is Apache Spark, Drill and the Hadoop stack, in the cloud.

Use the public cloud provider's elastic store (S3, Azure BLOB, google drive) and then stand up Apache Spark on a cluster sized to run your queries within 20 minutes. Based on my experience (Azure BLOB store, Databricks, PySpark) you may need around 500 32GB nodes for reading 40 TB of data.

Costs can be contained by running your own clusters but Databricks manage clusters for you.

I would recommend optimizing your 40TB data store into the Databricks delta format after an initial parse.

Questions from the Community
Top Answer: SQreamDB is a GPU DB. It is not suitable for real-time oltp of course. Cassandra is best suited for OLTP database use cases, when you need a scalable database (instead of SQL server, Postgres)… more »
Ask a question

Earn 20 points

Ranking
3rd
out of 16 in NoSQL Databases
Views
4,642
Comparisons
3,688
Reviews
1
Average Words per Review
292
Avg. Rating
9.0
21st
Views
3,260
Comparisons
2,951
Reviews
0
Average Words per Review
0
Avg. Rating
N/A
Popular Comparisons
Compared 17% of the time.
Compared 16% of the time.
Compared 10% of the time.
Compared 3% of the time.
Compared 21% of the time.
Compared 16% of the time.
Compared 14% of the time.
Compared 7% of the time.
Compared 3% of the time.
Learn
Apache
MemSQL
Video Not Available
Overview
A scalable multi-master database with no single points of failure. Scalability & high availability without compromising performance.

MemSQL is The No Limits Database™, powering modern applications and analytical systems with a cloud-native, massively scalable architecture for maximum ingest and query performance with the highest concurrency. MemSQL envisions a world where every business can make decisions in real time and every experience is optimized through data. Global enterprises use the MemSQL distributed database to easily ingest, process, analyze, and act on data in order to thrive in today’s insight-driven economy. MemSQL is optimized to run on any public cloud or on-premises with commodity hardware. To learn more, visit our Product page - https://msql.co/2xUDAqL. To use MemSQL, get started with a free trial - https://msql.co/2NZOAy9.

Headquartered in San Francisco, CA with offices in Seattle, WA and Portland OR, MemSQL has raised $110M from top investors including GV, Accel Partners, and Khosla Ventures, among others. MemSQL is trusted by customers including Uber, Akamai, Dell EMC, Samsung, Comcast, Kellogg, and more.

If you want to work at a company that celebrates diversity, innovation, leadership, and creativity every day, check out our openings on our Careers page - https://msql.co/2RoTZgn.

Offer
Learn more about Cassandra
Learn more about MemSQL
Sample Customers
Apple, BazaarVoice, Best Buy, eBay, NetflixUber, Akamai, Dell EMC, Samsung, Comcast, Kellogg
Top Industries
VISITORS READING REVIEWS
Computer Software Company37%
Comms Service Provider20%
Media Company8%
Manufacturing Company5%
VISITORS READING REVIEWS
Computer Software Company40%
Comms Service Provider14%
Media Company7%
Healthcare Company6%
Cassandra is ranked 3rd in NoSQL Databases with 1 review while MemSQL is ranked 21st in Relational Databases with 1 review. Cassandra is rated 9.0, while MemSQL is rated 10.0. The top reviewer of Cassandra writes "Excellent for technical evaluation and managing very large amounts of data". On the other hand, the top reviewer of MemSQL writes "MySQL Big Brother with built-in data pipeline, high concurrency, and blazing fast analytical queries". Cassandra is most compared with InfluxDB, Couchbase, Accumulo, Cloudera Distribution for Hadoop and DataStax, whereas MemSQL is most compared with CockroachDB, SQL Server, MySQL, SAP HANA and Oracle Database In-Memory.

See our list of .

We monitor all NoSQL Databases reviews to prevent fraudulent reviews and keep review quality high. We do not post reviews by company employees or direct competitors. We validate each review for authenticity via cross-reference with LinkedIn, and personal follow-up with the reviewer when necessary.