Using TokuDB: A Guided Walk Through a TokuDB Implementation

Tools
22 April 9:30am - 12:30pm @ Ballroom D

During the tutorial we're going to review the process of installing a fresh TokuDB instance on a Linux VM and go through some example use cases. We will discuss the details for upgrading from an existing MySQL installation.

We will run several operations and benchmarks to explain the differences between TokuDB and the traditional MySQL engines.

While we will provide a stock VM ready to use based on Ubuntu Server in a USB stick. Attendees will be free to use a Linux distribution of their own as long as the feel comfortable porting any differences with the example we'll provide.

Tutorial will cover the following in detail:

  • TokuDB 101
  • Installation (includes upgrading from existing MySQL/MariaDB)
  • Clustered secondary indexes
  • Compression
  • Reviewing the schema
  • Performant SQL operations at scale
  • Replication performance
  • Agility: hot schema changes
  • Operations on hard disks vs. flash/SSD

Although we will focus on a TokuDB setup, many of the concepts may apply to installing and tuning MySQL / MariaDB from a tarball.

Speakers

Gerardo Narvaja
Dir Technical Services, Tokutek Inc
Biography: 
More than 25 years of experience in the IT industry, most of them around databases. Joined MySQL Inc from 2001 through 2007 and kept involved in the MySQL eco system through my job and a number of projects. Currently the Oursql podcast co-host along with Sheeri Cabral.

Slides