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 columns online; adding indexes online; preventing slave lag; and compressing data effectively.
This session shows why some of these challenges are difficult to solve with storage engines based on B-trees, how Fractal Tree® data structures work, and why they can help solve these problems. Tokutek sells a transaction-safe Fractal Tree storage engine for MySQL, but the presentation is primarily about the underlying technology. It includes a discussion of both the theoretical and practical aspects of Fractal Tree indexes.
I have the privilege of being able to give this talk at both conferences, so please stop by my presentation at whichever conference you plan to attend (or perhaps both, like me!).
- MySQL Connect will run From September 29th to 30th. Details on my talk can be found here. A sampling of the MySQL talks compiled by @stoker can be found here.
- For Percona Live NYC I will be speaking on October 2nd at 1:30 pm in Flatiron. Details can be found here. A sampling of the speakers can be found here.