DB-EnginesInfluxDB download bannerEnglish
Deutsch
Knowledge Base of Relational and NoSQL Database Management Systemsprovided by solid IT

DBMS > MySQL vs. SingleStore

System Properties Comparison MySQL vs. SingleStore

Please select another system to include it in the comparison.

Our visitors often compare MySQL and SingleStore with Snowflake, Redis and MongoDB.

Editorial information provided by DB-Engines
NameMySQL  Xexclude from comparisonSingleStore infoformer name was MemSQL  Xexclude from comparison
DescriptionWidely used open source RDBMSMySQL wire-compliant distributed RDBMS that combines an in-memory row-oriented and a disc-based column-oriented storage
Primary database modelRelational DBMS infoKey/Value like access via memcached APIRelational DBMS
Secondary database modelsDocument storeDocument store
DB-Engines Ranking infomeasures the popularity of database management systemsranking trend
Trend Chart
Score1252.06
Rank#2  Overall
#2  Relational DBMS
Score5.51
Rank#65  Overall
#37  Relational DBMS
Websitewww.mysql.comwww.singlestore.com
Technical documentationdev.mysql.com/­docdocs.singlestore.com
DeveloperOracle infosince 2010, originally MySQL AB, then SunSingleStore Inc.
Initial release19952013
Current release5.7.32 , October 20207.1.11, October 2020
License infoCommercial or Open SourceOpen Source infoGPL version 2. Commercial licenses with extended functionallity are availablecommercial infofree developer edition available
Cloud-based only infoOnly available as a cloud servicenono
DBaaS offerings (sponsored links) infoDatabase as a Service

Providers of DBaaS offerings, please contact us to be listed.
ScaleGrid for MySQL: Fully managed MySQL hosting on AWS, Azure and DigitalOcean with high availability and SSH access on the #1 multi-cloud DBaaS.SingleStore Managed Service: The world's fastest, most capable cloud database for operational analytics, machine learning, & AI. Available instantly with multi-cloud and hybrid-cloud capabilities.
Implementation languageC and C++C++
Server operating systemsFreeBSD
Linux
OS X
Solaris
Windows
Linux info64 bit version required
Data schemeyesyes
Typing infopredefined data types such as float or dateyesyes
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.yesno
Secondary indexesyesyes
SQL infoSupport of SQLyes infowith proprietary extensionsyes, but no triggers and foreign keys
APIs and other access methodsADO.NET
JDBC
ODBC
Proprietary native API
JDBC
ODBC
Supported programming languagesAda
C
C#
C++
D
Delphi
Eiffel
Erlang
Haskell
Java
JavaScript (Node.js)
Objective-C
OCaml
Perl
PHP
Python
Ruby
Scheme
Tcl
Bash
C
C#
Java
JavaScript (Node.js)
Python
Server-side scripts infoStored proceduresyes infoproprietary syntaxyes
Triggersyesno
Partitioning methods infoMethods for storing different data on different nodeshorizontal partitioning, sharding with MySQL Cluster or MySQL FabricSharding
Replication methods infoMethods for redundantly storing data on multiple nodesMulti-source replication
Source-replica replication
Source-replica replication
MapReduce infoOffers an API for user-defined Map/Reduce methodsnono
Consistency concepts infoMethods to ensure consistency in a distributed systemImmediate ConsistencyImmediate Consistency only within each node
Foreign keys infoReferential integrityyes infonot for MyISAM storage engineno
Transaction concepts infoSupport to ensure data integrity after non-atomic manipulations of dataACID infonot for MyISAM storage engineACID infoOnly isolation level: READ COMMITED
Concurrency infoSupport for concurrent manipulation of datayes infotable locks or row locks depending on storage engineyes, multi-version concurrency control (MVCC)
Durability infoSupport for making data persistentyesyes
In-memory capabilities infoIs there an option to define some or all structures to be held in-memory only.yesyes
User concepts infoAccess controlUsers with fine-grained authorization concept infono user groups or rolesfine grained access rights according to SQL-standard

More information provided by the system vendor

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 partiesGeneral SQL Parser: Instantly adding parsing, decoding, analysis and rewrite SQL processing capability to your products.
» more

Navicat for MySQL is the ideal solution for MySQL/MariaDB administration and development.
» more

Datadog: Improve MySQL performance by visualizing and identifying errors fast using granular, out-of-the-box dashboards.
» more

ClusterControl: the only management system you’ll ever need to take control of your open source database infrastructure.
» more

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

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

More resources
MySQLSingleStore infoformer name was MemSQL
DB-Engines blog posts

MySQL is the DBMS of the Year 2019
3 January 2020, Matthias Gelbmann, Paul Andlinger

MariaDB strengthens its position in the open source RDBMS market
5 April 2018, Matthias Gelbmann

The struggle for the hegemony in Oracle's database empire
2 May 2017, Paul Andlinger

show all

Recent citations in the news

Dive Into Database Management With This Discounted MySQL Course
14 January 2021, PCMag.com

Oracle: shift back to red on MySQL Analytics Engine
11 January 2021, ComputerWeekly.com

Top SQL Interview Questions For Data Scientists
20 January 2021, Analytics India Magazine

How to Deploy a Java Springboot App with MYSQL in AWS for Free
25 December 2020, hackernoon.com

How to Download and Install MySQL in Windows 10
10 January 2021, TWCN Tech News

provided by Google News

CRG Solutions Cloud-Native Database Named SingleStore VAR
13 January 2021, insideHPC

SingleStore to Provide Support for AWS Glue
6 January 2021, Database Trends and Applications

Experts Discuss What Capabilities are Needed to Succeed with Real-Time Analytics
14 January 2021, Database Trends and Applications

CRG Solutions selected as SingleStore's value-added reseller partner
14 January 2021, IBS Intelligence

SingleStore raises $80 million to accelerate data analytics with relational databases
8 December 2020, VentureBeat

provided by Google News

Job opportunities

Loss Prevention Specialist
Amazon.com Services LLC, Thornton, CO

Technical Support Representative
GoDaddy, Gilbert, AZ

MySQL Database Administrator
Updox, Remote

GIS Coordinator
Truckee Donner Public Utilities District, Truckee, CA

Jr. QA Analyst Trainee
SQA², Los Alamitos, CA

Software Engineer, University Graduate
SingleStore, San Francisco, CA

Data Platform Architect - Remote
Johnson Controls, Milwaukee, WI

Software Engineer, Intern (Summer 2021)
SingleStore, San Francisco, CA

Support Engineer, Weekend Shift
SingleStore, Oregon

Database Performance Engineer
SingleStore, California

jobs by Indeed




Share this page

Featured Products

Datastax Astra logo

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

MariaDB logo

SkySQL, the ultimate
MariaDB cloud, is here.

Get started with SkySQL today!

Neo4j logo

Get your free copy of the new O'Reilly book Graph Algorithms with 20+ examples for
machine learning, graph analytics and more.

AllegroGraph logo

Graph Database Leader for AI Knowledge Graph Applications - The Most Secure Graph Database Available.
Free Download

Couchbase logo

SQL + JSON + NoSQL.
Power, flexibility & scale.
All open source.
Get started now.

Present your product here