Centralized Realtime Database for Queue and endpoints

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.

Please advise.

Resilience would be the big problem. If MySQL supports replication, I would suggest having read only replicates at each site.

1 Like

Hi David! Thanks for quick reply! I have a concern as mentioned in the question. Can you please advise me on that as well.

You really really really don’t want to connect to non-local database servers. Latency and ANY network or problems between your Asterisk and the database server will result in problems. Many operations will block waiting on that remote database, which can then block other things (such as calls).

Thanks Joshua for the reply!

What do you by local and non-local? Do you mean by local is loopback address(localhost) or within same network like two servers in same location of a datacenter?

Ideally as local as possible. Think of it this way - every point of failure you add, every point of latency, decreases how resilient your phone system is. Without a database then Asterisk is your point of failure, add a database and now you have two critical points of failure.

Hi! I installed the server for realtime DB latancy below 1 ms and it’s working great now. I am using Master to Master Mysql Replication to have multiple server for high availabity. It’s working really great.
Thanks Joshua and David! You guys are superheroes of Asterisk World. :smiley:

This topic was automatically closed 30 days after the last reply. New replies are no longer allowed.