--- title: "Bintrail: MySQL Time-Travel Queries Using Indexed Binlogs" url: https://daily.dev/posts/bintrail-mysql-time-travel-queries-using-indexed-binlogs-h9bqujcgx source_url: https://www.infoq.com/news/2026/05/bintrail-mysql-timetravel type: article source: "InfoQ" published: 2026-05-21T17:09:58.528Z updated: 2026-05-21T17:10:19.913Z tags: ["mysql"] reading_time: 4 upvotes: 3 comments: 0 language: en --- > ## Documentation Index > Fetch the complete documentation index at: https://daily.dev/llms.txt > Use this file to discover all available pages before exploring further. # Bintrail: MySQL Time-Travel Queries Using Indexed Binlogs **[InfoQ](https://daily.dev/sources/infoq)** · 4 min read · 3 upvotes · 0 comments ## Summary Bintrail is a new open-source layer that adds time-travel SQL queries to MySQL — the only major relational database without native temporal querying. It works by parsing MySQL ROW-format binary logs, indexing every row event with before/after images, and routing historical queries (AS OF, BETWEEN) through ProxySQL without modifying MySQL or application code. The system maintains its own indexed history store independent of MySQL binlog retention, supports Parquet archival on S3, and enables point-in-time recovery and audit lookups. Current limitations include support only for literal timestamp queries, primary-key lookups, and capped full-table restores — joins and complex filtering must be handled outside the shim layer. Bintrail is available on GitHub under the BUSL source-available license. ## Full article daily.dev links to this article rather than hosting it. Read it at the original source: ## Similar posts on daily.dev - [Time Travel for Data: Traditional Workarounds vs. the Kurrent Way](https://daily.dev/posts/time-travel-for-data-traditional-workarounds-vs-the-kurrent-way-bt7hnlpdm) · Event Store · 0 upvotes · 0 comments - [Why Relational Databases Fail Satellite Telemetry](https://daily.dev/posts/why-relational-databases-fail-satellite-telemetry-c8bkfdrbo) · InfluxData · 0 upvotes · 0 comments --- Tags: [#mysql](https://daily.dev/tags/mysql) [View this post on daily.dev](https://daily.dev/posts/bintrail-mysql-time-travel-queries-using-indexed-binlogs-h9bqujcgx)