GitHub has just shared details about their strategy for upgrading over 1200 of their MySQL servers to version 8.0. The world's largest software repository, developed from the beginning using Ruby on Rails, has been using MySQL as its database. After years of using version 5.x, they successfully completed the upgrade to MySQL 8, and they narrate the process in their blog.
As an overview, GitHub's MySQL instances, totaling over 1200, are distributed across Azure data centers and bare metal in their own data center. In total, they handle 300 TB of data and serve 5.5 million queries per second across more than 50 database clusters.
For those interested in learning more about their upgrade process, please read their blog post here.
