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.
