TokuDB v5.2 for MySQL and MariaDB

What if you could analyze every transaction, capture insights from every customer interaction, and didn’t have to wait for months to get data from the field?

Despite this tremendous opportunity, MySQL implementations are often kept relatively small, often on the order of 500 GB or less. Anything beyond this threshold inevitably leads to big operational problems, i.e. poor insertion rates, slow queries, hours to days for index rebuilding and offline schema changes, long loading times, dump/reload cycles during down time, extended recovery, etc. The promise of Big Data has remained largely unfulfilled for MySQL. Until now.

With TokuDB v5.2, Tokutek enables Big Data scalability on MySQL with support for Hot Schema Changes. This latest version of TokuDB v5.2 targets business agility with Hot Indexing, Hot Column Addition, and increased performance. TokuDB v5.2 enhances large databases (typically 500 GBs or larger) by speeding indexing up to 80x, thereby radically improving database scalability. Because of its exceptional indexing performance, TokuDB is ideal for applications that must simultaneously query and update large volumes of rapidly arriving data (e.g., clickstream analytics).

A true software-only MySQL plug-in, TokuDB is MVCC and ACID-compliant and fully compatible with existing MySQL applications, requiring no modification to existing MySQL code or application logic. TokuDB uses Tokutek’s proven Fractal Tree™ technology to extend the capacity of MySQL databases while improving performance, transactional integrity and operating efficiencies.

Key Benefits of TokuDB v5.2 for MySQL and MariaDB

  • Hot Schema Changes let you rapidly adapt to changing market conditions even on terabyte or larger databases: In a first for MySQL, TokuDB enables dynamic and rapid changes to database indexes and columns, allowing customers to remain agile with Big Data. Now index creation and column addition / deletion can run concurrently with read and write operations.
  • Overcome large database performance and scalability limitations: 20x-80x improvement in insertions and indexing without rewriting or tuning applications; enables scalability well-beyond InnoDB and MyISAM limitations.
  • Fast, more complex ad hoc queries are now possible, in live production systems.
  • ACID-compliant transactions ensures data integrity and without performance compromises.
  • Significant cost savings: streamlined programming, administration/maintenance; up to 90% reduction in disk storage requirements due to advanced compression; energy savings.
  • Eliminates need to migrate away from MySQL to overcome performance bottlenecks.
  • Compelling improvements in actionable data analysis: view data from multiple perspectives “on the fly;” ability to interpret and respond to changing conditions in real time.
  • Simplified MySQL configuration: no partitioning, data aggregation, down-sampling, tuning.
  • More uptime: recovery time measured in seconds or minutes, not hours or days.
  • No performance degradation, maintenance headaches: immunity to database aging means no more query slowdowns and no more dump/reload.
  • Fully compliant with standard MySQL storage engine API. TokuDB is fully compatible with existing applications. Data is loaded, inserted, and queried using standard MySQL commands, with no restrictions or special requirements. Tables can be individually defined to use TokuDB, MyISAM, InnoDB® or other MySQL-compliant storage engines.
  • MVCC: Multi-Version Concurrency Control greatly improves multi-user performance by eliminating row-level locking and table locking.

Try TokuDB v5.2 for MySQL and MariaDB Today

TokuDB v5.2 for MySQL is free for evaluation, free for development purposes, and free for academic research.

MySQL is a registered trademark of MySQL AB in the United States, the European Union and other countries.