There is a query and a concern.
Query: I have multiple asterisk server using realtime database for Queue and SIP Peers separatly. I am thinking to centralised the realtime database for evey server using the table tables. Can one please suggest what could be some pitfalls and problem could occure in production?
Concern: I am setting up the realtime centralised database between two servers.
Location of DB server: Canada
Location of Asterisk Server1 : Canada
Location of Asterisk Server2: France
Asterisk Server1 and DB server are able connect successfully and running perfectly.
But when I am connecting Server2 and DB Server. The odbc connection(res_odbc) and mysql(res_config_mysql) both are connected but when I run commond “queue show” the result never get showed up in the asterisk cli and after 1 minute the asterisk gets crashed. But If I run “queue show any_queue_name” the queue does get showed up but with a bit delay. My guessed problem could be latancy.