SOURCE: Tokutek

Tokutek

April 09, 2012 09:00 ET

Tokutek Brings Replication Performance to MySQL and MariaDB

By Ensuring Read Scalability and Improved Disaster Recovery, TokuDB v6.0 Solves the Challenge of 'Slave Lag' While Delivering a Smaller Storage Footprint

SANTA CLARA, CA--(Marketwire - Apr 9, 2012) - Percona Live 2012 Conference -- Tokutek, the leader in high-performance and agile database storage engines, today announced TokuDB® v6.0 with high performance replication for MySQL and MariaDB. 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. TokuDB v6.0 solves this by offering high ingestion rates at the slave with best in class compression.

Baron Schwartz, author of the recently updated book, High Performance MySQL: Optimization, Backups, Replication, and More, notes that "Writes are usually the bottleneck in MySQL replication. The single-threaded nature of MySQL replication means it's relatively inefficient on the slave; even a fast slave with lots of disks, CPUs, and memory can easily fall behind a master."

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.

"Replication performance has been a persistent problem for MySQL, and in recent years in particular has become a focal point for innovation in the MySQL ecosystem," commented Matt Aslett, research manager, data management and analytics, 451 Research. "The high data ingestion rates claimed by Tokutek would appear to be a natural fit to helping solve the problem of slave lag in particular."

"Prior to TokuDB, we were using InnoDB for storing all data," said Bastian Axter, director of operations at Evidenzia GmbH & Co. KG. Evidenzia is one of the leading partners of the software, movie, and music industry when it comes to tracing copyright infringements and illegal file sharing activities in peer-to-peer networks. "We found that as the tables grew bigger, the selects were becoming slower, taking as much as an hour or more, and the disk I/O was growing higher." Evidenzia considered storing all the data on SSD, but it was much too expensive. "With TokuDB, the overall impact on disk I/O was impressive, dropping from near 80%-100% down to 5%-10%. We save over 70% on storage," concluded Axter. "We expect TokuDB v6.0 to provide us with additional headroom and capabilities as we continue to expand the service."

With TokuDB v6.0, MySQL users realize the following benefits:

  • 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.
  • Disaster Recovery - TokuDB v6.0 enables quick recovery after backup snapshots and ensures up-to-date recovery points after a failure.
  • Write Optimized Compression - TokuDB has always led the pack on compression performance. With version 6.0 it is even more aggressive, with compression levels up to 25x.

In addition, TokuDB v6.0 also provides better in-memory and point-query performance, two-phase commit for XA, support for MySQL v5.5 (and v5.1) as well as MariaDB v5.2, and improved checkpoint variability.

  • Download a free trial of TokuDB
  • Read the full Evidenzia case study here
  • Hear Martín Farach-Colton, Tokutek's CTO, talk about TokuDB v6.0 on the MySQL Database Community Podcast (Episode 86)
  • Come to our booth #410 at Percona Live
  • Catch Tokutek VP of Engineering's Tim Callaghan's presentation at Percona Live on April 11th at 4:30 pm

About Tokutek Inc.
Tokutek, Inc. is the leader in high-performance and agile database storage engines. TokuDB, our flagship product, is a highly scalable, zero maintenance downtime, MySQL Storage Engine that delivers indexing-based query acceleration and enables hot schema modifications. TokuDB is a "drop-in" storage engine requiring 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.

Contact Information