MySQL Forums
Forum List  »  Partitioning

Re: Evolve from Partition to Sharding?
Posted by: John Smith
Date: August 23, 2010 10:18PM

I think my major question is how to move partitions from one database to another.

In my example, when i add a new server, I'd want to move Partition 1, 3, 5, 7, 9, 11 to the new server. And I want to make sure I don't change the auto-increment tweet_id's when moving the tweets.

Do you know how can I move partitions around? I can't really find anything in the manual.

Options: ReplyQuote


Subject
Views
Written By
Posted
3708
August 21, 2010 04:56AM
1668
August 22, 2010 09:02AM
2209
August 23, 2010 12:03AM
1476
August 23, 2010 12:42AM
2318
August 23, 2010 12:48AM
1470
August 23, 2010 09:45PM
Re: Evolve from Partition to Sharding?
1621
August 23, 2010 10:18PM
1661
August 27, 2010 07:41AM


Sorry, you can't reply to this topic. It has been closed.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.