PulseAugur
EN
LIVE 08:29:22

GitHub upgrades 1,200 MySQL hosts without downtime

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.

RANK_REASON Major infrastructure upgrade by a prominent tech company impacting a core service. [lever_c_demoted from significant: ic=1 ai=0.1]

Read on Towards AI →

AI-generated summary · Google Gemini · from 1 sources. How we write summaries →

GitHub upgrades 1,200 MySQL hosts without downtime

COVERAGE [1]

  1. Towards AI TIER_1 English(EN) · TechLogStack ·

    How GitHub Upgraded 1,200 MySQL Hosts Without Dropping a Single Query

    <h4><em>The year-long plan to migrate 300 terabytes of data and 5.5 million queries per second off an end-of-life database — without a single maintenance window.</em></h4><figure><img alt="" src="https://cdn-images-1.medium.com/max/666/1*8utvY8gABJoNQvHnya3sNw.png" /></figure><p>…