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 cop

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