An open-sourced MySQL PostgreSQL data migration tool in Rust (github.com) 3 points by supersudo 1y ago ↗ HN
[–] ChocolateGod 1y ago ↗ Looks similar to Ghostferry, except Ghostferry only supports MySQL and does structure, dump and binlog streaming at the same time.https://github.com/Shopify/ghostferryThis one seems to only start streaming the binlog after the initial snapshot is imported which makes me wonder if it will miss things. [–] chenglingsu2019 1y ago ↗ 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.
[–] chenglingsu2019 1y ago ↗ 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.
3 comments
[ 2.6 ms ] story [ 32.1 ms ] threadhttps://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.
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.