Buffers don't have to be in memory. My suggestion on the solution would be to buffer the CDR info into a backup file based database (configurable filename/path) on the local filesystem (or NFS mounted system for redundancy) and then when the SQL database connection is restored then it spends a second dumping the buffered CDR info from the file into the database and erases the file (or empties it).
This is would be a fairly solid buffering solution. Of course you better get that SQL database back online ASAP or else there is the issue of running on of diskspace on heavily used systems. Just an idea, doesn't seem that hard but I know I don't have time to implement it now. Ryan > Buffer! For how long? How big of a buffer? If I can buffer 10-20 calls > that might work if I have a light use PBX but 100-2000 buffered calls may > not hold a busy PBX. OK so make it configurable, With any luck you won't > know how much to put so you will allocate more than you need, using more > memory for a single senario. > > My solution, make sure your DB is stable. I would rather put my effort in > building a better solution than counting on insurance to bail me out. > > > >> -----Original Message----- >> From: [EMAIL PROTECTED] >> [mailto:[EMAIL PROTECTED] On Behalf Of >> Jean-Michel Hiver >> Sent: Tuesday, January 17, 2006 12:38 PM >> To: Dov Bigio; Asterisk Users Mailing List - Non-Commercial Discussion >> Subject: Re: [Asterisk-Users] asterisk down because of cdr >> >> Dov Bigio a écrit : >> >> >Ok.. but I don't use Real Time at all. >> >I just use cdr_mysql. It would be smarter if it simply ignored MySQL >> >outages or at least just logged, but without stopping. >> > >> > >> What would be even nicer would be for * to buffer it for a >> while before it starts dropping cdrs... >> >> >> _______________________________________________ >> --Bandwidth and Colocation provided by Easynews.com -- >> >> Asterisk-Users mailing list >> To UNSUBSCRIBE or update options visit: >> http://lists.digium.com/mailman/listinfo/asterisk-users >> > _______________________________________________ > --Bandwidth and Colocation provided by Easynews.com -- > > Asterisk-Users mailing list > To UNSUBSCRIBE or update options visit: > http://lists.digium.com/mailman/listinfo/asterisk-users > _______________________________________________ --Bandwidth and Colocation provided by Easynews.com -- Asterisk-Users mailing list To UNSUBSCRIBE or update options visit: http://lists.digium.com/mailman/listinfo/asterisk-users
