TokuDB v6.0 for MySQL and MariaDB

“Writes are usually the bottleneck in MySQL replication”
-Baron Schwartz

Until now, organizations typically addressed slave lag by band-aids such as adding more slaves, buying hardware, or sharding the database. Far from ideal, each approach is either expensive, requires one to give up on full replication, or leads to time consuming application re-architecting.  TokuDB v6.0 eliminates 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. We solve this by offering high ingestion rates at the slave with best in class compression.

In addition, MySQL implementations are often kept relatively small, often on the order of 50 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.

TokuDB v6.0 enhances large databases (typically 50 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 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 v6.0 for MySQL and MariaDB

  • 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.
  • Read Scalability (Load balancing): Replication to several slaves helps distribute read queries across several servers. For read intensive applications, TokuDB v6.0 ensures that analysis and business reports on slaves act on fresh data.
  • Write Optimized Compression: TokuDB has always led the pack on compression performance. With version 6.0 it offers even more aggressive compression of up to 25x, delivering much more value from either traditional or flash drives.
  • Disaster Recovery: TokuDB v6.0 enables quick recovery after backup snapshots and ensures up-to-date recovery points after a failure. Also, for TokuDB, recovery time is measured in seconds or minutes, not hours or days.
  • 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.
  • Fast, more complex ad hoc queries are now possible, in live production systems.
  • 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.
  • 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. TokuDB is also ACID and MVCC compliant.

Try TokuDB v6.0 for MySQL and MariaDB Today

TokuDB v6.0 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.