We have a cron job that moves master.csv to subdir/<timestamp>.csv and then tries to parse and delete all csvs in that directory. The reasons we did this were
1) We wanted to store more data in the database without having to change source code. For example, we have 45 asterisk servers writing to one cdr database so it's nice to have a field in the database telling us which server input that row. 2) Our database server is in another office so when the network goes down or there is a power outage somewhere, we no longer have this huge one point of failure for all of our remote phone servers. The csvs just keep piling up until a valid connection to the database can be restored. To my knowledge asterisk doesn't keep master.csv open between writes and when we've moved it we never had a problem. Asterisk simply creates a new master.csv the next time a write occurs. > -----Original Message----- > From: [EMAIL PROTECTED] > [mailto:[EMAIL PROTECTED] Behalf Of Senad > Jordanovic > Sent: Friday, November 14, 2003 12:44 PM > To: [EMAIL PROTECTED] > Subject: RE: [Asterisk-Users] Your thoughts.. > > > Funny, I am doing the same at the moment... :) > > We are allowing * to dump call records onto a remote database server. > Once there we can do all sort of things with it. > > My only concern is if this remote server goes down! What happens to the > call records which were not written to remote server? The records could > be written to * server as well, but that is extra CPU cycles to waste. > > Ta > > SJ > > > > _______________________________________________ > Asterisk-Users mailing list > [EMAIL PROTECTED] > http://lists.digium.com/mailman/listinfo/asterisk-users > > _______________________________________________ Asterisk-Users mailing list [EMAIL PROTECTED] http://lists.digium.com/mailman/listinfo/asterisk-users
