Need advice about which tool to choose?Ask the StackShare community!

MemSQL

Stacks79

Followers159

+ 1

Votes33

Redis

Stacks47.9K

Followers36.1K

+ 1

Votes3.9K

Add tool

MemSQL vs Redis: What are the differences?

What is MemSQL? Database for real-time transactions and analytics. MemSQL converges transactions and analytics for sub-second data processing and reporting. Real-time businesses can build robust applications on a simple and scalable infrastructure that complements and extends existing data pipelines.

What is Redis? An in-memory database that persists on disk. Redis is an open source, BSD licensed, advanced key-value store. It is often referred to as a data structure server since keys can contain strings, hashes, lists, sets and sorted sets.

MemSQL and Redis can be primarily classified as "In-Memory Databases" tools.

Redis is an open source tool with 37.4K GitHub stars and 14.4K GitHub forks. Here's a link to Redis's open source repository on GitHub.

Airbnb, Uber Technologies, and Instagram are some of the popular companies that use Redis, whereas MemSQL is used by Shutterstock, Zynga, and StreetHawk. Redis has a broader approval, being mentioned in 3261 company stacks & 1780 developers stacks; compared to MemSQL, which is listed in 10 company stacks and 4 developer stacks.

Get Advice from developers at your company using Private StackShare. Sign up for Private StackShare.

Learn More

Pros of MemSQL

Pros of Redis

8
Distributed
4
Realtime
3
JSON
3
Sql
3
Columnstore
3
Concurrent
2
Ultra fast
2
Scalable
1
Pipeline
1
Availability Group
1
S3
1
Mixed workload
1
Unlimited Storage Database

879
Performance
536
Super fast
511
Ease of use
441
In-memory cache
321
Advanced key-value cache
190
Open source
179
Easy to deploy
163
Stable
152
Free
120
Fast
40
High-Performance
39
High Availability
34
Data Structures
32
Very Scalable
23
Replication
20
Great community
19
Pub/Sub
17
"NoSQL" key-value data store
14
Hashes
12
Sets
10
Sorted Sets
9
Lists
8
BSD licensed
8
NoSQL
7
Async replication
7
Integrates super easy with Sidekiq for Rails background
7
Bitmaps
6
Open Source
6
Keys with a limited time-to-live
5
Strings
5
Lua scripting
4
Awesomeness for Free!
4
Hyperloglogs
3
outstanding performance
3
Runs server side LUA
3
Networked
3
LRU eviction of keys
3
Written in ANSI C
3
Feature Rich
3
Transactions
2
Data structure server
2
Performance & ease of use
1
Existing Laravel Integration
1
Automatic failover
1
Easy to use
1
Object [key/value] size each 500 MB
1
Simple
1
Channels concept
1
Scalable
1
Temporarily kept on disk
1
Dont save data if no subscribers are found
0
Jk

Sign up to add or upvote prosMake informed product decisions

Cons of MemSQL

Cons of Redis

Be the first to leave a con

14
Cannot query objects directly
2
No secondary indexes for non-numeric data types
1
No WAL

Sign up to add or upvote consMake informed product decisions

What is MemSQL?

MemSQL converges transactions and analytics for sub-second data processing and reporting. Real-time businesses can build robust applications on a simple and scalable infrastructure that complements and extends existing data pipelines.

What is Redis?

Redis is an open source (BSD licensed), in-memory data structure store, used as a database, cache, and message broker. Redis provides data structures such as strings, hashes, lists, sets, sorted sets with range queries, bitmaps, hyperloglogs, geospatial indexes, and streams.

Need advice about which tool to choose?Ask the StackShare community!

Jobs that mention MemSQL and Redis as a desired skillset

Software Engineer, Ads Bidding and Pacing

Palo Alto, CA, US; San Francisco, CA, US

View Job Details

+10

Machine Learning Engineering Manager, Ads Retrieval

San Francisco, CA, US; Palo Alto, CA, US

View Job Details

+10

Machine Learning Engineering Manager, Ads Relevance

San Francisco, CA, US; Palo Alto, CA, US

