Upgrade Your Database without Losing Your Data, Your Perf, or Your Mind

No ratings

Presented at SREcon 2015 by

Upgrading databases can be terrifying and perilous, and for good reason: you can totally screw yourself! Every workload is unique, and standardized test suites will never give you enough information to evaluate how an upgrade will perform for your query set. We will talk about how paranoid you should be about various types of workloads and upgrades, how to balance risk vs. engineering effort, and how to safely execute the most challenging upgrades by capturing and replaying real production workloads. The principles apply to any database, but we’ll go particularly deep into war stories and tooling options for MongoDB and MySQL.