MySQL Forums
Forum List  »  Partitioning

Re: Attaching a single partition to MySql on another server
Posted by: Rick James
Date: November 30, 2011 08:07PM

To carry this a step further...
Have the table on the Master be InnoDB, and the table on the Slave be MyISAM.
MyISAM tables can safely be copied as files. (I don't know for sure if a single MyISAM PARTITION can also, but I suspect so.)

Then... Replicate to the slave, copy the old day to tape (or wherever), and optionally drop the old partition.

You could look into InfoBright, which may allow you to keep 10 times as much data in the same disk footprint.

Options: ReplyQuote


Subject
Views
Written By
Posted
Re: Attaching a single partition to MySql on another server
1590
November 30, 2011 08:07PM


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.