Re: BULK DATA HANDLING 0.5TB

2009-06-13 Thread Martijn Engler
My first thought was: Archive Storage Engine; http://dev.mysql.com/doc/refman/5.0/en/archive-storage-engine.html But then I read fetch the result, so you're not only inserting data, but also doing some queries on it? Can you show the queries and your model? On Sat, Jun 13, 2009 at 07:40, Krishna

rubyrep - database replication made easy

2009-06-13 Thread Arndt Lehmann
This is the first public announcement of rubyrep, an open source software for asynchronous, master-master replication of relational databases. It has been designed for - database independence (currently supported: PostgreSQL and MySQL) - being ridiculously easy to use Getting from zero to

Re: BULK DATA HANDLING 0.5TB

2009-06-13 Thread steve
At 11:10 AM +0530 6/13/09, Krishna Chandra Prajapati wrote: Hi guys, I'm working in a telecom company. I have table called deliverylog in which 30 million records gets inserted per/day. The table has grown to 0.5TB I have to keep 60days record in the table. So, 60days * 30 million = 1800 million