GitHub upgraded its fleet of 1200+ MySQL hosts to MySQL 8.0 over the course of a year. The upgrade was motivated by the end of life of MySQL 5.7, the desire for the latest features and security patches, and the need to maintain service level objectives. GitHub prepared for the upgrade by determining infrastructure requirements, ensuring application compatibility, and communicating the upgrade plan. During the upgrade process, challenges such as replication delay and query failures were encountered and addressed. The lessons learned from the upgrade will inform future upgrade processes.
Table of contents
Motivation for upgradingGitHub’s MySQL infrastructurePreparing the journeyUpgrade planAbility to RollbackChallengesLearnings and takeawaysConclusionSort: