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.
Tag
featured
Introducing the MySQL Analytical Replica (Parquet + DuckDB)
Your reports run on your production MySQL. DBTrail keeps a copy of your tables as Parquet files and lets you query it with DuckDB.
Everyone Records the MySQL Audit Log. Nobody Reads It.
Almost nobody reads the audit log, because reading it is painful. There is a cheaper shape: keep the answer, not the log.
MySQL 8.0 to 8.4 upgrade on RDS: how to prove your data survived
The upgrade to 8.4 takes minutes and there is no way back. How I checked, on a real RDS instance, that it did not change a…
Time-travel for PostgreSQL: one SELECT vs a full restore vs replaying the WAL
PostgreSQL can now tell you what a row contained at any past moment, with a normal SELECT. One example, against restore and WAL replay.