<html>
<head>
<meta http-equiv="Content-Type" content="text/html;
charset=windows-1252">
</head>
<body>
<p>Hello,</p>
<p><br>
</p>
<p>I didn't spent time on understanding the exact issue, but from
database point of view, do you want to avoid having two different
tables for specific reasons, like external applications accessing
it?</p>
<p><br>
</p>
<p>Have you looked at setting the server_id, maybe that can help to
have the records grouped by each server.</p>
<p><br>
</p>
<p>Cheers,<br>
Daniel<br>
</p>
<p><br>
</p>
<div class="moz-cite-prefix">On 19.02.20 09:40, Jonathan Hunter
wrote:<br>
</div>
<blockquote type="cite"
cite="mid:DB6PR0602MB27602A8CA412C15E11B59E00BD100@DB6PR0602MB2760.eurprd06.prod.outlook.com">
<meta http-equiv="Content-Type" content="text/html;
charset=windows-1252">
<style type="text/css" style="display:none;"> P {margin-top:0;margin-bottom:0;} </style>
<div style="font-family: Calibri, Helvetica, sans-serif;
font-size: 12pt; color: rgb(0, 0, 0);">
<span>Hi Guys,<br>
</span>
<div><br>
</div>
<div>I have a quick question wondered if anyone could provide
some suggestions please?!<br>
</div>
<div><br>
</div>
<div>We have a setup of two registrars in EC2 (kamailio 4.4
running on debian VMs) which act in an active/active fashion
with a number of devices<br>
</div>
<div>behind NAT where we use the DMQ dmq_t_replicate function
to send the registration details between each server and
append the PATH parameter<br>
</div>
<div>so the registrar the device registered with is always
associated with the client device.<br>
</div>
<div><br>
</div>
<div>This all works fine, the only issue is persistency should
we have a failure of one of the registrars, be it process or
server and recovering the correct<br>
</div>
<div>PATH detail so the end device can still be reached.<br>
</div>
<div><br>
</div>
<div>I have tried this with separate databases with each
registrar, which works when using cache and db but I ideally
want the same database for the two servers and not<br>
</div>
<div>change the architecture at this time unless it is a
necessary.<br>
</div>
<div><br>
</div>
<div>I have also tested with dmq_usrloc but this again provides
the usrlocation details of the notification servers in the
group(not path), again which I understand but I wondered<br>
</div>
<div>if there is anything else I could try or its just a
question of in the event of a failure half the registrations
will be effected until it recovers and they<br>
</div>
<div>re-register again if I dont want to have separate databases
(location tables) or I add more network elements into the
flow, such as HA pair or load balancer but just want to<br>
</div>
<div>make sure I have exhausted all options or consider the risk
before I look to do this. </div>
<div><br>
</div>
<div>Many thanks!<br>
</div>
<div><br>
</div>
<span>Jon</span><br>
</div>
<br>
<fieldset class="mimeAttachmentHeader"></fieldset>
<pre class="moz-quote-pre" wrap="">_______________________________________________
Kamailio (SER) - Users Mailing List
<a class="moz-txt-link-abbreviated" href="mailto:sr-users@lists.kamailio.org">sr-users@lists.kamailio.org</a>
<a class="moz-txt-link-freetext" href="https://lists.kamailio.org/cgi-bin/mailman/listinfo/sr-users">https://lists.kamailio.org/cgi-bin/mailman/listinfo/sr-users</a>
</pre>
</blockquote>
<pre class="moz-signature" cols="72">--
Daniel-Constantin Mierla -- <a class="moz-txt-link-abbreviated" href="http://www.asipto.com">www.asipto.com</a>
<a class="moz-txt-link-abbreviated" href="http://www.twitter.com/miconda">www.twitter.com/miconda</a> -- <a class="moz-txt-link-abbreviated" href="http://www.linkedin.com/in/miconda">www.linkedin.com/in/miconda</a>
Kamailio Advanced Training - March 9-11, 2020, Berlin - <a class="moz-txt-link-abbreviated" href="http://www.asipto.com">www.asipto.com</a>
Kamailio World Conference - April 27-29, 2020, in Berlin -- <a class="moz-txt-link-abbreviated" href="http://www.kamailioworld.com">www.kamailioworld.com</a></pre>
</body>
</html>