How GitHub Upgraded 1,200 MySQL Hosts Without Dropping a Single Query
GitHub successfully upgraded over 1,200 MySQL hosts from version 5.7 to 8.0, migrating 300 terabytes of data and handling 5.5 million queries per second without any downtime. The year-long project involved meticulous planning, including developing a robust rollback strategy and addressing compatibility issues like default collation changes and role management syntax that broke replication between the old and new versions. The team ensured a seamless transition for their 100 million developers by upgrading each of the 50+ independent database clusters individually. AI
IMPACT Minimal direct impact on AI operations; focuses on database infrastructure.