4 ms·
An open-sourced MySQL PostgreSQL data migration tool in Rust
- deleted 2y ago[deleted]
- ChocolateGod 2y agoLooks similar to Ghostferry, except Ghostferry only supports MySQL and does structure, dump and binlog streaming at the same time. https://github.com/Shopify/ghostferry 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.
- chenglingsu2019 2y agoThanks 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/tutorial/snapshot_and_cdc_without_data_loss.md 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.