An open-sourced MySQL PostgreSQL data migration tool in Rust
1–4 of 4 posts
Re: An open-sourced MySQL PostgreSQL data migration tool in Rust
#2[deleted]
Re: An open-sourced MySQL PostgreSQL data migration tool in Rust
#3Looks 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.
Re: An open-sourced MySQL PostgreSQL data migration tool in Rust
#4Looks 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.