Best of Infrastructure — December 2023
- 1
- 2
GitHub Blog·2y
Upgrading GitHub.com to MySQL 8.0
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.
- 3
- 4
SitePoint·2y
React Performance Optimization — SitePoint
This article explores various strategies and best practices for React performance optimization. It discusses the goals of React performance optimization, how to identify performance bottlenecks using tools like React Developer Tools and Chrome DevTools, and best practices for using React Profiler. It also covers memoization techniques, state management optimization, lazy loading and code splitting, virtualization techniques, and memoization of expensive computations. The article emphasizes the importance of regular monitoring, profiling, and continuous improvement strategies in optimizing React applications.