What are differences between different storage engines


What are differences between different storage engines

Inno DB
eBay Memory Engine
MySQL storage engines
eBay Memory Engine
NDB,NITRO EDB AND ebay Memory engines brief detailed study is given below for those developers who have keen interest of learning other engines other than mysql.
The Percona XtraDB storage engine is a drop-in and backward-compatible InnoDB storage engine.
This engine includes all the listed features of InnoDB but includes specifi c modifi cations to provide additional instrumentation, better memory management, and performance and scalability improvements for large core and highly concurrent work environments.

NDB Storage Engine

This engine is actually an entire product originally purchased by MySQL and incorporated into the MySQL Cluster product. NDB includes a number of key features that distinguish it from a more traditional MySQL storage engine. The NDB engine provides transaction support and synchronous replication ensuring that all data nodes are consistent. It also provides a native C interface to directly with the data by passing the SQL interact if desired for three to fi ve times performance improvement.
NDB has a number of strengths and weaknesses in comparison to the MySQL server product.This does not make this a drop-in replacement for a MySQL replication topology.
NDB is popular with the telecommunication and gaming industries that use primary key lookups, few joins, and require much high availability.

eBay Memory Engine

The eBay Memory engine extends the default Memory storage engine by providing variable-length record support. As discussed in the Memory section, one key use of this engine is for session management.One key disadvantage here is the fi xed-width limitation. This engine enables a far greater amount of in-memory session data to be maintained, and could be ideal for large web sites that manage in-session information. This engine is also the default temporary table engine and Memory storage engine for the Drizzle product.

Nitro EDB Memory Engine

The NitroEDB storage engine was developed by Nitro Security. The underlying database product was developed in relative isolation from traditional relational databases and included some amazing features, including insert performance at 50,000 statements per second and aggregated index queries on large data sets up to 1,000 times faster than existing storage engines. This engine also supported patented technologies in N-Tree management that extended traditional relational functionality.

Solid Memory Engine

Solid is a transactional engine from Solid Tech that was acquired by IBM and effectively shelved. The current IBM solidDB product page does not include any references to the originally developed MySQL storage engine.

Leave A Reply

Your email address will not be published.