DB-EnginesInfluxDB: Focus on building software with an easy-to-use serverless, scalable time series platformEnglish
Deutsch
Knowledge Base of Relational and NoSQL Database Management Systemsprovided by solid IT

DBMS > InfluxDB vs. Microsoft SQL Server vs. MySQL vs. Tarantool vs. TerminusDB

System Properties Comparison InfluxDB vs. Microsoft SQL Server vs. MySQL vs. Tarantool vs. TerminusDB

Editorial information provided by DB-Engines
NameInfluxDB  Xexclude from comparisonMicrosoft SQL Server  Xexclude from comparisonMySQL  Xexclude from comparisonTarantool  Xexclude from comparisonTerminusDB infoformer name was DataChemist  Xexclude from comparison
DescriptionDBMS for storing time series, events and metricsMicrosofts flagship relational DBMSWidely used open source RDBMSIn-memory computing platform with a flexible data schema for efficiently building high-performance applicationsScalable Graph Database platform making enterprise data available by exploiting inferred entities and relationships
Primary database modelTime Series DBMSRelational DBMSRelational DBMS infoKey/Value like access via memcached APIDocument store
Key-value store
Relational DBMS
Graph DBMS
Secondary database modelsSpatial DBMS infowith GEO packageDocument store
Graph DBMS
Spatial DBMS
Document store
Spatial DBMS
Spatial DBMS infowith Tarantool/GIS extensionDocument store
RDF store
DB-Engines Ranking infomeasures the popularity of database management systemsranking trend
Trend Chart
Score24.39
Rank#28  Overall
#1  Time Series DBMS
Score821.56
Rank#3  Overall
#3  Relational DBMS
Score1061.34
Rank#2  Overall
#2  Relational DBMS
Score1.67
Rank#143  Overall
#25  Document stores
#25  Key-value stores
#65  Relational DBMS
Score0.23
Rank#316  Overall
#27  Graph DBMS
Websitewww.influxdata.com/­products/­influxdb-overviewwww.microsoft.com/­en-us/­sql-serverwww.mysql.comwww.tarantool.ioterminusdb.com
Technical documentationdocs.influxdata.com/­influxdblearn.microsoft.com/­en-US/­sql/­sql-serverdev.mysql.com/­docwww.tarantool.io/­en/­docterminusdb.github.io/­terminusdb/­#
DeveloperMicrosoftOracle infosince 2010, originally MySQL AB, then SunVKDataChemist Ltd.
Initial release20131989199520082018
Current release2.7.6, April 2024SQL Server 2022, November 20228.4.0, April 20242.10.0, May 202211.0.0, January 2023
License infoCommercial or Open SourceOpen Source infoMIT-License; commercial enterprise version availablecommercial inforestricted free version is availableOpen Source infoGPL version 2. Commercial licenses with extended functionallity are availableOpen Source infoBSD-2, source-available extensions (modules), commercial licenses for Tarantool EnterpriseOpen Source infoGPL V3
Cloud-based only infoOnly available as a cloud servicenonononono
DBaaS offerings (sponsored links) infoDatabase as a Service

