An open-sourced MySQL PostgreSQL data migration tool in Rust

Posted by supersudo on Thursday December 05, 2024 @02:59AM
from the github.com dept.

( 2 comments | on HN )

Re:An open-sourced MySQL PostgreSQL data migration tool in Rust by ChocolateGod on Thursday December 05, 2024 @04:27AM (#42326467)

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.

[ Parent | on HN ]

Re:An open-sourced MySQL PostgreSQL data migration tool in Rust by chenglingsu2019 on Thursday December 05, 2024 @08:23AM (#42327981)

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.

[ Parent | on HN ]