An open-sourced MySQL PostgreSQL data migration tool in Rust

3 points by supersudo 1 year ago | 2 comments

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

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 1 year 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.