[Asterisk-Users] asterisk down because of cdr

[burke at tailorhosting.com]

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: asterisk-users-bounces at lists.digium.com
>> [mailto:asterisk-users-bounces at lists.digium.com] 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
>