It is a common use case to synchronize data in two tables inside MySQL servers. This blog post describes one specific case: how to synchronize data between two different tables on the same MySQL server. This could be useful, for example, if you test DML query performance and do not want to affect production data. [&]

https://www.percona.com/blog/synchronize-tables-on-the-same-server-with-pt-table-sync/