Tokutek Optimizes TokuDB for Flash Memory

LEXINGTON, MA--(Marketwire - Sep 25, 2012) - Tokutek, the leader in high-performance and agile database storage engines, today announced TokuDB® v6.5, the latest version of its flagship product. Optimized to extend the life of flash memory while improving compression, performance, and agility, TokuDB v6.5 helps MySQL database and storage administrators overcome the common constraints of space and longevity associated with flash.

Driven by Tokutek's proprietary Fractal Tree® indexes, a new data structure that performs up to two orders of magnitude faster than traditional B-Tree technology, TokuDB v6.5 delivers superlative read/write characteristics that intelligently aggregate and rebalance indexed data. With TokuDB v6.5, MySQL users realize the following benefits:

• Stores 10x More Data - TokuDB delivers 10x compression without any performance degradation. Users can therefore take advantage of much greater amounts of available space without paying more for additional storage.
  
  
• Extends Wear Life - TokuDB's proprietary Fractal Tree indexing writes fewer, larger blocks. This reduces the overall wear and more efficiently utilizes the FTL (Flash Translation Layer) to extend the life of flash memory by an order of magnitude for many applications.
  
  
• Delivers High Insertion Speed - TokuDB Fractal Tree indexes continue to expand database capacity with huge insertion rates and greater scalability. The latest release delivers an order of magnitude improvement in insertion performance over the competition for flash memory. It is ideal for applications that must simultaneously query and update large volumes of rapidly arriving data (e.g., clickstream analytics).
  
  
• Allows Hot Schema Changes - Hot column addition/deletion/rename/resize provides the ability to add/drop/change a column to a database without taking the database offline. Database administrators are free to redefine or add new fields with no downtime.

Social media monitoring company Swaylo relies on MySQL and TokuDB today to track and analyze activities on Facebook and Twitter and is moving to include other networks. "These social networks will continue to grow, as will the connections of people between them. So Swaylo's database needs to handle billions of rows and beyond," said Udi Nir, co-founder and vice president of engineering at Swaylo. "TokuDB is the only MySQL/NoSQL solution that allowed us to scale our write throughput in a cost effective way. It delivered a two orders of magnitude gain in write performance for MySQL. In addition, query time improved, dropping from hours to just minutes. We currently have replication on all of our instances, for both backup and read scale, and TokuDB is holding up quite well. We expect TokuDB v6.5 to provide us with additional headroom as we continue to expand."

"TokuDB has a clever architecture for managing mixed read/write workloads," said Curt Monash, president of Monash Research and editor of DBMS 2. "It will be interesting to see how that translates to solid-state storage."

Today, database demands are driving flash to be deployed in more than half of all datacenters. TokuDB continues to be the ideal choice for complex high-volume applications that require fast response time and that must simultaneously store and query large volumes of rapidly arriving data. These include social networking applications, real-time clickstream analysis, logfile analysis, eCommerce Personalization, and high-speed webcrawling applications. TokuDB is fully compatible with MySQL and MariaDB

To learn more about TokuDB v6.5:

• Download a free trial of TokuDB
• Attend a Webinar overview of TokuDB v6.5
• Read our detailed blog series on TokuDB v6.5 performance
• Come to our booth #6202 at MySQL Connect Sept. 29 & 30 in San Francisco
• Come to our table October 1 & 2 at Percona Live NYC
• Catch Tokutek chief architect Bradley Kuszmaul's presentation "Solving the Challenges of Big Databases with MySQL" at 5:45 pm on Sunday, Sep 30, at MySQL Connect and at 1:30 p.m. on Tuesday, Oct. 2, at Percona Live NYC

About Tokutek Inc.
Tokutek, Inc. is the leader in high-performance and agile database storage solutions. TokuDB^®, our flagship product, is a storage engine for MySQL and MariaDB that uses Fractal Tree Indexes. It enables MySQL and MariaDB to scale from GBs to TBs and provides improved query performance, excellent compression, and online schema flexibility. TokuDB requires no changes to MySQL applications or code and is fully ACID and MVCC compliant. The company is headquartered in Lexington, MA and has offices in New York, NY. For more information, visit tokutek.com.

About MySQL
MySQL is the most popular open source database software in the world. Many of the world's largest and fastest-growing organizations use MySQL to save time and money powering their high-volume Web sites, critical business systems, communications networks, and commercial software. MySQL is owned by Oracle, the world's largest business software company.

About MariaDB
MariaDB strives to be the logical choice for database professionals looking for a robust, scalable, and reliable RDBMS (Relational Database Management System). MariaDB can be deployed as a drop-in replacement for the popular MySQL database and it is built by the original MySQL architects and most of the original core developers of MySQL with assistance from the broader community of Free and open source software developers. In addition to the core functionality of MySQL, MariaDB offers a rich set of feature enhancements including alternate storage engines, server optimizations, and security and performance patches. More information on MariaDB is available at http://mariadb.org and http://kb.askmonty.org.