DBTrail: Analytical Reports on Your MySQL Data, Without Running Them on MySQL – Part 1

Percona benchmarks DBTrail, an open-source tool (Apache 2.0) built by a former Percona engineer that replicates MySQL data into Parquet files via mydumper and binlog streaming, then lets you query it with DuckDB without installing anything inside MySQL. Testing with sysbench-tpcc (200 warehouses, 300 TPS load) showed negligible impact on the source server except a brief 119ms latency spike during the initial global-lock-protected table copy. Five analytical reports ran in 5.7s total on DuckDB versus 6m35s on MySQL directly. A TPC-H scale factor 10 test showed 22 queries completing in 10.3s on DuckDB versus 5m24s on MySQL, with MySQL only winning one query due to an available index. Part 2 will cover refresh frequency behavior.

Source: https://www.percona.com/blog/dbtrail-analytical-reports-on-your-mysql-data-without-running-them-on-mysql-part-1. 8 Sync News only summarizes and links out; content copyright belongs to the authors and original sources.