List:General Discussion« Previous MessageNext Message »
From:Johan De Meersman Date:October 19 2009 6:47am
Subject:Re: Move records to "archive server"?
View as plain text  
Have a look at the Merge engine.

On Sun, Oct 18, 2009 at 10:31 PM, Allen Fowler <allen.fowler@stripped>wrote:

> Hello,
>
> I have a Python application that is using MySQL to store records of
> transactions....  about 3 tables with ~1k records each.
>
> How can I periodically copy the records off the production on to an
> "archive server"?  I would like to this for two reasons:
>
> 1) To run data-mining queries on a copy of the live dataset without the
> risk of overloading the production server.
> 2) To maintain an addional set of "historical tables" that contain all the
> records the system has ever had, even after they are dropped from the "live"
> tables.
>
> How should I go about doing this?
>
> Thank you,
> :)
>
>
>
>
>
> --
> MySQL General Mailing List
> For list archives: http://lists.mysql.com/mysql
> To unsubscribe:    http://lists.mysql.com/mysql?unsub=1
>
>


-- 
That which does not kill you was simply not permitted to do so for the
purposes of the plot.

Thread
Move records to "archive server"?Allen Fowler18 Oct
  • Re: Move records to "archive server"?Johan De Meersman19 Oct