<html>
<head>
<meta http-equiv="Content-Type" content="text/html; charset=iso-8859-1">
<style type="text/css" style="display:none;"> P {margin-top:0;margin-bottom:0;} </style>
</head>
<body dir="ltr">
<div style="font-family: Calibri, Helvetica, sans-serif; font-size: 12pt; color: rgb(0, 0, 0);">
Hi Daniel,</div>
<div style="font-family: Calibri, Helvetica, sans-serif; font-size: 12pt; color: rgb(0, 0, 0);">
<br>
</div>
<div style="font-family: Calibri, Helvetica, sans-serif; font-size: 12pt; color: rgb(0, 0, 0);">
Thanks for the reply, I will use the server_id method that should work for changes required.</div>
<div style="font-family: Calibri, Helvetica, sans-serif; font-size: 12pt; color: rgb(0, 0, 0);">
<br>
</div>
<div style="font-family: Calibri, Helvetica, sans-serif; font-size: 12pt; color: rgb(0, 0, 0);">
Many thanks!</div>
<div style="font-family: Calibri, Helvetica, sans-serif; font-size: 12pt; color: rgb(0, 0, 0);">
<br>
</div>
<div style="font-family: Calibri, Helvetica, sans-serif; font-size: 12pt; color: rgb(0, 0, 0);">
Jon</div>
<div>
<div id="appendonsend"></div>
<div style="font-family:Calibri,Helvetica,sans-serif; font-size:12pt; color:rgb(0,0,0)">
<br>
</div>
<hr tabindex="-1" style="display:inline-block; width:98%">
<div id="divRplyFwdMsg" dir="ltr"><font face="Calibri, sans-serif" color="#000000" style="font-size:11pt"><b>From:</b> Daniel-Constantin Mierla <miconda@gmail.com><br>
<b>Sent:</b> 19 February 2020 12:28<br>
<b>To:</b> Kamailio (SER) - Users Mailing List <sr-users@lists.kamailio.org>; Jonathan Hunter <hunterj91@hotmail.com>; Kamailio (SER) - Users Mailing List <sr-users@lists.sip-router.org><br>
<b>Subject:</b> Re: [SR-Users] Active-Active Registrar setup with users behind NAT persistence in event of server failure</font>
<div> </div>
</div>
<div>
<p style="margin-top: 0px; margin-bottom: 0px;">Hello,</p>
<p style="margin-top: 0px; margin-bottom: 0px;"><br>
</p>
<p style="margin-top: 0px; margin-bottom: 0px;">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 style="margin-top: 0px; margin-bottom: 0px;"><br>
</p>
<p style="margin-top: 0px; margin-bottom: 0px;">Have you looked at setting the server_id, maybe that can help to have the records grouped by each server.</p>
<p style="margin-top: 0px; margin-bottom: 0px;"><br>
</p>
<p style="margin-top: 0px; margin-bottom: 0px;">Cheers,<br>
Daniel<br>
</p>
<p style="margin-top: 0px; margin-bottom: 0px;"><br>
</p>
<div class="x_moz-cite-prefix">On 19.02.20 09:40, Jonathan Hunter wrote:<br>
</div>
<blockquote type="cite">
<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="x_mimeAttachmentHeader"></fieldset>
<pre class="x_moz-quote-pre">_______________________________________________
Kamailio (SER) - Users Mailing List
<a class="x_moz-txt-link-abbreviated" href="mailto:sr-users@lists.kamailio.org">sr-users@lists.kamailio.org</a>
<a class="x_moz-txt-link-freetext" href="https://eur01.safelinks.protection.outlook.com/?url=https%3A%2F%2Flists.kamailio.org%2Fcgi-bin%2Fmailman%2Flistinfo%2Fsr-users&data=02%7C01%7C%7C35aeb316e5724148274008d7b53738f1%7C84df9e7fe9f640afb435aaaaaaaaaaaa%7C1%7C0%7C637177121086897335&sdata=w9rHzQKqhC2XONZjxAEI5rxxw11NwZyl8JT2lg61BpE%3D&reserved=0" originalsrc="https://lists.kamailio.org/cgi-bin/mailman/listinfo/sr-users" shash="HgXqbecNUsMfeJOq2nKpHdkCyKxtgm6GX/Q4Ww3gPKzbpUEsFafv+z9iF7T+dc48aV6ztuAXRcaSJB1fXZJ27p/ZFZQo3bVLS3kUHW7ihIsyBKT7VNAXShrrJSMdIYIOLjtwuPNJjtxUiwTj93hxx53YhzS+1YCZaQ28/nqilFI=">https://lists.kamailio.org/cgi-bin/mailman/listinfo/sr-users</a>
</pre>
</blockquote>
<pre class="x_moz-signature" cols="72">-- 
Daniel-Constantin Mierla -- <a class="x_moz-txt-link-abbreviated" href="https://eur01.safelinks.protection.outlook.com/?url=http%3A%2F%2Fwww.asipto.com%2F&data=02%7C01%7C%7C35aeb316e5724148274008d7b53738f1%7C84df9e7fe9f640afb435aaaaaaaaaaaa%7C1%7C0%7C637177121086907333&sdata=hFrLqAo2sA5yOqHxkgWwWxO%2F4FdxsAPvBSbOkQvX3Jg%3D&reserved=0" originalsrc="http://www.asipto.com/" shash="T4+WSdQ9mcWDZYfbcb1HC/knH3ZiypI64tMpzZamnGVWEUKbevQvupp1lPIz47NBKjlfyHt11885OcHreN6vY9HH4beXPIaDRixzCrYK5538QO5I5dGYambPoADzOwYGJBZaOTKtxaQByZsAYto74Qbl3xpRqethlcwiJ7Oj0oU=">www.asipto.com</a>
<a class="x_moz-txt-link-abbreviated" href="https://eur01.safelinks.protection.outlook.com/?url=http%3A%2F%2Fwww.twitter.com%2Fmiconda&data=02%7C01%7C%7C35aeb316e5724148274008d7b53738f1%7C84df9e7fe9f640afb435aaaaaaaaaaaa%7C1%7C0%7C637177121086907333&sdata=32OjIMQsM7l3BE6SN4S0F9mrNQ%2ByvqyV2sVJV7MJLgg%3D&reserved=0" originalsrc="http://www.twitter.com/miconda" shash="v7TCfZVjzARcmEndn8mJFt5yM98hm3vL5DZ/S+QxZT2nl3BB0NKETe6ok2fKaGxgJdha79WgB3HFt+b+Fnm2Fo4fxlarXKu+aMiOoZFyzz7/2HBYBsLHzNigODPc2Z9TKmUOThwvCrmYTQ7cKpkMJiS0+EznJ1ltwLOo8HruBMU=">www.twitter.com/miconda</a> -- <a class="x_moz-txt-link-abbreviated" href="https://eur01.safelinks.protection.outlook.com/?url=http%3A%2F%2Fwww.linkedin.com%2Fin%2Fmiconda&data=02%7C01%7C%7C35aeb316e5724148274008d7b53738f1%7C84df9e7fe9f640afb435aaaaaaaaaaaa%7C1%7C0%7C637177121086917328&sdata=wWFKPE8YJdyhBezzI6uDsD8EMYiiDltpTyNWjh1d%2BDE%3D&reserved=0" originalsrc="http://www.linkedin.com/in/miconda" shash="SSiRzvK4AqJxfmfT+c6ZTd+Zjbv73IJgBrbyZKaAYQk7N8U0uNNneX9g7moQZvymLJDJ4O3T3OCCvnF2M4HfB6ncm8btGMCmyRoo1V/fCs5fuN6CY22v+vwXIkE/gURCfFc1ADHkNaM1c9A+b4iQQL36gLoonNLWtdKzYI99mLI=">www.linkedin.com/in/miconda</a>
Kamailio Advanced Training - March 9-11, 2020, Berlin - <a class="x_moz-txt-link-abbreviated" href="https://eur01.safelinks.protection.outlook.com/?url=http%3A%2F%2Fwww.asipto.com%2F&data=02%7C01%7C%7C35aeb316e5724148274008d7b53738f1%7C84df9e7fe9f640afb435aaaaaaaaaaaa%7C1%7C0%7C637177121086927320&sdata=ClIGG7IEw9xt5gD%2BEYzIG6l%2Byyp1kuEeBVXpMfBDSWQ%3D&reserved=0" originalsrc="http://www.asipto.com/" shash="A5W+dw88jU+XAMxztcJHrQB+KBoros3Tau5YcUDYIMLFXK6mU4KYoRGEocQukbBC7PRoWqbY0Bgcu+IYfQ/xgXKO117S+fYOEUPvfkfmcJ340oKX+lZaeywOYYhvJkQu7d8IGRESypsOau98yZo+aBTu9Dkxudr4MdCWi9gyKig=">www.asipto.com</a>
Kamailio World Conference - April 27-29, 2020, in Berlin -- <a class="x_moz-txt-link-abbreviated" href="https://eur01.safelinks.protection.outlook.com/?url=http%3A%2F%2Fwww.kamailioworld.com%2F&data=02%7C01%7C%7C35aeb316e5724148274008d7b53738f1%7C84df9e7fe9f640afb435aaaaaaaaaaaa%7C1%7C0%7C637177121086937316&sdata=Aj8vXwikpl1MKBp6hMkxZBGbxOii1Y87Bc4GoUWbRHw%3D&reserved=0" originalsrc="http://www.kamailioworld.com/" shash="SlUiDhGkP8MemRCXI80HREzeHIEpGmnGD7P4LvE8MzSwE/vp7nCle1JaSchJeQf7X2iswZWd7VMKidvsnBJ1ZlTdpDJG18ZVMu0NlIf9nn9wKarWCxPDf5SiIMuasTDrNtqutmm86dF1CGv0EGOWmzxCO5VwaaImWutNP/nG3BA=">www.kamailioworld.com</a></pre>
</div>
</div>
</body>
</html>