DBMS > IRONdb vs. MySQL vs. TimesTen
System Properties Comparison IRONdb vs. MySQL vs. TimesTen
Please select another system to include it in the comparison.
|Editorial information provided by DB-Engines|
|Name||IRONdb Xexclude from comparison||MySQL Xexclude from comparison||TimesTen Xexclude from comparison|
|Description||A distributed Time Series DBMS with a focus on scalability, fault tolerance and operational simplicity||Widely used open source RDBMS||In-Memory RDBMS compatible to Oracle|
|Primary database model||Time Series DBMS||Relational DBMS Key/Value like access via memcached API||Relational DBMS|
|Secondary database models||Document store|
|Developer||Circonus LLC.||Oracle since 2010, originally MySQL AB, then Sun||Oracle, TimesTen Performance Software, HP originally founded in HP Labs it was acquired by Oracle in 2005|
|Current release||V0.10.20, January 2018||8.0.17, July 2019||11 Release 2 (22.214.171.124.0)|
|License Commercial or Open Source||commercial||Open Source GPL version 2. Commercial licenses with extended functionallity are available||commercial|
|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.
|Implementation language||C and C++||C and C++|
|Server operating systems||Linux||FreeBSD|
|Typing predefined data types such as float or date||yes text, numeric, histograms||yes||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||yes||no|
|SQL Support of SQL||SQL-like query language (Circonus Analytics Query Language: CAQL)||yes with proprietary extensions||yes|
|APIs and other access methods||HTTP API||Proprietary native API|
Oracle Call Interface (OCI)
|Supported programming languages||.Net|
|Server-side scripts Stored procedures||yes, in Lua||yes proprietary syntax||PL/SQL|
|Partitioning methods Methods for storing different data on different nodes||Automatic, metric affinity per node||horizontal partitioning, sharding with MySQL Cluster or MySQL Fabric||none|
|Replication methods Methods for redundantly storing data on multiple nodes||configurable replication factor, datacenter aware||Master-master 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 per node, eventual consistency across nodes||Immediate Consistency||Immediate Consistency or Eventual Consistency depending on configuration|
|Foreign keys Referential integrity||no||yes not for MyISAM storage engine||yes|
|Transaction concepts Support to ensure data integrity after non-atomic manipulations of data||no||ACID not for MyISAM storage engine||ACID|
|Concurrency Support for concurrent manipulation of data||yes||yes table locks or row locks depending on storage engine||yes|
|Durability Support for making data persistent||yes||yes||yes by means of logfiles and checkpoints|
|In-memory capabilities Is there an option to define some or all structures to be held in-memory only.||no||yes||yes|
|User concepts Access control||no||Users with fine-grained authorization concept no user groups or roles||fine grained access rights according to SQL-standard|
|More information provided by the system vendor|
|Specific characteristics||IRONdb is a highly available, distributed Time Series Database. It can support dozens...|
|The world's first commercial In-Memory Relational Database offering (launched in...|
|Competitive advantages||Unmatched Scalability IRONdb is unique among TSDBs in that it does not use a consensus...|
|TimesTen offers many advantages over competing products: Mature product with nearly...|
|Typical application scenarios||Real Systems Monitoring Monitor your systems infrastructure in real time across thousands...|
|TimesTen can be used in a wide range of application areas. Some examples include:...|
|Key customers||IRONdb serves the needs of the world's largest Time Series Database customers. One...|
|Some of our key customers include Ericsson , Telcordia , China Mobile, China Telecom,...|
|Market metrics||Only TSDB capable of scaling to billions of metrics. Only TSDB to scale to dozens...|
|TimesTen is used by thousands of customers in tens of thousands of deployments worldwide...|
|Licensing and pricing models||IRONdb is licensed under a subscription model based on the number of active metrics...|
|Standard Oracle licence models ; end user and ISV/OEM licence terms available.|
We invite representatives of system vendors to contact us for updating and extending the system information,
|Related products and services|
|3rd parties||Azure Database for MySQL provides fully managed, enterprise-ready community MySQL database as a service|
ScaleGrid: Fully managed MySQL-as-a-Service.
Dremio is like magic for MySQL accelerating your analytical queries up to 1,000x.
Navicat for MySQL is the ideal solution for MySQL/MariaDB administration and development.
General SQL Parser: Instantly adding parsing, decoding, analysis and rewrite SQL processing capability to your products.
CData: Connect to Big Data & NoSQL through standard Drivers.
SQLPro for MySQL: A simple but powerful MySQL database client available on iPhone and iPad as well as macOS.
We invite representatives of vendors of related products to contact us for presenting information about their offerings here.
|DB-Engines blog posts|
MariaDB strengthens its position in the open source RDBMS market The struggle for the hegemony in Oracle's database empire
The struggle for the hegemony in Oracle's database empire
|Recent citations in the news|
MongoDB vs. MySQL: How to choose
DBmaestro Brings Database Release Automation to MySQL, MariaDB and RDS
Raytracing with MySQL
The Tactile Group | MySQL Database Developer
Oct 16 | MySQL Happy Hour | San Diego
provided by Google News
Oracle gooses Exalytics in-memory appliance with flash, fat DDR3 sticks
provided by Google News
Database Administrator, Expert
Database Developer - Database Administrator (DBA)
Open Source Database Administrator
DevOps Database Administrator
Share this page