MySQL dump from an unpartitioned, unindexed table into a partitioned, indexed table

Viewed 20

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

0 Answers
Related