3 ms·
> I also strongly suspect it would be substantially harder to build something like Wormhole on top of Postgres replication. Why's that? It seems like there's
by anarazel 10y ago
> I also strongly suspect it would be substantially harder to build something like Wormhole on top of Postgres replication.
Why's that? It seems like there's all the infrastructure needed for that?
- evgen 10y agoWormhole relied on smart propagation of MySQL binary logs iirc. Postgres lacks this and the WAL would probably not work in the same way.
- anarazel 10y agohttps://www.postgresql.org/docs/current/static/logicaldecoding.html https://www.postgresql.org/docs/current/static/logicaldecodi...
- evanelias 10y agoMySQL uses logical replication, and traditionally this is statement-based logical replication -- log of raw SQL write queries, including arbitrary SQL comments embedded, which can be used for any purpose. I'm not sure if Postgres has something similar? (entirely possible it does, if so I retract my earlier comment!)