Hacker News new | ask | show | jobs
An open-sourced MySQL PostgreSQL data migration tool in Rust (github.com)
3 points by supersudo 566 days ago
1 comments

Looks similar to Ghostferry, except Ghostferry only supports MySQL and does structure, dump and binlog streaming at the same time.

https://github.com/Shopify/ghostferry

This one seems to only start streaming the binlog after the initial snapshot is imported which makes me wonder if it will miss things.

Thanks for your share of ghostferry.

yes, ape-dts starts streaming the binlog after the initial snapshot, for your concern, there is a way to avoid data loss: https://github.com/apecloud/ape-dts/blob/main/docs/en/tutori...

However, it only works when the table has a primary key or unique key.