Providers of DBaaS offerings, please contact us to be listed.
SQLServer Flex @ STACKIT offers a managed version of SQL Server with adjustable CPU, RAM, storage amount and speed, in enterprise grade to perfectly match all application requirements. All services are 100% GDPR-compliant.Aiven for MySQL: Fully managed MySQL, deployable in the cloud of your choice, with seamless integrations and lightning-fast setup.
Implementation languageGoC++C and C++C and C++Prolog, Rust
Server operating systemsLinux
OS X infothrough Homebrew
Linux
Windows
FreeBSD
Linux
OS X
Solaris
Windows
BSD
Linux
macOS
Linux
Data schemeschema-freeyesyesFlexible data schema: relational definition for tables with ability to store json-like documents in columnsyes
Typing infopredefined data types such as float or dateNumeric data and Stringsyesyesstring, double, decimal, uuid, integer, blob, boolean, datetimeyes
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.noyesyesnono
Secondary indexesnoyesyesyes
SQL infoSupport of SQLSQL-like query languageyesyes infowith proprietary extensionsFull-featured ANSI SQL supportSQL-like query language (WOQL)
APIs and other access methodsHTTP API
JSON over UDP
ADO.NET
JDBC
ODBC
OLE DB
Tabular Data Stream (TDS)
ADO.NET
JDBC
ODBC
Proprietary native API
Open binary protocolOWL
RESTful HTTP API
WOQL (Web Object Query Language)
Supported programming languages.Net
Clojure
Erlang
Go
Haskell
Java
JavaScript
JavaScript (Node.js)
Lisp
Perl
PHP
Python
R
Ruby
Rust
Scala
C#
C++
Delphi
Go
Java
JavaScript (Node.js)
PHP
Python
R
Ruby
Visual Basic
Ada
C
C#
C++
D
Delphi
Eiffel
Erlang
Haskell
Java
JavaScript (Node.js)
Objective-C
OCaml
Perl
PHP
Python
Ruby
Scheme
Tcl
C
C#
C++
Erlang
Go
Java
JavaScript
Lua
Perl
PHP
Python
Rust
JavaScript
Python
Server-side scripts infoStored proceduresnoTransact SQL, .NET languages, R, Python and (with SQL Server 2019) Javayes infoproprietary syntaxLua, C and SQL stored proceduresyes
Triggersnoyesyesyes, before/after data modification events, on replication events, client session eventsyes
Partitioning methods infoMethods for storing different data on different nodesSharding infoin enterprise version onlytables can be distributed across several files (horizontal partitioning); sharding through federationhorizontal partitioning, sharding with MySQL Cluster or MySQL FabricSharding, partitioned with virtual buckets by user defined affinity key. Live resharding for scale up and scale down without maintenance downtime.Graph Partitioning
Replication methods infoMethods for redundantly storing data on multiple nodesselectable replication factor infoin enterprise version onlyyes, but depending on the SQL-Server EditionMulti-source replication
Source-replica replication
Asynchronous replication with multi-master option
Configurable replication topology (full-mesh, chain, star)
Synchronous quorum replication (with Raft)
Journaling Streams
MapReduce infoOffers an API for user-defined Map/Reduce methodsnononono
Consistency concepts infoMethods to ensure consistency in a distributed systemImmediate ConsistencyImmediate ConsistencyCasual consistency across sharding partitions
Eventual consistency within replicaset partition infowhen using asyncronous replication
Immediate Consistency within single instance
Sequential consistency including linearizable read within replicaset partition infowhen using Raft
Foreign keys infoReferential integritynoyesyes infonot for MyISAM storage engineyesyes
Transaction concepts infoSupport to ensure data integrity after non-atomic manipulations of datanoACIDACID infonot for MyISAM storage engineACID, with serializable isolation and linearizable read (within partition); Configurable MVCC (within partition); No cross-shard distributed transactionsACID
Concurrency infoSupport for concurrent manipulation of datayesyesyes infotable locks or row locks depending on storage engineyes, cooperative multitaskingyes
Durability infoSupport for making data persistentyesyesyesyes, write ahead loggingyes infoin-memory journaling
In-memory capabilities infoIs there an option to define some or all structures to be held in-memory only.yes infoDepending on used storage engineyesyesyes, full featured in-memory storage engine with persistence
User concepts infoAccess controlsimple rights management via user accountsfine grained access rights according to SQL-standardUsers with fine-grained authorization concept infono user groups or rolesAccess Control Lists
Mutual TLS authentication for Tarantol Enterprise
Password based authentication
Role-based access control (RBAC) and LDAP for Tarantol Enterprise
Users and Roles
Role-based access control
More information provided by the system vendor
InfluxDBMicrosoft SQL ServerMySQLTarantoolTerminusDB infoformer name was DataChemist
Specific characteristicsInfluxData is the creator of InfluxDB , the open source time series database. It...
» more
Competitive advantagesTime to Value InfluxDB is available in all the popular languages and frameworks,...
» more
Typical application scenariosIoT & Sensor Monitoring Developers are witnessing the instrumentation of every available...
» more
Key customersInfluxData has more than 1,900 paying customers, including customers include MuleSoft,...
» more
Market metricsFastest-growing database to drive 27,500 GitHub stars Over 750,000 daily active instances
» more
Licensing and pricing modelsOpen source core with closed source clustering available either on-premise or on...
» more
News

Scaling Data Collection: Solving Renewable Energy Challenges with InfluxDB
6 June 2024

Deadman Alerts with Grafana and InfluxDB Cloud 3.0
5 June 2024

Chasing the Skies: Monitoring Flights with InfluxDB
4 June 2024