View Job Details

+10

Machine Learning Engineering Manager, Ads Engagement Modeling

San Francisco, CA, US; Palo Alto, CA, US

View Job Details

+10

Machine Learning Engineer, Ads Targeting

San Francisco, CA, US; Palo Alto, CA, US; Seattle, WA, US;

View Job Details

+10

Machine Learning Engineer, Ads Retrieval

Palo Alto, CA, US; San Francisco, CA, US

View Job Details

+10

Machine Learning Engineer, Ads Relevance

Palo Alto, CA, US; San Francisco, CA, US

View Job Details

+10

Machine Learning Engineer, Ads Measurement Modeling

Seattle, WA, US

View Job Details

+10

See jobs for MemSQL

See jobs for Redis

What companies use MemSQL?

What companies use Redis?

See which teams inside your own company are using MemSQL or Redis.

Sign up to get full access to all the companiesMake informed product decisions

What tools integrate with MemSQL?

What tools integrate with Redis?

Sign up to get full access to all the tool integrationsMake informed product decisions

Blog Posts

Open Sourcing Querybook, Pinterest’s Collaborative Big Data Hu...

Jun 23 2021 at 5:13PM

+17

6777

How CloudSponge Protects Trillions Of Email Addresses From Hac...

Dec 13 2019 at 7:17PM

CloudSponge

815

Rust at OneSignal

Nov 20 2019 at 3:38AM

OneSignal

4111

How Sqreen handles 50,000 requests every minute in a write-hea...

Sep 17 2019 at 9:38PM

Sqreen

+17

6358

Kafka and Ruby, a Sidekiq Love Story

Jun 6 2019 at 5:11PM

AppSignal

1246

How Raygun Solves Performance Issues at 100M API Calls Per Hou...

Mar 28 2019 at 2:12PM

Raygun

+12

4027

Redux: Scaling LaunchDarkly From 4 to 200 Billion Feature Flag...

Mar 12 2019 at 3:11PM

LaunchDarkly

+23

5965

E-Commerce at Scale: Inside Shopify's Tech Stack

Jul 3 2018 at 4:40AM

Shopify

+17

32111

What are some alternatives to MemSQL and Redis?

VoltDB

VoltDB is a fundamental redesign of the RDBMS that provides unparalleled performance and scalability on bare-metal, virtualized and cloud infrastructures. VoltDB is a modern in-memory architecture that supports both SQL + Java with data durability and fault tolerance.

MongoDB

MongoDB stores data in JSON-like documents that can vary in structure, offering a dynamic, flexible schema. MongoDB was also designed for high availability and scalability, with built-in replication and auto-sharding.

Cassandra

Partitioning means that Cassandra can distribute your data across multiple machines in an application-transparent matter. Cassandra will automatically repartition as machines are added and removed from the cluster. Row store means that like relational databases, Cassandra organizes data by rows and columns. The Cassandra Query Language (CQL) is a close relative of SQL.

MySQL

The MySQL software delivers a very fast, multi-threaded, multi-user, and robust SQL (Structured Query Language) database server. MySQL Server is intended for mission-critical, heavy-load production systems as well as for embedding into mass-deployed software.

Apache Ignite

It is a memory-centric distributed database, caching, and processing platform for transactional, analytical, and streaming workloads delivering in-memory speeds at petabyte scale

See all alternatives

MemSQL vs Redis

Need advice about which tool to choose?Ask the StackShare community!

Pros of MemSQL

Pros of Redis

Sign up to add or upvote prosMake informed product decisions

Cons of MemSQL

Cons of Redis

Sign up to add or upvote consMake informed product decisions

What is MemSQL?

What is Redis?

Need advice about which tool to choose?Ask the StackShare community!

What companies use MemSQL?

What companies use Redis?

Sign up to get full access to all the companiesMake informed product decisions

What tools integrate with MemSQL?

What tools integrate with Redis?

Sign up to get full access to all the tool integrationsMake informed product decisions

Blog Posts

Related Comparisons

Trending Comparisons

Top Comparisons