Copy table data from one RDS MySQL server to another RDS MySQL server

I have ten standalone MySQL RDS instances, each with separate credentials and configurations. Here's an example for clarity (dummy credentials provided): Instance ABC:

-none
MySQL Host: abc.dbsjhbns.east-j-rds.amazonaws.com
Username: user1
Password: [REDACTED]
SSH Host: ec2-22-33-22.compute-amazonaws.com
SSH User: ec2
SSH Key: [REDACTED]

Instance DEF:

-none
MySQL Host: def.dbsjhbns.east-j-rds.amazonaws.com
Username: user2
Password: [REDACTED]
SSH Host: ec2-22-33-22.compute-amazonaws.com
SSH User: ec2
SSH Key: [REDACTED]

Both instances have the same schema, called Enterprise, with most tables being identical. My goal is to copy data for a specific table from instance ABC to DEF (and vice versa). ## Solutions I have considered: ### Federated tables While possible, this would require creating federated tables for all tables in both databases, which is inefficient and has its limitations. ### mysqldump This involves exporting data to a .sql file and then importing it into the other instance. While feasible, it's a lengthy process, especially for frequent transfers. ## What I’m Looking For: Are there alternative solutions to efficiently transfer table data between these standalone RDS instances? Are there any third-party tools or best practices that can simplify this process? The data transfer is not very frequent. It might be required once or twice a month or occasionally once or twice a week, depending on the specific need at the time.