Hello,
I have several servers runing 11.6-cert1 all of them, using mysql realtime in remote location.
My issue, is the US servers, who have less then 50ms latency to the SQL work fine… But European servers, withing more then 70-90ms lantecy to the SQL are failing in handle traffic, where calls are expiring in the invite, meanwhile asterisk still quaring the SQL to check authentication, and other quaries. It’s being harmless… I was crazy turning, until I got identified that.
My issue, is in all servers, I do local SQL replication, so, if I test to connect Asterisk to the local SQL, it’s working with no issue, but when do it to the remote, it’s failing as described…
As far as I understand, i can’t do use the local replication, as in the replica I may do select, show, but can’t do insert/update, as asterisk authenticaion will require this to update peers registrations.
So, my question is:
- I have tried to play with the dealplan to let the caller waiting meanwhile asterisk is quaring the DB, but it’s not working, as it’s deling in the authentication quaries, I’m not sure if i set got the waitng, or if there any other solution:
[quote]exten => s,1,Wait(30)
exten => s,2,Answer[/quote]
2) Dose there any other option to increase the dialog time, or decrease the sql quaries, or at least, can I descriminate the quaries, where do the show in the local replication, and the insert/update to go through the remote DB, so I save time??
I’m sorry I have put wrong title, but, even, I’m confused how is the situation, but this is my diagnostic.
Regards,