From: Johan De Meersman Date: October 19 2009 6:47am Subject: Re: Move records to "archive server"? List-Archive: http://lists.mysql.com/mysql/219093 Message-Id: MIME-Version: 1.0 Content-Type: multipart/alternative; boundary=0016e6d7e9253476180476441fc0 --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@stripped > > -- That which does not kill you was simply not permitted to do so for the purposes of the plot. --0016e6d7e9253476180476441fc0--