Moving MySQL Data from 1 RDS server to another

Question

How do I go about moving certain data (returned by a simple query) from one database in AWS' RDS to another?

An interruption of up to 20 mins is acceptable, although not preferred.

My current plan is to use Sequel Pro to perform an Export, and then Import it into the target database, but I'm wondering if there's a better way to do it.

BTW: Database is mostly InnoDB and some MyISAM tables.

Answer 1

Your question is far from clear but if I interpret it correctly the simplest method is to use a select into query, which inserts the results of a query into a table, which can then by copied to the target system using dump and load, or replicated as per coredump's suggestion.

Answer 2

Can't you setup replication? It would be the safer/faster way to do it, but I am not sure you can replicate only certain queries (you can do it with specific databases, though)

Answer 3

If they are both MySQL databases then perhaps you could use the federated engine (which facilitates access to databases on remote servers) to update the remote db using a scheduled task to update as often as required.