I have a MySQL table:
CREATE TABLE tweets ( tweet_id INT NOT NULL AUTO_INCREMENT, author_id INT NOT NULL, text CHAR(140) NOT NULL, PRIMARY KEY (tweet_id) ) ENGINE=InnoDB PARTITION BY HASH(tweet_id) PARTITIONS 12;
How do I move selected partitions from this table to a different machine?
For example, I'd want to move partitions 1, 3, 5, 7, 9, 11 of the above 12 partitions to a different machine. And I'd need to make sure the auto-increment PK "tweet_id" remains unchanged during the migration.
Is there a way to move an entire MySQL partition from one machine to another?