Solutions
Latest Projects
Inovahire
Inovahire
Inovahire
Contact

We Know What Works!

Wide Web Way is the best web development company in the middle east targeting KSA, UAE, Jordan and Arab World in general. It has a wide range of tools and experienced team members to help you achieve your goals, whether you're expanding on an existing website, or just starting out.

What is TokuDB? How to install TokuDB on mysql 5.1?

TokuDB is a highly scalable, zero maintenance downtime, MySQL storage engine that delivers indexing-based query acceleration and enables hot schema modiļ¬cations designed for high performance on write-intensive workloads.

TokuDB is a plugin storage engine requiring no changes to MySQL applications or code and is fully ACID (Atomicity, Consistency, Isolation, and Durability) and MVCC (Multi-version Concurrency Control) compliant.
Once you install TokuDB, you can define any table to use TokuDB, MyISAM, InnoDB, or any other storage engine.

Features of TokuDB:

  • Hot schema changes:
    • Hotindex creation: TokuDB tables support insertions, deletions and queries with no down time while indexes are being added to that table. It uses Fractal Tree for indexing while innodb uses B-Tree
    • Hot column addition and deletion: TokuDB tables support insertions, deletions and queries with minimal down time when an alter table adds or deletes columns.
  • Fast recovery time (seconds, not hours or days).
  • Immunity to database disorder or "aging" and the gradual performance degradation it causes.
  • 5x-15x data compression. TokuDB typically achieves a 5x-15x space savings on data and indexes over InnoDB due to aggressive compression. TokuDB 5.2.7 does not compress logs.
  • Fragmentation Immunity: no dump/reload downtime and no index fragmentation.

System requirements:

  • TokuDB supports 64 bit operating systems only
  • TokuDB requires at least 1GB of main memory.
  • Does't Support Mysql 5.5 till now, hopefully it will within a few months.

Installation of TokuDB over mysql 5.1

  1. Register at Tokutek Registration page
  2. Download the version that supports your version from TokuDB Download Page (free for evaluation purposes or in production up to 50GB of user data). and extract it in /tmp
  3. Take a backup of your databases.
  4. Stop mysql
    $ service mysql stop
  5. $ mv /tmp/mysql-5.1.52-tokudb-5.2.7-38674-linux-x86_64 /usr/local/mysql
  6. $ cd /usr/local/mysql
  7. $ bin/mysql_install_db --user=mysql --basedir=$PWD
  8. $ bin/mysqld_safe --basedir=$PWD &
Now show engines will give:
mysql> show engines\G
*************************** 5. row ***************************
      Engine: TokuDB
     Support: YES
     Comment: Tokutek TokuDB Storage Engine with Fractal Tree(tm) Technology
Transactions: YES
          XA: NO
  Savepoints: YES

 
 

you are allowed to use <a> , <i>, <b>,<ul>,<li> and <br> tags

Tim Dickens said: B-Tree Vs Fractal Tree at 2012-04-09 10:18:38
The B-tree data structure allows for operations like inserting data and sorted order iteration, the primary operation used by an index. Depending on the workload and implementation, B-tree performance can be limited by the random I/O characteristics of disks.

Fractal Tree indexes implement the same operations as a B-tree, and thus are a drop-in replacement for B-trees. Fractal Tree indexes effectively replace random I/O with sequential I/O, which is faster on spinning disks. By converting random I/O into sequential I/O, Fractal Trees index data at near disk bandwidth rates, regardless of the structure of the primary and secondary keys, and have range queries that stream data off disk at near disk bandwidth rates, even as the database grows. As a result, more indexes can be maintained without a drop in performance. This is because adding data to indexes tends to stress the performance of B-trees, but performs well in Fractal Tree indexes.


A.MURUGESAN said: TOKU DB at 2012-04-09 16:09:16
More about Toku DB.


 
Blog
Tips and Tricks from the
Web Development Experts