Move records to "archive server"?

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=gcdmg-mysql-2@m.gmane.org

Re: Move records to "archive server"?

--0016e6d7e9253476180476441fc0
Content-Type: text/plain; charset=ISO-8859-1

Have a look at the Merge engine.

On Sun, Oct 18, 2009 at 10:31 PM, Allen Fowler 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=vegivamp@tuxera.be
>
>


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

--0016e6d7e9253476180476441fc0--