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

Summary from the TLDR DevOps newsletter

Airbnb captures production SQL traffic at ProxySQL and reconstructs transaction order and timing for controlled replay against test databases. The system supports capacity planning and upgrade comparisons, uncovering MySQL 8.0 performance regressions and queries whose results depended on unspecified row ordering.