MySQL 8.0 Upgrade Journey

Last updated on December 15, 2023

For any developer aware of the complexities involved in database scaling and performance enhancements, the seamless transition of GitHub's production fleet to MySQL 8.0 stands as a testament to meticulous planning and execution. Embark on GitHub's voyage from its inception as a single-database Ruby on Rails application to its contemporary stature, boasting over 1200 MySQL hosts. This case study delves into the high availability strategies, the cutting-edge testing automation, and the partitioning tactics that have fortified GitHub's database resiliency. Whether you're a database aficionado or an infrastructure whiz, this narrative provides invaluable insights into the year-long collaborative upgrade process that preserved the Service Level Objectives (SLO) without a hitch, marking a milestone in database management and operations.