[SR-Users] Asynchronous sql operation also for acc module?

[Daniel-Constantin Mierla]

Hi Sebastian,

On 22/10/14 08:36, Sebastian Damm wrote:
> Hi Daniel,
>
> thanks for the explanation and blog post. However, this is a different
> approach than the asynchronous sqlops function, right? In sqlops, the
> request is sent to an asynchronous worker in Kamailio and does the SQL
> operation when possible. In acc, only the request is a different one.
> And if the MySQL server really has a problem, it can happen that it
> doesn't return from the an INSERT DELAYED query immediately. If the
> MySQL query is not detached from the SIP worker, the problem of a
> blocking SIP proxy is still there. Is it possible to use the
> asynchronous worker for the acc requests, too?
the are two kind of operations that can be enabled for acc: insert
delayed is done when db_insert_mode=1, async insert is done when
db_insert_mode=2.

async insert is done via an asynchronous worker, same mechanism as for
sql_query_async() -- in other words, the insert query to db is not
executed by the sip worker.

Cheers,
Daniel

>
> Best Regards,
> Sebastian
>
> On Tue, Oct 21, 2014 at 4:21 PM, Daniel-Constantin Mierla
> <miconda at gmail.com <mailto:miconda at gmail.com>> wrote:
>
>     Hello,
>
>     it is possible, with same limitation that the database connector
>     module needs to support async operation -- see db_insert_mode
>     parameter for acc module.
>
>     And because was asked, I added it to the blogs list as well:
>     -
>     http://by-miconda.blogspot.de/2014/10/kamailio-42-tips-8-asynchronous.html
>
>     Cheers,
>     Daniel
>
>
>     On 21/10/14 11:06, Sebastian Damm wrote:
>>     Hi,
>>
>>     I read the article about asynchronous sqlops:
>>     http://by-miconda.blogspot.de/2014/10/kamailio-42-tips-4-asynchronous-sql.html
>>
>>     I was wondering whether there are any plans of bringing that
>>     feature to the acc module, too. We have seen it in the past that
>>     a blocking database server brought our proxy to a halt because
>>     the acc module was blocking, too. So this could help a lot if the
>>     acc entries were written asynchronously.
>>
>>     Best Regards,
>>     Sebastian
>>
>>
>>     _______________________________________________
>>     SIP Express Router (SER) and Kamailio (OpenSER) - sr-users mailing list
>>     sr-users at lists.sip-router.org <mailto:sr-users at lists.sip-router.org>
>>     http://lists.sip-router.org/cgi-bin/mailman/listinfo/sr-users
>
>     -- 
>     Daniel-Constantin Mierla
>     http://twitter.com/#!/miconda <http://twitter.com/#%21/miconda> - http://www.linkedin.com/in/miconda
>
>
>     _______________________________________________
>     SIP Express Router (SER) and Kamailio (OpenSER) - sr-users mailing
>     list
>     sr-users at lists.sip-router.org <mailto:sr-users at lists.sip-router.org>
>     http://lists.sip-router.org/cgi-bin/mailman/listinfo/sr-users
>
>
>
>
> _______________________________________________
> SIP Express Router (SER) and Kamailio (OpenSER) - sr-users mailing list
> sr-users at lists.sip-router.org
> http://lists.sip-router.org/cgi-bin/mailman/listinfo/sr-users

-- 
Daniel-Constantin Mierla
http://twitter.com/#!/miconda - http://www.linkedin.com/in/miconda

-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.sip-router.org/pipermail/sr-users/attachments/20141022/3e69aad5/attachment.html>