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.

Database Administration
Experience level: 

Schedule info


Schedule Info

2 October 16:00 - 16:50 @


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