[asterisk-users] Help Please - Asterisk MYSQL interface seems to be eating data

[Al Baker]

Are you saying the * server does NOT TRY to re-establish the BD connection ?

Does your whole * SERVER freeze ?

If  NOT, what happens to you CDR records ?

Anthony Francis wrote:
> Tilghman Lesher wrote:
>   
>> On Tuesday 06 May 2008 02:16:47 Johansson Olle E wrote:
>>   
>>     
>>> 5 maj 2008 kl. 19.58 skrev Tilghman Lesher:
>>>     
>>>       
>>>> On Monday 05 May 2008 11:24, Johansson Olle E wrote:
>>>>       
>>>>         
>>>>> 5 maj 2008 kl. 17.51 skrev Tilghman Lesher:
>>>>>         
>>>>>           
>>>>>> On Monday 05 May 2008 09:45, Johansson Olle E wrote:
>>>>>>           
>>>>>>             
>>>>>>> Another issue that we need to fix with the MYSQL driver is that
>>>>>>> we're
>>>>>>> lacking a connection pool. Everything seems to be handled over one
>>>>>>> connection to Mysql, which causes issues.
>>>>>>>             
>>>>>>>               
>>>>>> That's not true.  The MYSQL app generally uses multiple connections,
>>>>>> one
>>>>>> for each channel.  The only way one might use only a single
>>>>>> connection is
>>>>>> by using a global variable to store a single connection id, but that
>>>>>> method
>>>>>> is not documented anywhere, AFAIK.
>>>>>>           
>>>>>>             
>>>>> You talk about the Mysql APP, but is this the case with the Realtime
>>>>> driver as well?
>>>>>         
>>>>>           
>>>> No, the native Realtime driver uses a single connection.  The ODBC
>>>> Realtime
>>>> driver generally uses a single connection but can be configured to
>>>> use a
>>>> separate connection for each query.
>>>>       
>>>>         
>>> So, we're back to where we started. A developer that can help us with
>>> a connection
>>> pool or a separate connection for each query would be a Nice Thing (TM).
>>>     
>>>       
>> What issues are you specifically seeing that merit using multiple
>> connections?
>>
>>   
>>     
> I can specify an issue that would merit multiple connections, if the 
> link to your db goes away Asterisk likes to freeze writing CDRs.
> I have a few remote * servers that this happens to. My solution so far 
> has been to record CDR's to a local DB and then have a
> perl script that attempts to move them over to my transaction DB. I 
> would suggest this solution to anyone who depends on their CDR records.
>
>