DBMS > MySQL vs. VoltDB
System Properties Comparison MySQL vs. VoltDB
Please select another system to include it in the comparison.
|Editorial information provided by DB-Engines|
|Name||MySQL Xexclude from comparison||VoltDB Xexclude from comparison|
|Description||Widely used open source RDBMS||Distributed In-Memory NewSQL RDBMS Used for OLTP applications with a high frequency of relatively simple transactions, that can hold all their data in memory|
|Primary database model||Relational DBMS Key/Value like access via memcached API||Relational DBMS|
|Secondary database models||Document store|
|Developer||Oracle since 2010, originally MySQL AB, then Sun||VoltDB Inc.|
|Current release||8.0.17, July 2019||9.0, April 2019|
|License Commercial or Open Source||Open Source GPL version 2. Commercial licenses with extended functionallity are available||Open Source AGPL for Community Edition, commercial license for Enterprise, AWS, and Pro Editions|
|Cloud-based only Only available as a cloud service||no||no|
|DBaaS offerings (sponsored links) Database as a Service|
Providers of DBaaS offerings, please contact us to be listed.
|Implementation language||C and C++||Java, C++|
|Server operating systems||FreeBSD|
OS X for development
|Typing predefined data types such as float or date||yes||yes|
|XML support Some form of processing data in XML format, e.g. support for XML data structures, and/or support for XPath, XQuery or XSLT.||yes|
|SQL Support of SQL||yes with proprietary extensions||yes only a subset of SQL 99|
|APIs and other access methods||Proprietary native API|
RESTful HTTP/JSON API
|Supported programming languages||Ada|
Erlang not officially supported
|Server-side scripts Stored procedures||yes proprietary syntax||Java|
|Partitioning methods Methods for storing different data on different nodes||horizontal partitioning, sharding with MySQL Cluster or MySQL Fabric||Sharding|
|Replication methods Methods for redundantly storing data on multiple nodes||Master-master replication|
|MapReduce Offers an API for user-defined Map/Reduce methods||no||no|
|Consistency concepts Methods to ensure consistency in a distributed system||Immediate Consistency|
|Foreign keys Referential integrity||yes not for MyISAM storage engine||no FOREIGN KEY constraints are not supported|
|Transaction concepts Support to ensure data integrity after non-atomic manipulations of data||ACID not for MyISAM storage engine||ACID Transactions are executed single-threaded within stored procedures|
|Concurrency Support for concurrent manipulation of data||yes table locks or row locks depending on storage engine||yes Data access is serialized by the server|
|Durability Support for making data persistent||yes||yes Snapshots and command logging|
|In-memory capabilities Is there an option to define some or all structures to be held in-memory only.||yes|
|User concepts Access control||Users with fine-grained authorization concept no user groups or roles||Users and roles with access to stored procedures|
More information provided by the system vendor
We invite representatives of system vendors to contact us for updating and extending the system information,
|Related products and services|
|3rd parties||SQLPro for MySQL: A simple but powerful MySQL database client available on iPhone and iPad as well as macOS.|
CData: Connect to Big Data & NoSQL through standard Drivers.
Navicat for MySQL is the ideal solution for MySQL/MariaDB administration and development.
Dremio is like magic for MySQL accelerating your analytical queries up to 1,000x.
ScaleGrid: Fully managed MySQL-as-a-Service.
General SQL Parser: Instantly adding parsing, decoding, analysis and rewrite SQL processing capability to your products.
Azure Database for MySQL provides fully managed, enterprise-ready community MySQL database as a service
We invite representatives of vendors of related products to contact us for presenting information about their offerings here.
|DB-Engines blog posts|
MariaDB strengthens its position in the open source RDBMS market The struggle for the hegemony in Oracle's database empire
The struggle for the hegemony in Oracle's database empire
|Recent citations in the news|
DigitalOcean launches managed MySQL and Redis database services
How to create a MySQL relational database in AWS
After PostgreSQL, DigitalOcean now adds MySQL and Redis to its managed databases’ offering
SiteLock Extends Database Security Reach to MySQL
provided by Google News
In-Memory Database Market 2018-2023 Reaching New Height By Top Leading Players: Microsoft, IBM, Oracle, SAP
NEWSQL Database Market Size, Status, Applications and Growth Forecast 2019 to 2025
VoltDB Introduces Smart Streaming Architecture for the Connected World
Global Database Management Systems (DBMS) Market Study 2019-2025: BMC Software, Oracle, IBM, CA Technologies, Couchbase Server
Global In-Memory Database Market to Register Substantial Expansion and Growth by 2024
provided by Google News
Database Administrator, MCS
SQL Database Administrator
Backend/Data Engineer II
Sr. Specialist Developer
Share this page