BEYOND SYNTHETIC TESTING: CAPTURING AND REPLAYING REAL DATABASE WORKLOADS AT AIRBNB

Summary from the TLDR Dev newsletter

Airbnb captures MySQL traffic at ProxySQL, rebuilds transaction order offline, and replays production workloads for load testing, migration checks, and performance debugging. The system exposed upgrade regressions such as a query rising from 0.03 to 2.6 seconds and helped move the fleet from MySQL 5.7 to 8.0 without a major production incident.