MySQL Online Schema

Every Wednesday, engineers from across Buzzvil’s teams get together to share expertise in areas that interest them and discuss new technologies related to their work. These sessions help us deepen what we already know, learn what we don’t, and bring that knowledge back to our work to make it more efficient and creative.

This Buzzvil Tech Weekly session covered MySQL Online Schema. As new features are added, existing database schemas often need to change. We explored ways to update a schema online without downtime and compared the advantages and disadvantages of each approach. Based on this discussion, we plan to migrate several tables. See the slides below for more details.