Hi Percona User group,
I’m trying to access the performance implication of using pt-table-sync tool to replicate a collection of tables from a schema on production server (on load) to a replica schema on the same server. When the pt-table-sync is invoked, does the tool scan through all the data in the source schema and copy to the target schema ?
If yes, it would seem that the tool would create quite a bit of read load on the destination server (if the we have gigantic tables to the order of a TB) to make a copy on the target server ?
Could anyone share their experience in handling the replication scenario’s ?