DBMS > Amazon Aurora vs. Axibase vs. Couchbase vs. InfluxDB vs. MySQL
System Properties Comparison Amazon Aurora vs. Axibase vs. Couchbase vs. InfluxDB vs. MySQL
| Editorial information provided by DB-Engines | ||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
| Name | Amazon Aurora Xexclude from comparison | Axibase Xexclude from comparison | Couchbase  Originally called Membase Xexclude from comparison | InfluxDB Xexclude from comparison | MySQL Xexclude from comparison | |||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
| Description | MySQL and PostgreSQL compatible cloud service by Amazon | Scalable TimeSeries DBMS based on HBase with integrated rule engine and visualization | JSON-based document store derived from CouchDB with a Memcached-compatible interface | DBMS for storing time series, events and metrics | Widely used open source RDBMS | |||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
| Primary database model | Relational DBMS | Time Series DBMS | Document store | Time Series DBMS | Relational DBMS Key/Value like access via memcached API | |||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
| Secondary database models | Document store | Key-value store originating from the former Membase product and supporting the Memcached protocol | Document store | |||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
|
|
|
|
|
| |||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
| Website | aws.amazon.com/rds/aurora | axibase.com/products/axibase-time-series-database | www.couchbase.com | www.influxdata.com/products/influxdb-overview | www.mysql.com | |||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
| Technical documentation | docs.aws.amazon.com/AmazonRDS/latest/AuroraUserGuide/CHAP_Aurora.html | github.com/axibase/atsd | docs.couchbase.com | docs.influxdata.com/influxdb | dev.mysql.com/doc | |||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
| Developer | Amazon | Axibase Corporation | Couchbase, Inc. | Oracle since 2010, originally MySQL AB, then Sun | ||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
| Initial release | 2015 | 2013 | 2011 | 2013 | 1995 | |||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
| Current release | 15585 | Server: 6.0, October 2018; Mobile: 2.5, May 2019; Couchbase Autonomous Operator: 1.2, May 2019 | 1.7.8, August 2019 | 8.0.18, October 2019 | ||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
| License Commercial or Open Source | commercial | commercial Community Edition (single node) is free, Enterprise Edition (distributed) is paid | Open Source Apache version 2; Commercial licenses also available | 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 | yes | no | no | no | no | |||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
| DBaaS offerings (sponsored links) Database as a Service Providers of DBaaS offerings, please contact us to be listed. | Azure Database for MySQL: A fully managed, scalable MySQL relational database with high availability and security built in at no extra cost | |||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
| Implementation language | Java | C, C++, Go and Erlang | Go | C and C++ | ||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
| Server operating systems | hosted | Linux | Linux OS X Windows | Linux OS X through Homebrew | FreeBSD Linux OS X Solaris Windows | |||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
| Data scheme | yes | yes | schema-free | schema-free | yes | |||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
| Typing predefined data types such as float or date | yes | yes short, integer, long, float, double, decimal, string | yes String, Boolean, Number | 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. | yes | no | no | yes | ||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
| Secondary indexes | yes | no | yes | no | yes | |||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
| SQL Support of SQL | yes | SQL-like query language | Declarative query language (N1QL) that extends ANSI SQL to JSON. First commercial implementation of SQL++. | SQL-like query language | yes with proprietary extensions | |||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
| APIs and other access methods | ADO.NET JDBC ODBC | JDBC Proprietary protocol (Network API) RESTful HTTP API | Native language bindings for CRUD, Query, Search and Analytics APIs | HTTP API JSON over UDP | ADO.NET JDBC ODBC Proprietary native API | |||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
| Supported programming languages | Ada C C# C++ D Delphi Eiffel Erlang Haskell Java JavaScript (Node.js) Objective-C OCaml Perl PHP Python Ruby Scheme Tcl | Go Java PHP Python R Ruby | .Net C Clojure ColdFusion Erlang Go Java JavaScript Node.jsPerl PHP Python Ruby Scala Tcl | .Net Clojure Erlang Go Haskell Java JavaScript JavaScript (Node.js) Lisp Perl PHP Python R Ruby Rust Scala | Ada C C# C++ D Delphi Eiffel Erlang Haskell Java JavaScript (Node.js) Objective-C OCaml Perl PHP Python Ruby Scheme Tcl | |||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
| Server-side scripts Stored procedures | yes | yes | Functions and timers in JavaScript | no | yes proprietary syntax | |||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
| Triggers | yes | yes | yes via the TAP protocol | no | yes | |||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
| Partitioning methods Methods for storing different data on different nodes | horizontal partitioning | Sharding | Sharding | Sharding in enterprise version only | horizontal partitioning, sharding with MySQL Cluster or MySQL Fabric | |||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
| Replication methods Methods for redundantly storing data on multiple nodes | Master-slave replication | Master-slave replication | Master-master replication including cross data center replication Master-slave replication | selectable replication factor in enterprise version only | Master-master replication Master-slave replication | |||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
| MapReduce Offers an API for user-defined Map/Reduce methods | no | yes | yes | no | no | |||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
| Consistency concepts Methods to ensure consistency in a distributed system | Immediate Consistency | Eventual Consistency Immediate Consistency selectable on a per-operation basis | Immediate Consistency | |||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
| Foreign keys Referential integrity | yes | no | no | no | yes not for MyISAM storage engine | |||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
| Transaction concepts Support to ensure data integrity after non-atomic manipulations of data | ACID | no | Single-document ACID transactions | no | ACID not for MyISAM storage engine | |||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
| Concurrency Support for concurrent manipulation of data | yes | yes | yes | yes | yes table locks or row locks depending on storage engine | |||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
| Durability Support for making data persistent | yes | yes | yes | yes | yes | |||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
| In-memory capabilities Is there an option to define some or all structures to be held in-memory only. | yes | yes Ephemeral buckets | yes Depending on used storage engine | yes | ||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
| User concepts Access control | fine grained access rights according to SQL-standard | User and Administrator separation with password-based and LDAP integrated Authentication | simple rights management via user accounts | Users with fine-grained authorization concept no user groups or roles | ||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
| More information provided by the system vendor | ||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
| Amazon Aurora | Axibase | Couchbase Originally called Membase | InfluxDB | MySQL | ||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
| Specific characteristics | Developed as an alternative to traditionally inflexible relational databases, Couchbase... » more | InfluxData is the creator of InfluxDB , the open source time series database. It... » more | ||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
| Competitive advantages | Couchbase was architected with several differentiated capabilities: Shared-nothing,... » more | Time to Value An end-to-end platform, InfluxData is ready to go on the cloud or via... » more | ||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
| Typical application scenarios | Customer 360 for user profile, session store and data aggregation (Comcast, Equifax,... » more | IoT & Sensor Monitoring Instrumentation of every available surface in the material... » more | ||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
| Key customers | Amadeus, AT&T, BD (Becton, Dickinson and Company), Carrefour, Cisco, Comcast, Disney,... » more | InfluxData has over 630 paying customers, including IBM, PayPal, Siemens Tesla and... » more | ||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
| Market metrics | Named a leader in the Forrester Wave™: Big Data NoSQL, Q1 2019 Over 10M downloads... » more | Fastest growing database to garnish 17,000 github stars Over 260,000 daily active... » more | ||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
| Licensing and pricing models | The Community Edition (CE) of Couchbase Server and Couchbase Mobile are available... » more | Open source core with closed source clustering available either on-premise or on... » more | ||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
We invite representatives of system vendors to contact us for updating and extending the system information, | ||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
| Related products and services | ||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
| 3rd parties | CData: Connect to Big Data & NoSQL through standard Drivers. » more | Navicat for MySQL is the ideal solution for MySQL/MariaDB administration and development. » more CData: Connect to Big Data & NoSQL through standard Drivers. » more ScaleGrid: Fully managed MySQL-as-a-Service. » more General SQL Parser: Instantly adding parsing, decoding, analysis and rewrite SQL processing capability to your products. » more Dremio is like magic for MySQL accelerating your analytical queries up to 1,000x. » more SQLPro for MySQL: A simple but powerful MySQL database client available on iPhone and iPad as well as macOS. » more Azure Database for MySQL provides fully managed, enterprise-ready community MySQL database as a service » more | ||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
We invite representatives of vendors of related products to contact us for presenting information about their offerings here. | ||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
| More resources | ||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
| Amazon Aurora | Axibase | Couchbase Originally called Membase | InfluxDB | MySQL | ||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
| DB-Engines blog posts | The popularity of cloud-based DBMSs has increased tenfold in four years Amazon - the rising star in the DBMS market | Couchbase climbs up the DB-Engines Ranking, increasing its popularity by 10% every month | Why Build a Time Series Data Platform? Time Series DBMS are the database category with the fastest increase in popularity Time Series DBMS as a new trend? | MariaDB strengthens its position in the open source RDBMS market The struggle for the hegemony in Oracle's database empire Microsoft SQL Server is the DBMS of the Year New Amazon Aurora integrations make machine learning more accessible to developers Modernize Your Applications on Amazon Aurora AWS Re:Invent 2019 Las Vegas Roundup: Innovation, Tech Announcements, and Product Launches Ivanti Announces Sponsorship for AWS re:Invent 2019 FINRA Selects Amazon Web Services as Cloud Service Provider for Market Surveillance Data provided by Google News Time Series Intelligence Software Market Set to Witness Huge Growth by 2019-2026 Focusing on Leading Players; Azure Time Series Insights, Shapelets, Seeq, Trendalyze, AxiBase Enterprise Reporter (AER), Anodot, Datapred Time Series Intelligence Software Market Analysis, Growth by Top Companies, Trends by Types and Application, Forecast to 2024 Time Series Intelligence Software Market Global and Regional Analysis by Top Key Market Players, Key Regions, Product Segments, and Applications 2024 Time Series Intelligence Software Market - Growth, Statistics, By Application, Production, Revenue & Forecast To 2025 Business, Healthcare, Industry Latest News, Updated News, Latest trending News provided by Google News Couchbase to Present at Upcoming Investor Conferences Couchbase Named to Deloitte Technology Fast 500™ for Third Consecutive Year Altoros Releases 2019 Comparative Analysis of Database Query Languages in MySQL, Couchbase, and MongoDB Global NoSQL Market Growth 2019-2025 – Oracle, MarkLogic, MongoDB, Couchbase, Database, Basho, Aerospike, Neo4j Global NoSQL Market 2019-2025 MongoLab, MarkLogic, Couchbase, CloudDB, DynamoDB, Basho Technologies provided by Google News InfluxData Brings InfluxDB Cloud 2.0 Serverless Platform to Europe to Support Enterprise Transformation with Time Series Technology DevOps Chats: InfluxDB Cloud 2.0 Managed Service for Time Series Data Creating Your Personal IoT/Utility Dashboard Using Grafana, Influxdb & Telegraf on a Raspberry Pi InfluxData Adds Major New Customers in 2019 — Underscoring the Extensive Demand and Capabilities of Time Series Technology news digest: ONNX at LF AI Foundation, InfluxDB Cloud 2.0, and IBM partners with Stanford Human-Centered AI Institute - SD Times provided by Google News IDERA SQL Diagnostic Manager for MySQL Improves Query Performance and Enterprise Security Laravel and MySQL 8: Fixing MySQL Server Has Gone Away Error Query Performance Optimization in MySQL Understanding Schema Optimization in MySQL Alliance Key Manager Now Supports Encryption Key Management for MySQL Enterprise Edition Database provided by Google News Aurora SDE Pooling Req Software Dev Engineer - Amazon Aurora Data Scientist Software Developer -- Aurora Remote Data Engineer (USA) Senior Clinical IT Analysts Dir-IT Application Dev Principal Product Manager - Security, Couchbase Database Engineer - R&D skills, Java, NoSQL (Cassandra, Couchbase, MongoDB) DevOps Engineer EIM Software Development Engineer Systems Administrator Research Computing Specialist Infrastructure Engineer Production Engineer MySQL DBA - remote MySQL Database Engineer - Americas - remote Data Scientist Database Administrator (MySQL) PHP Developer | ||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
Share this page
