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:
> To unsubscribe:

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

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