DuckDB 2.0 on a MySQL analytical replica: what we measured
DuckDB 2.0 runs our heaviest analytical queries up to 44% faster. Some mid-size joins got slower, so we found why and reported it to the DuckDB…
Tag
duckdb
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.
InnoDB for the fast. DuckDB for the heavy. Same connection for both.
Use InnoDB and DuckDB at the same time, on the MySQL you already run. Reports ran 10 times faster. Open source, no migration, no DuckDB to…
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.