DB-EnginesExtremeDB: the first and only COTS deterministic embedded database management system for mission- and safety-critical hard real-time applicationsEnglish
Deutsch
Knowledge Base of Relational and NoSQL Database Management Systemsprovided by solid IT

DBMS > mSQL vs. Redis vs. ScyllaDB

System Properties Comparison mSQL vs. Redis vs. ScyllaDB

Please select another system to include it in the comparison.

Editorial information provided by DB-Engines
NamemSQL infoMini SQL  Xexclude from comparisonRedis  Xexclude from comparisonScyllaDB  Xexclude from comparison
DescriptionmSQL (Mini SQL) is a simple and lightweight RDBMSPopular in-memory data platform used as a cache, message broker, and database that can be deployed on-premises, across clouds, and hybrid environments infoRedis focuses on performance so most of its design decisions prioritize high performance and very low latencies.Cassandra and DynamoDB compatible wide column store
Primary database modelRelational DBMSKey-value store infoMultiple data types and a rich set of operations, as well as configurable data expiration, eviction and persistenceKey-value store
Wide column store
Secondary database modelsDocument store infowith RedisJSON
Graph DBMS infowith RedisGraph
Spatial DBMS
Search engine infowith RediSearch
Time Series DBMS infowith RedisTimeSeries
DB-Engines Ranking infomeasures the popularity of database management systemsranking trend
Trend Chart
Score1.84
Rank#127  Overall
#62  Relational DBMS
Score177.98
Rank#6  Overall
#1  Key-value stores
Score3.91
Rank#85  Overall
#14  Key-value stores
#6  Wide column stores
Websitehughestech.com.au/­products/­msqlredis.com
redis.io
www.scylladb.com
Technical documentationdocs.redis.com/­latest/­index.html
redis.io/­documentation
docs.scylladb.com
Social network pagesFacebookLinkedInTwitterYouTubeDiscord
DeveloperHughes TechnologiesRedis project core team, inspired by Salvatore Sanfilippo infoDevelopment sponsored by Redis Inc.ScyllaDB
Initial release199420092015
Current release4.4, October 20216.2.6, October 2021Scylla Open Source 4.5, October 2021
License infoCommercial or Open Sourcecommercial infofree licenses can be providedOpen Source infosource-available extensions (modules), commercial licenses for Redis EnterpriseOpen Source infoOpen Source (AGPL), commercial license available
Cloud-based only infoOnly available as a cloud servicenonono
DBaaS offerings (sponsored links) infoDatabase as a Service

Providers of DBaaS offerings, please contact us to be listed.
  • ScaleGrid for Redis: Fully managed hosting for Redis on AWS, Azure and DigitalOcean with high availability and SSH access on the #1 multi-cloud DBaaS.
  • Redis Enterprise Cloud: Instantly scale and pay only for the resources you need - on any cloud - AWS, Azure or Google Cloud.
