Managing large MySQL installations with Jetpants

Tools

2 April 11:30AM - 12:20PM @ Ballroom A

Experience level:

Intermediate

Duration:

50 minutes conference

Jetpants provides an automation framework for managing large sharded MySQL installations. In addition to providing support for shard splits and merges, there is oft-overlooked tooling for concurrent operations across entire database topologies. Some examples include determining the aggregate size of your data set across all shards and/or functional partitions, determining global min and max values in real time, concurrently performing upgrades on non-production-facing servers, and extracting subsets of data in parallel. We'll examine the some of the building blocks that power these operations as well as take a look at some practical examples.