Zero-downtime Schema Changes

Schema changes on live systems are hard. They are inherently disruptive in Mysql. We at Etsy have devised a way to make schema changes in a non-disruptive way, and we routinely perform them without any user-facing impact. I will give a brief description of our Mysql architecture, followed by a fairly detailed walk-through of our schema changes procedures. Finally, I will present the tooling we've built around our schema changes procedures: our Schemanator tool.

Track: 
Database Administration
Experience level: 
Intermediate

Schedule info

Room: 
Nolita

Schedule Info

2 October 16:00 - 16:50 @
Nolita

Speakers

Arie Kachler's picture
Sr. MySQL Operations Engineer, Etsy

Arie Kachler has worked with Mysql for over a decade now. He joined Etsy in Nov. 2011 and oversees Etsy's large Mysql infrastructure. He has been working on web technology companies for over 16 years, including The New York Times.


Sponsored By