DB-EngineseXtremeDB: Active Replication Fabric for Reliable IoT Database ManagementEnglish
Deutsch
Knowledge Base of Relational and NoSQL Database Management Systemsprovided by solid IT

DBMS > MySQL vs. Vertica vs. VoltDB

System Properties Comparison MySQL vs. Vertica vs. VoltDB

Please select another system to include it in the comparison.

Editorial information provided by DB-Engines
NameMySQL  Xexclude from comparisonVertica infoVertica Analytics Platform  Xexclude from comparisonVoltDB  Xexclude from comparison
DescriptionWidely used open source RDBMSColumnar relational DBMS designed to handle modern analytic workloads, enabling fast query performanceDistributed In-Memory NewSQL RDBMS infoUsed for OLTP applications with a high frequency of relatively simple transactions, that can hold all their data in memory
Primary database modelRelational DBMS infoKey/Value like access via memcached APIRelational DBMSRelational DBMS
Secondary database modelsDocument storeDocument store
DB-Engines Ranking infomeasures the popularity of database management systemsranking trend
Trend Chart
Score1264.25
Rank#2  Overall
#2  Relational DBMS
Score21.77
Rank#31  Overall
#18  Relational DBMS
Score1.83
Rank#130  Overall
#64  Relational DBMS
Websitewww.mysql.comwww.vertica.comwww.voltdb.com
Technical documentationdev.mysql.com/­docwww.vertica.com/­docs/­10.0.x/­HTML/­Content/­Home.htmdocs.voltdb.com
DeveloperOracle infosince 2010, originally MySQL AB, then SunVertica / Micro Focus infoprior to that Hewlett PackardVoltDB Inc.
Initial release199520052010
Current release8.0.21, 2020Vertica 10.0 Software, May 2020
Vertica for SQL on Hadoop 10.0 Software, May 2020
9.0, April 2019
License infoCommercial or Open SourceOpen Source infoGPL version 2. Commercial licenses with extended functionallity are availablecommercial infoLimited community edition freeOpen Source infoAGPL for Community Edition, commercial license for Enterprise, AWS, and Pro Editions
Cloud-based only infoOnly available as a cloud servicenono infoAvailable on all major clouds - Amazon AWS, Microsoft Azure and Google Cloud Platformno
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.
  • Azure Database for MySQL: A fully managed, scalable MySQL relational database with high availability and security built in at no extra cost
Implementation languageC and C++Java, C++
Server operating systemsFreeBSD
Linux
OS X
Solaris
Windows
LinuxLinux
OS X infofor development
Data schemeyesyes infoUnstructured data can be stored in specific Flex-Tablesyes
Typing infopredefined data types such as float or dateyesyesyes
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.yesyes
Secondary indexesyesno infoThe concept of 'projections' can be used instead of indexes.yes
SQL infoSupport of SQLyes infowith proprietary extensionsyes infonearly full SQL99 without support for indexes and triggersyes infoonly a subset of SQL 99
APIs and other access methodsADO.NET
JDBC
ODBC
Proprietary native API
ADO.NET
JDBC
Kafka
ODBC
Proprietary protocol
RESTful HTTP API
Java API
JDBC
RESTful HTTP/JSON API
Supported programming languagesAda
C
C#
C++
D
Delphi
Eiffel
Erlang
Haskell
Java
JavaScript (Node.js)
Objective-C
OCaml
Perl
PHP
Python
Ruby
Scheme
Tcl
C++
Java
Perl
Python
R
C#
C++
Erlang infonot officially supported
Go
Java
JavaScript infoNode.js
PHP
Python
Server-side scripts infoStored proceduresyes infoproprietary syntaxyesJava
Triggersyesnono
Partitioning methods infoMethods for storing different data on different nodeshorizontal partitioning, sharding with MySQL Cluster or MySQL FabricSharding infoSegmentation, Projection Segmentation, Hash SegmentationSharding
Replication methods infoMethods for redundantly storing data on multiple nodesMulti-source replication
Source-replica replication
Multi-source replication infoCluster level and Object level replicationMulti-source replication
Source-replica replication
MapReduce infoOffers an API for user-defined Map/Reduce methodsnoyes infowith Vertica Connector for Hadoopno
Consistency concepts infoMethods to ensure consistency in a distributed systemImmediate ConsistencyImmediate Consistency
Foreign keys infoReferential integrityyes infonot for MyISAM storage engineyesno infoFOREIGN KEY constraints are not supported
Transaction concepts infoSupport to ensure data integrity after non-atomic manipulations of dataACID infonot for MyISAM storage engineACIDACID infoTransactions are executed single-threaded within stored procedures
Concurrency infoSupport for concurrent manipulation of datayes infotable locks or row locks depending on storage engineyesyes infoData access is serialized by the server
Durability infoSupport for making data persistentyesyesyes infoSnapshots and command logging
In-memory capabilities infoIs there an option to define some or all structures to be held in-memory only.yes
User concepts infoAccess controlUsers with fine-grained authorization concept infono user groups or rolesfine grained access rights according to SQL-standard; supports Kerberos, LDAP, Ident and hashUsers and roles with access to stored procedures
More information provided by the system vendor
MySQLVertica infoVertica Analytics PlatformVoltDB
Specific characteristicsColumnar storage, MPP, Hybrid storage model, Aggressive data compression, High availability,...
» more
Competitive advantagesPerformance at exabyte scale, Deploy anywhere, Open source innovation, Analysis in...
» more
Typical application scenariosCommunication and network analytics, Embedded analytics, Fraud monitoring and Risk...
» more
Key customersAbiba Systems, Adform, adMarketplace, AmeriPride, Anritsu, AOL, Avito, Auckland Transport,...
» more
Licensing and pricing modelsCost-based models and subscription-based models are available
» 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 partiesAzure Database for MySQL provides fully managed, enterprise-ready community MySQL database as a service
» more

