MySQL高性能存储引擎TokuDB
2013-04-23 15:00:51 
阿炯
TokuDB 是一个高性能、支持事务处理的 MySQL 和 MariaDB 的存储引擎，主要特点则是对高写压力的支持。从7.0版本开始 TokuDB 宣布开源，开源的社区版本提供全部功能和性能，无宕机的列添加、删除和重命名，以及索引创建，簇集的第二主键。同时也提高了企业版本，包含额外的支持包和高级备份和恢复工具。
TokuDB scales MySQL and MariaDB from GBs to TBs while improving insert and query speed, compression, replication performance and online schema flexibility for both HDDs and flash.
Key Benefits of TokuDB for MySQL and MariaDB
Performance: With a 10x or more improvement in insertions and indexing, TokuDB delivers faster, more complex ad hoc queries in live production systems without rewriting or tuning applications. Offering high performance even when tables are too large for memory, TokuDB scales MySQL and MariaDB far beyond either InnoDB or MyISAM.
Compression: By leveraging write-optimized compression, TokuDB achieves up to a 90% reduction in HDD and flash storage requirements, without impacting performance.
Agility: Hot Indexing enables ad hoc queries to run fast with realtime, optimized index support. Hot Column Addition/Deletion/Rename gives database administrators the freedom to rapidly define and add new fields.
Additional Benefits: Providing immunity to database aging by eliminating the need to rebuild indexes, TokuDB ensures no more query slowdowns, no more dump/reload, and no more need for dedicated maintenance windows. In addition, by utilizing larger, less frequent I/O, TokuDB reduces wear for flash. Finally, with high insertion rates, TokuDB addresses the common and persistent problem of “slave lag” in which a replication server is unable to keep up with the query load borne by the master server.
Advanced Tools (Enterprise Edition): Tools such as Hot Backup (coming soon) allow a backup to be completed while database is running.
最新版本：7.0
项目主页：http://www.tokutek.com/products/tokudb-for-mysql/