what is replacement for innodb
Falcon is a purchased technology from Netfrastructure in 1996. That was incorporated as a storage engine and was designed to be a possible replacement to InnoDB as the default transactional storage engine. This was due to the purchase of Innobase, the creators of InnoDB by Oracle Corporation, a competitor of the MySQL product.
Unfortunately this engine has never lived up to the published hype. A key feature of the now defunct MySQL 6.0 product, Falcon is not included in the current alpha version of MySQL 5.4. With a change in policy of future products from feature-based releases to time-based and feature-complete requirements, there is no schedule on when Falcon will be available and production ready. In addition, the original architect of Falcon is no longer a member of the development team or working actively on the product.
Key Features of Falcon:
Page and record caches
Flexible page size for tablespace
Additional meta data information in the INFORMATION_SCHEMA
Supports MVCC (Multi Version Concurrency Control)
Designed for machines with lots of RAM
Dynamic data compression
Limitations of Falcon:
Not a GA product
No roadmap for implementation
falcon_page_cache_size: This defines the amount of memory used for caching data.
falcon_io_threads: This defi nes the number of background threads for performing disk
falcon_page_size: This defines the size of the data pages for tablespaces.
falcon_checkpoint_schedule: This defi nes the frequency of checkpoints that synchronize
in memory and disk information. The specification is a crontab format string.
Falcon has a large number of system parameters (currently 29) that you can view using SHOW GLOBAL
VARIABLES LIKE ‘falcon%’. Though there is no output from the commands used by other engines
such as SHOW GLOBAL STATUS LIKE ‘falcon%’ and SHOW ENGINE FALCON STATUS. All diagnostic
information is available via Falcon specific INFORMATION_SCHEMA tables.
The current list is:
What are storage engines are used in databases:
eBay Memory Engine
MySQL storage engines
eBay Memory Engine