Introduction to Sharding with Jetpants

25 April 11:00am - 11:50am @ Ballroom F

Partitioning your database for the first time can be a rather stressful endeavor. This session provides a walkthrough of how to initially shard your MySQL infrastructure in a more pleasant way by leveraging the Jetpants toolkit. Open sourced by Tumblr in 2012, Jetpants provides easy-to-use automation for managing complex tasks in a partitioned MySQL environment.

We'll start by discussing common strategies such as functional partitioning and range-based sharding, covering a checklist of application requirements and how to avoid common pitfalls. Next, you will learn how to install, configure, and customize Jetpants to integrate it with your site's infrastructure. Finally, I'll explain how to use Jetpants to clone slaves, perform master promotions, and rebalance shards with a single command-line invocation each.

This session is geared towards sharding first-timers, but the material will also be useful for attendees looking to integrate Jetpants into an already-partitioned environment.


Evan Elias
Director of Engineering, Tumblr
Evan is a software engineer and database automation expert based in New York City. He was originally engineer #4 at Tumblr, where he recently returned to direct several backend engineering teams. Previously he was a member of Facebook's MySQL Infrastructure team, where he deployed GTID to the world's largest MySQL fleet, and led development of the company's internal DBaaS platform. He has been using MySQL since 2003, and is the creator of two open source tools: Jetpants, a shard orchestration toolkit; and Skeema, a schema management system.