26 Jun
2019
26 Jun
'19
10:25 a.m.
Originally i had everything being backed by ODBC tables, but could never get the hangs to
stop, usually presenting it self as an inability to auth registrations randomly. I think
i also stumbled upon some hard coded MySQL syntax specific queries in various modules
typically using the MySQL specific REPLACE (upsert) keyword. Getting around the lack of
USE keyword validity in SQL Azure was acheived like i said by specifying on the server
login and user entities rather than in the connection string.
As a result of the random nature of the hangs we re-architected to using intermediate API
for our dynamic data access and for infrequently changing data (dispatcher for example)
generated textdb files, when a change is submitted through the back end. At its simplest
we just set a flag saying file has changed, and poll the api, if the flag is set local
copy is overritten by the downloaded generated file, and the data gets reloaded via
kamcmd. Since having done that all our relational data stays in sql azure, but is never
directly accessed by kamailio, and have not had a single hang like we were experiencing.
Like i said the odd thing was if i pointed the connection string to a local SQL server it
would work perfectly, just undermined our long established SQL Azure consolidation
project...
--
You are receiving this because you are subscribed to this thread.
Reply to this email directly or view it on GitHub:
https://github.com/kamailio/kamailio/issues/1993#issuecomment-505899274