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