<html>
<head>
<meta content="text/html; charset=ISO-8859-1"
http-equiv="Content-Type">
</head>
<body text="#000000" bgcolor="#FFFFFF">
Hello,<br>
<br>
what you can do is to save only in memory (see flag parameter for
save function) and replicate the register requests to a node that
writes to the master database. There will be probably errors after
startup, when loaded records will expire (if they are not updated),
but after that it should stay clean.<br>
<br>
I have discussed with some people that were looking at something
similar, so a new db mode may be contributed soon to do read from db
at startup and then no updates back to db -- there should be another
node taking care of storing in db.<br>
<br>
Cheers,<br>
Daniel<br>
<br>
On 2/18/12 5:11 AM, Spencer Thomason wrote:
<blockquote cite="mid:aa8f1ff3-1dda-4666-8a14-e33156e9ae59@blur"
type="cite">
<style type="text/css">body {word-wrap: break-word; background-color:#ffffff;}</style>
<div style="font-family: sans-serif; font-size: 16px">Hello,<br>
I'm currently working on a HA setup with geographically
separated proxies. Each proxy is in a different data center
with an MPLS link between them. The proxies access a locally
connected PostgreSQL database that is replicated from a master
in the primary data center. Note that the replicated dbs are
read only. Everything works great for read only queries but
registrations seem to pose a problem as they must use the
primary db directly to deal with the writes. If I set userloc
to db mode 2 the secondary proxies wipe out the entries in the
database. If I use db mode 3 everything works great but all of
the secondary proxies must use the primary database directly and
a network link failure will cause a service disruption. Is
there any way I can use separate read and write databases
without p_userloc? Is there a better way to replicate
registrations maintaining availability and scalability? And
advice is appreciated.<br>
<br>
Thanks,<br>
Spencer<br>
<br>
<font face="sans-serif"><span style="font-size: 14px"><i><font
color="#333333">Connected by DROID on Verizon Wireless</font></i></span></font></div>
<br>
<fieldset class="mimeAttachmentHeader"></fieldset>
<br>
<pre wrap="">_______________________________________________
SIP Express Router (SER) and Kamailio (OpenSER) - sr-users mailing list
<a class="moz-txt-link-abbreviated" href="mailto:sr-users@lists.sip-router.org">sr-users@lists.sip-router.org</a>
<a class="moz-txt-link-freetext" href="http://lists.sip-router.org/cgi-bin/mailman/listinfo/sr-users">http://lists.sip-router.org/cgi-bin/mailman/listinfo/sr-users</a>
</pre>
</blockquote>
<br>
<pre class="moz-signature" cols="72">--
Daniel-Constantin Mierla -- <a class="moz-txt-link-freetext" href="http://www.asipto.com">http://www.asipto.com</a>
<a class="moz-txt-link-freetext" href="http://linkedin.com/in/miconda">http://linkedin.com/in/miconda</a> -- <a class="moz-txt-link-freetext" href="http://twitter.com/miconda">http://twitter.com/miconda</a></pre>
</body>
</html>