ToroDB Stampede: open-source BI connector for MongoDB

on YouTube ↗33m

" summary

ToroDB Stampede is an open-source secondary replica that reads MongoDB oplogs, auto-generates relational schema and writes live relational tables to a downstream RDBMS (Postgres today, experimental MySQL), claiming typical speedups of 100x faster for analytics and reporting versus direct MongoDB or the MongoDB BI Connector. It performs an initial sync then tails the oplog, supports sharded sets, auto-adds nullable columns on schema drift, resolves type conflicts by creating suffixed type columns, and ships under AGPL requiring Java 8 and a Postgres/MySQL backend.

AI-written summary · about

" chapters (9)

1. 0:00Introduction to ToroDB
2. 3:08Architecture and data mapping
3. 7:26Dynamic schema and replication
4. 10:57Performance benchmarks
5. 16:25Data discoverability
6. 18:01Head-to-head comparison
7. 23:14BI tool integration tests
8. 26:59MySQL support announcement
9. 29:08Q&A and conclusion

" related talks

• 01h 04mToroDB: NoSQL & relational Java database with SQL analyticsÁlvaro Hernández · Voxxed Days Bucharest 2016
• 54mBreakout SessionÁlvaro Hernández · PGConf Silicon Valley 2015
• 48mToroDB scaling PostgreSQL like MongoDBÁlvaro Hernández Tortosa · HighLoad++ 2015
• 48mToroDB scaling PostgreSQL like MongoDBÁlvaro Hernández Tortosa · HighLoad++ 2015
• 46mStreaming ETL on the Shoulders of GiantsHans-Peter Grahsl · Voxxed Days Ticino 2019
• 04mDave Stokes Talks Open - Episode 5Peter Farkas · Percona Live 2023
• 42mFrom MongoDB to Postgres: Building an Open Source Standard for Document DatabasesPeter Farkas · Big Data Conference Europe 2025
• 14mBuild your data lakehouse with Starburst GalaxyMonica Miller · AWS re:Invent 2022