Need advice about which tool to choose?Ask the StackShare community!
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.
Pros of MemSQL
- Distributed8
- Realtime4
- JSON3
- Sql3
- Columnstore3
- Concurrent3
- Ultra fast2
- Scalable2
- Pipeline1
- Availability Group1
- S31
- Mixed workload1
- Unlimited Storage Database1
Pros of Redis
- Performance879
- Super fast536
- Ease of use511
- In-memory cache441
- Advanced key-value cache321
- Open source190
- Easy to deploy179
- Stable163
- Free152
- Fast120
- High-Performance40
- High Availability39
- Data Structures34
- Very Scalable32
- Replication23
- Great community20
- Pub/Sub19
- "NoSQL" key-value data store17
- Hashes14
- Sets12
- Sorted Sets10
- Lists9
- BSD licensed8
- NoSQL8
- Async replication7
- Integrates super easy with Sidekiq for Rails background7
- Bitmaps7
- Open Source6
- Keys with a limited time-to-live6
- Strings5
- Lua scripting5
- Awesomeness for Free!4
- Hyperloglogs4
- outstanding performance3
- Runs server side LUA3
- Networked3
- LRU eviction of keys3
- Written in ANSI C3
- Feature Rich3
- Transactions3
- Data structure server2
- Performance & ease of use2
- Existing Laravel Integration1
- Automatic failover1
- Easy to use1
- Object [key/value] size each 500 MB1
- Simple1
- Channels concept1
- Scalable1
- Temporarily kept on disk1
- Dont save data if no subscribers are found1
- Jk0
Sign up to add or upvote prosMake informed product decisions
Cons of MemSQL
Cons of Redis
- Cannot query objects directly14
- No secondary indexes for non-numeric data types2
- No WAL1