Test Your MySQL 8.4 Upgrade With Real App Queries

Proxymock is presented as a tool for capturing an application’s real HTTP and MySQL traffic and reusing one recording for mocked application checks, MySQL upgrade regression tests, and concurrent database load tests. The guide focuses on moving from MySQL 8.0, which entered Oracle Sustaining Support in April 2026, to MySQL 8.4 LTS, highlighting compatibility risks such as authentication defaults, reserved keywords, removed statements, and changed InnoDB behavior. Using a Docker-based Go users-and-orders demo, it records prepared statements, transactions, and their parameters, then first verifies that the application can run against mocked MySQL traffic without a database. It next reverses the replay direction so captured outbound MySQL statements test a real database, demonstrating a clean replay against MySQL 8.4 and a failed replay after a referenced column is renamed, with MySQL error details identifying the incompatibility. The same recording can be load tested through multiple persistent MySQL sessions, where replay-specific duplicate values can be regenerated with extractors and real concurrency problems, such as checkout deadlocks, can expose needed application changes. The guide also covers reviewing saved runs in the local web viewer or Speedscale dashboard, credential and TLS handling, and limitations including the need for disposable databases, state alignment with the original recording, and incomplete support for some MySQL protocol features.

Use this post, company, and trend context to find content marketing opportunities, perform competitive analysis, or address product feature gaps via the Plushcap MCP server or the Plushcap API.