[OpenSIPS-Users] MySQL and multiple geographic servers

[Bruce Borrett]

Hi

The purpose/goal of this setup is not load balancing or failover. We are providing pstn termination, so we want to hand calls off to the pstn in each geographic region to reduce the amount of long distance charges... Leased lines are also charged by the distance here, so it would also help to have all clients connecting to a local server.

So to paint a picture, we have region 1 and 2. Each region has a pop with an opensips server and a pstn gateway. Clients from each region register to their local server. 

When client in region 1 wants to call pstn number in region 2, server 1 needs to relay call to server 2 which would hand call to the pstn gateway there, and call would be charged as local. In this case we can just use a pstn route which checks for certain prefixes and forwards to the correct server.

If a pstn user in region 2 calls one of our clients registered to server 1, then server 2 either needs to know that the client is registered with server 1 and relay the call to server 1, or server 2 needs to also have the registration in its location table, and send the call straight to the client. The same will apply when a user registered to server 1 wants to call a user registered to server 2. The solutions I have heard of or thought of for this case are both servers using same mysql database, this will add huge latency to all lookups for either one or both of the servers, or my idea of replicating the database between the 2 servers, apparently this wont work though. Another suggestion I got was to replicate the registration from one server to another...

Any other ideas? Feel free to tell me I have no idea what Im doing, I need to know whether Im on the right path.

Regards,
Bruce






________________________________
From: osiris123d <duane.larson at gmail.com>
To: users at lists.opensips.org
Sent: Mon, 24 May, 2010 20:36:07
Subject: Re: [OpenSIPS-Users] MySQL and multiple geographic servers


Will your clients be behind a firewall?  If so you would need to worry about
the natted devices not being able to recieve SIP messages from the secondary
SIP Proxy if the secondard ever needed to send SIP messages (example: Proxy
Primary is down, so Proxy Secondary takes over)
-- 
View this message in context: http://opensips-open-sip-server.1449251.n2.nabble.com/MySQL-and-multiple-geographic-servers-tp5095071p5095184.html
Sent from the OpenSIPS - Users mailing list archive at Nabble.com.

_______________________________________________
Users mailing list
Users at lists.opensips.org
http://lists.opensips.org/cgi-bin/mailman/listinfo/users



      
-------------- next part --------------
An HTML attachment was scrubbed...
URL: http://lists.opensips.org/pipermail/users/attachments/20100525/8d211bea/attachment.htm