I have 2 RDS instances (MySQL).
RDS1 - lots of data; no partitions; no indexes
RDS2 - less data; partitioned; indexed
I need a sensible way to do a daily load between the two servers. It's 49GB per day.
I have done this in Python and Apache Spark and it works, but it can be very slow.
Is there a way we can MySQL dump from an unpartitioned, unindexed table into a partitioned, indexed table (with the same column count)?
Thanks