We have two production server say Server-A and Server-B.
Server-A is running MySQL 7 and server-B is running as MySQL7
We have running application against both the servers.
We need to sink table in server-A to table in server-b.
I need to run the sink process in the night say after 12:00 AM .
Both servers has the default storage engine as Innodb and OS is Linux.
What can be the best plan and process to complete the task.