An analytical replica for MySQL, on Oracle’s HeatWave benchmark
We ran Oracle's HeatWave benchmark on DBTrail's analytical replica: 12x more analytic queries a minute, and a faster MySQL.
We ran Oracle's HeatWave benchmark on DBTrail's analytical replica: 12x more analytic queries a minute, and a faster MySQL.
The 2020 post, rewritten for ProxySQL 3.0 and MySQL 8.4. Not only whether to throttle, but which writes to throttle.
MySQL was the only major OLTP database without time-travel queries. Here is how that gap closes, with no fork and no ALTER TABLE storm.