Move records to archive server?

2009-10-18 Thread Allen Fowler
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

Queue / FIFO in MySQL?

2009-09-07 Thread Allen Fowler
Hello, I need to create a system where records are generated by a producer process and processed by several worker processes. I was thinking about something like: Producer: 1) Producer INSERTs new records with state = new worker = null 2) Producer sleeps and loops back to step #1 Worker(s):