by Martin.FarachColton | Dec 6, 2012 | MySQL
We get a lot of questions about how Fractal Tree indexes work. It’s a write-optimized index with fast queries, but which write-optimized indexing structure is it? In this ~15 minute video (which uses these slides), I give a quick overview of how they work and...
by Tokutek | Nov 27, 2012 | MySQL
In this webinar we will show step by step how to install, configure, and test TokuDB for a typical performance evaluation. We’ll also be flagging potential pitfalls that can ruin the eval results. It will describe the differences between installing from scratch...
by Tokutek | Nov 19, 2012 | MySQL
One of the great things about the MassTLC unConference is the spontaneity of the ideas. In the morning I ran into an old colleague whose startup was looking at switching databases and struggling with the options. Hence, “Scalable Databases for Startups” seemed like a...
by Tokutek | Nov 12, 2012 | MySQL
There is obviously much being written these days about Big Data. While the term has many different meanings to many different folks, our MySQL and MariaDB customers tend to find their data to be uncomfortably big when the tables become too large for memory. In this...
by Tokutek | Nov 5, 2012 | MySQL
It certainly has been a tough week on the East Coast. In the Boston area, where I am located, we got grazed by Sandy – power outages, trees down, schools closed, and Halloween delayed. This though, pales in comparison to what our NY office had to endure. One of...
by Tim.Callaghan | Oct 22, 2012 | MySQL
At tomorrow’s NoVA MySQL October Meetup, I will give a talk: “Fractal Tree Indexes – Theoretical Overview and Customer Use Cases.” The meetup is 7 pm Tuesday, October 23, 2012, and will be held at AOL Campus HQ in Dulles VA. Most databases employ B-trees...
by Tokutek | Oct 18, 2012 | MySQL
Next week I’ll be visiting Moscow to talk at Highload++. The conference will take place during Monday 22nd and Tuesday 23rd at the Radisson hotel. I will be giving my personal version of an indexing talk that my colleagues have given in meetups and conferences...
by Michael.Bender | Oct 15, 2012 | MySQL
Bradley and I (Michael) gave the tutorial on Data Structures and Algorithms for Big Databases at the 6th XLDB Conference last month. The tutorial was organized as follows: Module 0: Tutorial overview and introductions. We describe an observed (but not necessary)...
by Tokutek | Oct 11, 2012 | MySQL
The core technology behind Tokutek is based on the academic research by our founders: Michael Bender, Bradley Kuszmaul and Martin Farach-Colton. They are all still in academia, in addition to their work at Tokutek. Back in March, the White House kicked off a new...
by Tokutek | Oct 9, 2012 | MySQL
Recently, our CTO, Martín Farach-Colton had a chance to talk about scaling MySQL and MariaDB with Roberto Zicari of ODBMS. In the article, Martin states “While I believe that one size fits most, claims that RDBMS can no longer keep up with modern workloads come...
by Tokutek | Oct 4, 2012 | MySQL
Recently, our CEO, John Partridge had a chance to talk about novel database technologies for “Big Data” with Peter Cohan of Forbes. According to the article, “Fractal Tree indexing is helping organizations analyze big data more efficiently due to its...
by Tokutek | Oct 4, 2012 | MySQL
TokuDB® is a proven solution that scales MySQL® and MariaDB® from GBs to TBs with unmatched insert and query speed, compression, replication performance and online schema flexibility. Tokutek’s recently launched TokuDB v6.5 delivers all of these features and...
by Martin.FarachColton | Sep 25, 2012 | MySQL
We are excited to announce TokuDB® v6.5, the latest version of Tokutek’s flagship storage engine for MySQL and MariaDB. This version offers optimization for Flash as well as more hot schema change operations for improved agility. We’ll be posting more...
by Tokutek | Aug 22, 2012 | MySQL
Businesses increasingly operate in a 24×7 environment, where complex analytics must be performed on live, continuously incoming “Big Data.” To address this, TokuDB has developed Fractal Tree® technology, a revolutionary new indexing capability that enables...
by Michael.Bender | Aug 7, 2012 | MySQL
A few weeks ago Bradley Kuszmaul and I attended the Dagstuhl Seminar on Database Workload Management. The Dagstuhl computer science research center is (remotely) located in the countryside in Saarland, Germany. The actual building is an 18th Century Manor House, first...
by Tim.Callaghan | Aug 1, 2012 | MySQL
Benchmarking is a tricky thing, especially when it comes to compression. Some data compresses quite well while other data does not compress at all. Storing jpeg images in a BLOB column produces 0% compression, but storing the string “AAAAAAAAAAAAAAAAAAAA” in a...
by Zardosht.Kasheff | Jul 23, 2012 | MySQL
Three rules on making indexes around queries to provide good performance Application performance often depends on how fast a query can respond and query performance almost always depends on good indexing. So one of the quickest and least expensive ways to increase...
by Rich.Prohaska | Jul 16, 2012 | MySQL
We found a simple XA transaction that crashes MySQL 5.5 replication. This simple transaction inserts a row into an InnoDB table and a TokuDB table. The bug was caused by a flaw in the logging code exposed by the transaction’s use of two XA storage engines (TokuDB and...
by kuszmaul | Jul 9, 2012 | MySQL
Solving the Challenges of Big Databases with MySQL When you’re using MySQL for big data (more than ten times as large as main memory), these challenges often arise: loading data fast; maintaining indexes under insertions deletions, and updates; adding and removing...
by Zardosht.Kasheff | Jul 3, 2012 | MySQL
In my last post, I wrote that I observed many similarities between TokuDB and MySQL Cluster. Many features that benefit TokuDB also benefit MySQL Cluster, and vice versa, with Hot Column Addition and Deletion (HCAD) being an example. Over my next few posts, I expand...