Scylla Cloud: Create real-time applications that run at global scale with Scylla Cloud, the industry’s most powerful NoSQL DBaaS
Implementation languageCCC++
Server operating systemsAIX
HP-UX
Linux
OS X
Solaris SPARC/x86
Windows
BSD
Linux
OS X
Windows infoported and maintained by Microsoft Open Technologies, Inc.
Linux
Data schemeyesschema-freeschema-free
Typing infopredefined data types such as float or dateyespartial infoSupported data types are strings, hashes, lists, sets and sorted sets, bit arrays, hyperloglogs and geospatial indexesyes
XML support infoSome form of processing data in XML format, e.g. support for XML data structures, and/or support for XPath, XQuery or XSLT.nonono
Secondary indexesyesyes infowith RediSearch moduleyes infocluster global secondary indices
SQL infoSupport of SQLA subset of ANSI SQL is implemented infono subqueries, aggregate functions, views, foreign keys, triggersnoSQL-like DML and DDL statements (CQL)
APIs and other access methodsJDBC
ODBC
proprietary protocol infoRESP - REdis Serialization ProtocolProprietary protocol (CQL) infocompatible with CQL (Cassandra Query Language, an SQL-like language)
RESTful HTTP API (DynamoDB compatible)
Thrift
Supported programming languagesC
C++
Delphi
Java
Perl
PHP
Tcl
C
C#
C++
Clojure
Crystal
D
Dart
Elixir
Erlang
Fancy
Go
Haskell
Haxe
Java
JavaScript (Node.js)
Lisp
Lua
MatLab
Objective-C
OCaml
Pascal
Perl
PHP
Prolog
Pure Data
Python
R
Rebol
Ruby
Rust
Scala
Scheme
Smalltalk
Swift
Tcl
Visual Basic
For CQL interface: C#, C++, Clojure, Erlang, Go, Haskell, Java, JavaScript, Node.js, Perl, PHP, Python, Ruby, Rust, Scala
For DynamoDB interface: .Net, ColdFusion, Erlang, Groovy, Java, JavaScript, Perl, PHP, Python, Ruby
Server-side scripts infoStored proceduresnoLua; Redis Functions coming in Redis 7 (slides and Github)yes, Lua
Triggersnopublish/subscribe channels provide some trigger functionality; RedisGearsno
Partitioning methods infoMethods for storing different data on different nodesnoneSharding infoAutomatic hash-based sharding with support for hash-tags for manual shardingSharding
Replication methods infoMethods for redundantly storing data on multiple nodesnoneMulti-source replication infowith Redis Enterprise Pack
Source-replica replication infoChained replication is supported
selectable replication factor infoRepresentation of geographical distribution of servers is possible
MapReduce infoOffers an API for user-defined Map/Reduce methodsnothrough RedisGearsno
Consistency concepts infoMethods to ensure consistency in a distributed systemnoneEventual Consistency
Causal consistency can be enabled in Active-Active databases
Strong consistency with Redis Raft
Strong eventual consistency with Active-Active
Eventual Consistency
Tunable Consistency infocan be individually decided for each write operation
Foreign keys infoReferential integritynonono
Transaction concepts infoSupport to ensure data integrity after non-atomic manipulations of datanoAtomic execution of command blocks and scripts and optimistic lockingno infoAtomicity and isolation are supported for single operations
Concurrency infoSupport for concurrent manipulation of datanoyes infoData access is serialized by the serveryes
Durability infoSupport for making data persistentyesyes infoConfigurable mechanisms for persistency via snapshots and/or operations logsyes
In-memory capabilities infoIs there an option to define some or all structures to be held in-memory only.noyesyes infoin-memory tables
User concepts infoAccess controlnoAccess Control Lists (ACLs): redis.io/­topics/­acl
LDAP and Role-Based Access Control (RBAC) for Redis Enterprise
Mutual TLS authentication: redis.io/­topics/­encryption
Password-based authentication
Access rights for users can be defined per object
More information provided by the system vendor
mSQL infoMini SQLRedisScyllaDB
Specific characteristicsThe Redis real-time data platform builds upon the unmatched simplicity and speed...
» more
Scylla is a highly-available, highly-scalable, highly-performant NoSQL database....
» more
Competitive advantagesRedis Enterprise is a robust in-memory database platform built by the people who...
» more
Highly-performant (efficiently utilizes full resources of a node and network; millions...
» more
Typical application scenariosRedis Enterprise is used by large enterprise, startup, and government organizations...
» more
AdTech ( AdGear , AppMonet , Dstillery , FullContact , MediaMath , Numberly , SAS...
» more
Key customersVerizon, Vodafone, Atlassian, Trip Advisor, Jet.com, Nokia, Samsung, HTC, Docker,...
» more
Comcast, Grab, OlaCabs, Yahoo! Japan, IMVU, Adgear, Xandr, Zenly, Natura, Snapfish,...
» more
Market metricsMost launched Docker container per day according to Docker Hub (7.2M launches per...
» more
Licensing and pricing modelsRedis Enterprise Cloud lets users scale up and down instantly, and pay only for the...
» more
Scylla Open Source - free open source software (AGPL) Scylla Enterprise - subscription-based...
» more

We invite representatives of system vendors to contact us for updating and extending the system information,
and for displaying vendor-provided information such as key customers, competitive advantages and market metrics.

Related products and services
3rd partiesRead the Redis NoSQL benchmark report.
» more

CData: Connect to Big Data & NoSQL through standard Drivers.
» more

Redisson PRO: The ultra-fast Redis Java Client.
» more

We invite representatives of vendors of related products to contact us for presenting information about their offerings here.

More resources
mSQL infoMini SQLRedisScyllaDB
DB-Engines blog posts

PostgreSQL is the DBMS of the Year 2018
2 January 2019, Paul Andlinger, Matthias Gelbmann

MySQL, PostgreSQL and Redis are the winners of the March ranking
2 March 2016, Paul Andlinger

MongoDB is the DBMS of the year, defending the title from last year
7 January 2015, Paul Andlinger, Matthias Gelbmann

show all

Conferences and events

Scylla Summit 2022
Virtual Conference, 9-10 February 2022

Finished events

Critical Attributes for a High-Performance, Low-Latency Database
Webinar, Video Available, 28 October 2021 (finished)

Demystifying the Distributed Database Landscape
Webinar, Video Available, 2 December 2021 (finished)

Recent citations in the news

Confluent Releases New Features to Make Data Streaming Simple
19 January 2022, Database Trends and Applications

Redis Welcomes Proven Leaders to Board of Directors with Alexy and Dor Appointments
12 January 2022, Business Wire

Bank Replaces Hundreds of Spark Streaming Nodes with Kinetica
6 January 2022, Datanami

Open-Source Database Software Market to Witness Growth Acceleration During 2022-2029 – The Oxford Spokesman
24 January 2022, The Oxford Spokesman

Data 2022 outlook, part one: Will data clouds get easier? Will streaming get off its own island?
3 January 2022, ZDNet

provided by Google News

ScyllaDB Announces Scylla Enterprise 2021 NoSQL Database
20 May 2021, GlobeNewswire

ScyllaDB Announces NoSQL Database as a Service Now Available on Google Cloud
4 August 2021, GlobeNewswire

ScyllaDB Unveils 'Monstrous' New Capabilities for Its NoSQL
12 January 2021, GlobeNewswire

ScyllaDB Announces Comprehensive Support for Apache Kafka
16 June 2021, GlobeNewswire

ScyllaDB Appoints SaaS Strategy Executive Wayne Ariola as Chief Marketing Officer
11 August 2021, GlobeNewswire

provided by Google News

Job opportunities

Financial Systems Analytics Specialist
Intel, Hillsboro, OR

Java Programmer/Developer
Intone Networks, Philadelphia, PA

Sr. Software Developer
Medical Guardian, Philadelphia, PA

Senior Database Engineer - NoSQL (Redis)
MasterCard, O'Fallon, MO

Cloud Support Engineer I - Databases
Amazon Web Services, Inc., Remote

Database Administrator
Intel, Santa Clara, CA

Database Administrator
ARK Solutions, Lansing, MI

Database Administration Professional
Fiserv, Inc., Short Hills, NJ

Back-End Engineer
Tagup, Inc., Boston, MA

Systems Engineer / DevOps
Hive, San Francisco, CA

Data Architect
JPMorgan Chase Bank, N.A., Jersey City, NJ

Senior Storage Engineer- Persistence Infrastructure
Discord, San Francisco, CA

Senior Infrastructure Engineer (Remote CA, NY, TX)
OneSignal, San Mateo, CA

jobs by Indeed



Share this page

Featured Products

Neo4j logo

See for yourself how a graph database can make your life easier.
Use Neo4j online for free.

Datastax Astra logo

Build cloud-native apps fast with Astra, the open-source, multi-cloud stack for
modern data apps.
Get started with 80GB free.

Couchbase logo

The modern database for enterprise applications. Build fast. Scale Big. Save more.
Get started today.

Vertica logo

Vertica Accelerator. The fastest analytics and machine learning, delivered as SaaS, with automated setup, administration, and management. Free trial.

MariaDB logo

SkySQL, the ultimate
MariaDB cloud, is here.

Get started with SkySQL today!

Present your product here