Editorial information provided by DB-Engines

NameIgnite  Xexclude from comparisonMySQL  Xexclude from comparisonSAP HANA  Xexclude from comparison

DescriptionApache Ignite is a memory-centric distributed database, caching, and processing platform for transactional, analytical, and streaming workloads, delivering in-memory speeds at petabyte scale.Widely used open source RDBMSIn-memory, column based data store. Available as appliance or cloud service

Primary database modelRelational DBMS Key/Value like access via memcached API

Secondary database modelsDocument store

Graph DBMS with SAP Hana, Enterprise Edition

DB-Engines Ranking measures the popularity of database management systems

DeveloperApache Software FoundationOracle since 2010, originally MySQL AB, then SunSAP

Initial release201519952010

Current releaseApache Ignite 2.68.0.23 , January 20212.0 SPS05 (June 26, 2020), June 2020

License Commercial or Open SourceOpen Source Apache 2.0Open Source GPL version 2. Commercial licenses with extended functionallity are availablecommercial

Cloud-based only Only available as a cloud servicenonono also available as a cloud based service

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 languageC++, Java, .NetC and C++

Server operating systemsLinux

OS X

Solaris

WindowsFreeBSD

Linux

OS X

Solaris

WindowsAppliance or cloud-service

Data schemeyesyesyes

Typing predefined data types such as float or dateyesyesyes

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.yesyesno

Secondary indexesyesyesyes

SQL Support of SQLANSI-99 for query and DML statements, subset of DDLyes with proprietary extensionsyes

APIs and other access methodsHDFS API

Hibernate

JCache

JDBC

ODBC

Proprietary protocol

RESTful HTTP API

Spring DataADO.NET

JDBC

ODBC

Proprietary native APIJDBC

ODBC

Supported programming languagesC#

C++

Java

PHP

Python

Ruby

ScalaAda

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 proceduresyes (compute grid and cache interceptors can be used instead)yes proprietary syntaxSQLScript, R

Triggersyes (cache interceptors and events)yesyes

Partitioning methods Methods for storing different data on different nodesShardinghorizontal partitioning, sharding with MySQL Cluster or MySQL Fabricyes

Replication methods Methods for redundantly storing data on multiple nodesyes (replicated cache)Multi-source replication

Source-replica replicationyes

MapReduce Offers an API for user-defined Map/Reduce methodsyes (compute grid and hadoop accelerator)nono

Consistency concepts Methods to ensure consistency in a distributed systemImmediate ConsistencyImmediate ConsistencyImmediate Consistency

Foreign keys Referential integritynoyes not for MyISAM storage engineyes

Transaction concepts Support to ensure data integrity after non-atomic manipulations of dataACIDACID not for MyISAM storage engineACID

Concurrency Support for concurrent manipulation of datayesyes table locks or row locks depending on storage engineyes

Durability Support for making data persistentyesyesyes

In-memory capabilities Is there an option to define some or all structures to be held in-memory only.yesyesyes

User concepts Access controlSecurity Hooks for custom implementationsUsers with fine-grained authorization concept no user groups or rolesyes

More information provided by the system vendor

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 MySQL is the ideal solution for MySQL/MariaDB administration and development.

» more

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

» more

Datadog: Improve MySQL performance by visualizing and identifying errors fast using granular, out-of-the-box dashboards.

» more

CData: Connect to Big Data & NoSQL through standard Drivers.

» more

ClusterControl: the only management system you’ll ever need to take control of your open source database infrastructure.

» moreCData: Connect to Big Data & NoSQL through standard Drivers.

» more

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

More resources

IgniteMySQLSAP HANA