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

[Sebastian Damm]

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?

Best Regards,
Sebastian

On Tue, Oct 21, 2014 at 4:21 PM, Daniel-Constantin Mierla <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 listsr-users at lists.sip-router.orghttp://lists.sip-router.org/cgi-bin/mailman/listinfo/sr-users
>
>
> --
> Daniel-Constantin Mierlahttp://twitter.com/#!/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
> http://lists.sip-router.org/cgi-bin/mailman/listinfo/sr-users
>
>
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.sip-router.org/pipermail/sr-users/attachments/20141022/324fe53b/attachment.html>