The ability to store and retrieve data from various products including relational and non relational databases is a critical business function. This information provides details and thoughts on various data store offerings available.
Data Store Overview
There are many current and emerging products that can be considered as suitable for storing and managing data. This list is an attempt to identify popular products that existing organizations that use MySQL may consider as alternatives.
Legend
- [OSS] - Open Source Software, no commercial version.
- [CR] - Cloud ready, designed to run in a distributed mode.
- [$$$] - Commercial Product.
- [$OS$] - Commercial Product with a free restricted offering.
Data Store Products
- HBase - Hadoop database. Distributed, column-oriented store based on BigTable design [OSS] [CR]
- CouchDB - Document oreinted, schemaless distributed database. [OSS] [CR]
- Tokyo Cabinet - Modern implementent of DBM - key/value database. [OSS] [CR]
- Vertica - MPP, Column-Oriented Analytic Database for Data Warehousing and Analytics. [$$$]
- Mongo - The 10gen schema-free document database designed for cloud computing [OSS] [CR]
- Vectorwise - vectorized and column-wise data processing.
- Continuent Tungsten Suite - Advanced services for database scale-out and cross database management (e.g. Oracle, MySQL, PostgreSQL) [OSS]
- Paraccel - columnar, MPP database for data warehousing, analytics. [$$$]
- Cassandra - eventually consistent, distributed, structured key-value store [CR]
- memcached - distributed memory object caching system key/value pairs [OSS] [CR]
- Google Appengine . [$OS$] [CR]
- AWS SimpleDB. [$$$] [CR]
- LucidDB - Data warehousing and business intelligence. [OSS]
- Kloudshare - Cloud based semantic database. [$$$] [CR]
- Project Voldemort - distributed key-value storage system [OSS] [CR]
- Redis - data structures server - key-value persistent database [OSS]
Relational Database Alternatives
Other products that provide a Structured Query Language (SQL) interface.
- Drizzle [OSS]
MySQL Family - Software
Any product that generally looks and feels like MySQL and communicates using the MySQL protocol.
- Percona Performance Patches [OSS]
- MariaDB - The next MySQL fully compatible Server + Maria Storage Engine [OSS]
- Tokutek - Fractal Base Storage Engine. [$OS$]
- Calpont - multi-threaded, modular, distributed MPP storage engine . [$$$]
- Infobright - Data Warehousing. [$OS$]
- Innodb Pluggable Storage Engine [OSS]
- Rethink DB - MySQL storage engine for Solid State Drives (SSD)
MySQL Family - Hardware Applicance
- Kickfire - Column oriented with hardware accelaration. [$$$]
- Virident - Greencloud server for MySQL - Optimized/Customized InnoDB with direct storage class memory access. [$$$]
- Schooner Tech - Memcache/MySQL Appliance. [$$$]
Memcached Family
- Moxi - memcached proxy by Northscale
- memcached Virtual Appliance - self configuring vmware application
- MemcacheDB - distributed and persistent key-value storage
- gear6 - memcache appliance