Using TokuDB: A Guided Walk Through a TokuDB Implementation
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
- 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.