General SQL Parser: Instantly adding parsing, decoding, analysis and rewrite SQL processing capability to your products.
» more

CData: Connect to Big Data & NoSQL through standard Drivers.
» 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

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

More resources
MySQLVertica infoVertica Analytics PlatformVoltDB
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

Oracle Introduces the MySQL Database Service on Its Cloud Infrastructure
10 September 2020, InfoQ.com

Google Cloud SQL Supports MySQL 8.0
9 September 2020, InfoQ.com

Hasura raises $25 million Series B and adds MySQL support to its GraphQL service
8 September 2020, TechCrunch

Hasura Introduces GraphQL Support for MySQL and SQL Server
15 September 2020, Database Trends and Applications

Hasura raises USD25 million Series B and adds MySQL support to its GraphQL service
9 September 2020, United News of India

provided by Google News

Ahana Expands Seed Funding to $4.8 Million with Additional Funding Led by Lux Capital
21 September 2020, GlobeNewswire

Database Management Software: Market 2020 | Coronavirus Impact | Industry Business Outlook, Revenue, Trends and Forecasts 2026 | Actian Corporation, iWay Software, Embarcadero Technologies, MetaMatrix, HP (Vertica System), CA Technologies
21 September 2020, The Daily Chronicle

Alibaba adds leading analytics and banking software to its public cloud
17 September 2020, Which-50

Snowflake to Make it SNOW on NYSE
25 August 2020, Datanami

Complicated and competitive: How Vertica navigates today's intricate world of database management
21 April 2020, SiliconANGLE

provided by Google News

Tag: Database Management Systems (Dbms) market in Asia
21 September 2020, Verdant News

Global NEWSQL Database Market Expeted To Reach xx.xx mn USD With growth Rate of xx by 2025| Pandamic Impact Analysis: Microsoft Corporation, IBM, Oracle, SAP, Amazon, Pivotal, Altibase, MemSQL, TIBCO, VoltDB, Google, Cockroach Labs, MariaDB, ScaleArc (Ignite Technologies)
21 September 2020, Verdant News

Leveraging 5G latency reduction requires decentralized compute
4 September 2020, RCR Wireless News

VoltDB Secures $10 Million in Series C Funding to Meet Demand for 5G Data Requirements
23 October 2019, PRNewswire

Dream11 Selects VoltDB to Power 75 Million Users on its Platform
3 March 2020, MarTech Series

provided by Google News

Job opportunities

Regional Loss Prevention Manager, Retail
Amazon.com Services LLC, Washington, DC

Database Administrator
Crowned Grace International, Washington, DC

Linux System Administrator-2nd Shift( 3:00PM-11:30PM)
Dovel Technologies, LLC, College Park, MD

Web Developer (0320)
SW FL Water Management District, Brooksville, FL

LMS Administrator
Saylor Academy, Washington, DC

Vertica Database Administrator
MassMutual, Boston, MA

Vertica Customer Solutions Manager
Micro Focus, Georgia

Data Analyst
Omni Federal, Fairfax, VA

DevOps Intern Summer 2021 - Vertica
Micro Focus, Cambridge, MA

Client Success Manager at Vertica
Micro Focus, Cambridge, MA

Software Engineer
Moebius Solutions, San Diego, CA

jobs by Indeed




Share this page

Featured Products

Datastax Astra logo

Cassandra made easy in the cloud. Build cloud-native applications faster with CQL, REST and GraphQL APIs.
Try for Free.

AllegroGraph logo

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

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.

Couchbase logo

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

Present your product here