Monitoring Your Cloud Environments and Applications with InfluxDB
30 May 2024

Webinar Recap: Unleash the Full Potential of Your Time Series Data with InfluxDB and AWS
29 May 2024

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 partiesNavicat for SQL Server gives you a fully graphical approach to database management and development.
» more

Navicat Monitor is a safe, simple and agentless remote server monitoring tool for SQL Server and many other database management systems.
» more
Aiven for MySQL: Fully managed MySQL, deployable in the cloud of your choice, with seamless integrations and lightning-fast setup.
» 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

Navicat Monitor is a safe, simple and agentless remote server monitoring tool for MySQL and many other database management systems.
» more

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

More resources
InfluxDBMicrosoft SQL ServerMySQLTarantoolTerminusDB infoformer name was DataChemist
DB-Engines blog posts

Why Build a Time Series Data Platform?
20 July 2017, Paul Dix (guest author)

Time Series DBMS are the database category with the fastest increase in popularity
4 July 2016, Matthias Gelbmann

Time Series DBMS as a new trend?
1 June 2015, Paul Andlinger

show all

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

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

Microsoft SQL Server is the DBMS of the Year
4 January 2017, Matthias Gelbmann, Paul Andlinger

show all

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

Data processing speed and reliability: in-memory synchronous replication
9 November 2021,  Vladimir Perepelytsya, Tarantool (sponsor) 

show all

Recent citations in the news

Amazon Timestream for InfluxDB is now generally available
15 March 2024, AWS Blog

Apache Doris for Log and Time Series Data Analysis in NetEase: Why Not Elasticsearch and InfluxDB?
5 June 2024, hackernoon.com

Amazon Timestream: Managed InfluxDB for Time Series Data
14 March 2024, The New Stack

InfluxData Collaborating with AWS to Bring InfluxDB and Time Series Analytics to Developers Around the World
14 March 2024, Business Wire

How the FDAP Stack Gives InfluxDB 3.0 Real-Time Speed, Efficiency
15 March 2024, Datanami

provided by Google News

First Look: New Features in SQL Server 2016
7 June 2024, ITPro Today

A generative AI use case using Amazon RDS for SQL Server as a vector data store | Amazon Web Services
22 May 2024, AWS Blog

Mastering the SQL Server command-line interface
30 May 2024, SitePoint

SQL Server 2014 end of support: Keep your customers secure
28 March 2024, Microsoft

SQL Server vNext: When and What Is Coming
15 May 2024, redmondmag.com

provided by Google News

Amazon Aurora MySQL version 2 (with MySQL 5.7 compatibility) to version 3 (with MySQL 8.0 compatibility) upgrade ...
18 March 2024, AWS Blog

Enterprise Manager: How Comcast enhanced monitoring for MySQL InnoDB Clusters
22 April 2024, Oracle

Zendesk Moves from DynamoDB to MySQL and S3 to Save over 80% in Costs
29 December 2023, InfoQ.com

Ultimate MySQL Workbench Installation Guide [2024 Edition]
15 February 2024, Simplilearn

How to Create a MySQL 8 Database User With Remote Access
4 January 2024, TechRepublic

provided by Google News

Deploying Tarantool Cartridge applications with zero effort (Part 1)
16 December 2019, Хабр

VShard — horizontal scaling in Tarantool
7 March 2019, Хабр

Accelerating PHP connectors for Tarantool using Async, Swoole, and Parallel
18 December 2019, Хабр

provided by Google News

How TerminusDB is commercializing its open source graph database
16 March 2021, VentureBeat

TerminusDB Takes on Data Collaboration with a git-Like Approach
1 December 2020, The New Stack

Trinity College spinout TerminusDB secures €3.6m in investment
15 March 2021, The Irish Times

[MCR2030-CAMS-ARISE-UNDRR Webinar] Preventing cascading failures of critical assets: Using the Open-Source ...
12 April 2022, United Nations Office for Disaster Risk Reduction

Irish start-ups received €28m from Enterprise Ireland in 2021
7 April 2022, SiliconRepublic.com

provided by Google News



Share this page

Featured Products

Datastax Astra logo

Bring all your data to Generative AI applications with vector search enabled by the most scalable
vector database available.
Try for Free

Neo4j logo

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

Milvus logo

Vector database designed for GenAI, fully equipped for enterprise implementation.
Try Managed Milvus for Free

Present your product here