DBMS > H2 vs. InfluxDB vs. MySQL
System Properties Comparison H2 vs. InfluxDB vs. MySQL
Please select another system to include it in the comparison.
|Editorial information provided by DB-Engines|
|Name||H2 Xexclude from comparison||InfluxDB Xexclude from comparison||MySQL Xexclude from comparison|
|Description||Full-featured RDBMS with a small footprint, either embedded into a Java application or used as a database server.||DBMS for storing time series, events and metrics||Widely used open source RDBMS|
|Primary database model||Relational DBMS||Time Series DBMS||Relational DBMS Key/Value like access via memcached API|
|Secondary database models||Spatial DBMS||Spatial DBMS with GEO package||Document store|
|Developer||Thomas Mueller||Oracle since 2010, originally MySQL AB, then Sun|
|Current release||2.1.210, January 2022||2.0.8, August 2021||8.0.29, April 2022|
|License Commercial or Open Source||Open Source dual-licence (Mozilla public license, Eclipse public license)||Open Source MIT-License; commercial enterprise version available||Open Source GPL version 2. Commercial licenses with extended functionallity are available|
|Cloud-based only Only available as a cloud service||no||no||no|
|DBaaS offerings (sponsored links) Database 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.|
|Implementation language||Java||Go||C and C++|
|Server operating systems||All OS with a Java VM||Linux|
OS X through Homebrew
|Typing predefined data types such as float or date||yes||Numeric data and Strings||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.||no||no||yes|
|SQL Support of SQL||yes||SQL-like query language||yes with proprietary extensions|
|APIs and other access methods||JDBC|
JSON over UDP
Proprietary native API
|Supported programming languages||Java||.Net|
|Server-side scripts Stored procedures||Java Stored Procedures and User-Defined Functions||no||yes proprietary syntax|
|Partitioning methods Methods for storing different data on different nodes||none||Sharding in enterprise version only||horizontal partitioning, sharding with MySQL Cluster or MySQL Fabric|
|Replication methods Methods for redundantly storing data on multiple nodes||With clustering: 2 database servers on different computers operate on identical copies of a database||selectable replication factor in enterprise version only||Multi-source replication|
|MapReduce Offers an API for user-defined Map/Reduce methods||no||no||no|
|Consistency concepts Methods to ensure consistency in a distributed system||Immediate Consistency||Immediate Consistency|
|Foreign keys Referential integrity||yes||no||yes not for MyISAM storage engine|
|Transaction concepts Support to ensure data integrity after non-atomic manipulations of data||ACID||no||ACID not for MyISAM storage engine|
|Concurrency Support for concurrent manipulation of data||yes, multi-version concurrency control (MVCC)||yes||yes table locks or row locks depending on storage engine|
|Durability Support for making data persistent||yes||yes||yes|
|In-memory capabilities Is there an option to define some or all structures to be held in-memory only.||yes||yes Depending on used storage engine||yes|
|User concepts Access control||fine grained access rights according to SQL-standard||simple rights management via user accounts||Users with fine-grained authorization concept no user groups or roles|
|More information provided by the system vendor|
|Specific characteristics||InfluxData is the creator of InfluxDB , the open source time series database. It...|
|Competitive advantages||Time to Value InfluxDB is available in all the popular languages and frameworks,...|
|Typical application scenarios||IoT & Sensor Monitoring Developers are witnessing the instrumentation of every available...|
|Key customers||InfluxData has more than 1,300 paying customers, including customers include MuleSoft,...|
|Market metrics||Fastest growing database to drive 23,500 GitHub stars Over 600,000 daily active instances|
|Licensing and pricing models||Open source core with closed source clustering available either on-premise or on...|
We invite representatives of system vendors to contact us for updating and extending the system information,
|Related products and services|
|3rd parties||Navicat for MySQL is the ideal solution for MySQL/MariaDB administration and development.|
CData: Connect to Big Data & NoSQL through standard Drivers.
DbVisualizer is equipping database professionals with the tools they need to build, manage and maintain state-of-the-art database technologies. It has sky-high user satisfaction and is the preferred tool for database professionals around the world. Customers include Tesla, Apple, Facebook, Deutsche Bank, NASA, and 25,000 others in 145 countries.
Arctype: A fast, beautiful database GUI for developers and teams. Download it for free today.
SQLFlow: Provides a visual representation of the overall flow of data. Automated SQL data lineage analysis across Databases, ETL, Business Intelligence, Cloud and Hadoop environments by parsing SQL Script and stored procedure.
Percona: Database problems? Not on your watch.
Databases run better with Percona.
We invite representatives of vendors of related products to contact us for presenting information about their offerings here.
|DB-Engines blog posts|