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.
2 October 16:00 - 16:50 @
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.