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

MemSQL

81
169
+ 1
32
Redis

53.2K
40.4K
+ 1
3.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 StackShare Enterprise. Sign up for StackShare Enterprise.
Learn More
Pros of MemSQL
Pros of Redis
  • 8
    Distributed
  • 4
    Realtime
  • 3
    JSON
  • 3
    Concurrent
  • 3
    Columnstore
  • 3
    Sql
  • 2
    Ultra fast
  • 2
    Scalable
  • 1
    Mixed workload
  • 1
    Pipeline
  • 1
    Unlimited Storage Database
  • 1
    Availability Group
  • 882
    Performance
  • 540
    Super fast
  • 510
    Ease of use
  • 441
    In-memory cache
  • 321
    Advanced key-value cache
  • 190
    Open source
  • 180
    Easy to deploy
  • 163
    Stable
  • 153
    Free
  • 120
    Fast
  • 40
    High-Performance
  • 39
    High Availability
  • 34
    Data Structures
  • 31
    Very Scalable
  • 23
    Replication
  • 21
    Great community
  • 21
    Pub/Sub
  • 17
    "NoSQL" key-value data store
  • 14
    Hashes
  • 12
    Sets
  • 10
    Sorted Sets
  • 9
    Lists
  • 8
    BSD licensed
  • 8
    NoSQL
  • 7
    Integrates super easy with Sidekiq for Rails background
  • 7
    Async replication
  • 7
    Bitmaps
  • 6
    Keys with a limited time-to-live
  • 6
    Open Source
  • 5
    Strings
  • 5
    Lua scripting
  • 4
    Hyperloglogs
  • 4
    Awesomeness for Free!
  • 3
    Transactions
  • 3
    Runs server side LUA
  • 3
    outstanding performance
  • 3
    Networked
  • 3
    LRU eviction of keys
  • 3
    Written in ANSI C
  • 3
    Feature Rich
  • 2
    Performance & ease of use
  • 2
    Data structure server
  • 1
    Simple
  • 1
    Channels concept
  • 1
    Scalable
  • 1
    Temporarily kept on disk
  • 1
    Dont save data if no subscribers are found
  • 1
    Automatic failover
  • 1
    Easy to use
  • 1
    Existing Laravel Integration
  • 1
    Object [key/value] size each 500 MB

Sign up to add or upvote prosMake informed product decisions

Cons of MemSQL
Cons of Redis
    Be the first to leave a con
    • 15
      Cannot query objects directly
    • 3
      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!

    What companies use MemSQL?
    What companies use Redis?
    See which teams inside your own company are using MemSQL or Redis.
    Sign up for StackShare EnterpriseLearn More

    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

    Nov 20 2019 at 3:38AM

    OneSignal

    PostgreSQLRedisRuby+8
    8
    4319
    Jun 6 2019 at 5:11PM

    AppSignal

    RedisRubyKafka+9
    15
    1287
    GitHubDockerReact+17
    35
    34075
    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