<html><head><meta http-equiv="content-type" content="text/html; charset=utf-8"></head><body dir="auto"><div>Hi Matthew</div><div id="AppleMailSignature"><br></div><div id="AppleMailSignature">I'm about to attempt the same. And notes/corrected db schemes you got would be much appreciated!<br><br>Joe Waite</div><div><br>On 13 Jul 2017, at 17:25, Matthew Nichols <<a href="mailto:matt.nichols@westtel.com">matt.nichols@westtel.com</a>> wrote:<br><br></div><blockquote type="cite"><div>
<meta http-equiv="Content-Type" content="text/html; charset=us-ascii">
<meta name="Generator" content="Microsoft Word 15 (filtered medium)">
<style><!--
/* Font Definitions */
@font-face
{font-family:"Cambria Math";
panose-1:2 4 5 3 5 4 6 3 2 4;}
@font-face
{font-family:Calibri;
panose-1:2 15 5 2 2 2 4 3 2 4;}
@font-face
{font-family:"Century Gothic";
panose-1:2 11 5 2 2 2 2 2 2 4;}
/* Style Definitions */
p.MsoNormal, li.MsoNormal, div.MsoNormal
{margin:0in;
margin-bottom:.0001pt;
font-size:11.0pt;
font-family:"Calibri",sans-serif;}
a:link, span.MsoHyperlink
{mso-style-priority:99;
color:#0563C1;
text-decoration:underline;}
a:visited, span.MsoHyperlinkFollowed
{mso-style-priority:99;
color:#954F72;
text-decoration:underline;}
span.EmailStyle17
{mso-style-type:personal-compose;
font-family:"Century Gothic",sans-serif;
color:windowtext;}
.MsoChpDefault
{mso-style-type:export-only;
font-family:"Calibri",sans-serif;}
@page WordSection1
{size:8.5in 11.0in;
margin:1.0in 1.0in 1.0in 1.0in;}
div.WordSection1
{page:WordSection1;}
--></style><!--[if gte mso 9]><xml>
<o:shapedefaults v:ext="edit" spidmax="1026" />
</xml><![endif]--><!--[if gte mso 9]><xml>
<o:shapelayout v:ext="edit">
<o:idmap v:ext="edit" data="1" />
</o:shapelayout></xml><![endif]-->
<div class="WordSection1">
<p class="MsoNormal"><span style="font-family:"Century Gothic",sans-serif">After going through
<a href="https://freeswitch.org/confluence/display/FREESWITCH/High+Availability">
https://freeswitch.org/confluence/display/FREESWITCH/High+Availability</a>, it appears out of date/misleading. Here are the things I have found:<o:p></o:p></span></p>
<p class="MsoNormal"><span style="font-family:"Century Gothic",sans-serif"><o:p> </o:p></span></p>
<p class="MsoNormal"><span style="font-family:"Century Gothic",sans-serif">Switchname needs to be different or they end up clobbering each other. Call recovery still works.<o:p></o:p></span></p>
<p class="MsoNormal"><span style="font-family:"Century Gothic",sans-serif"><o:p> </o:p></span></p>
<p class="MsoNormal"><span style="font-family:"Century Gothic",sans-serif">$${domain} needs to be set the same on both boxes for voicemails and registrations to work well after recovery.<o:p></o:p></span></p>
<p class="MsoNormal"><span style="font-family:"Century Gothic",sans-serif"><o:p> </o:p></span></p>
<p class="MsoNormal"><span style="font-family:"Century Gothic",sans-serif">As far as I can tell the entirety of /var/lib/freeswitch can be shared with something like GlusterFS (assuming sqlite is not being used).<o:p></o:p></span></p>
<p class="MsoNormal"><span style="font-family:"Century Gothic",sans-serif"><o:p> </o:p></span></p>
<p class="MsoNormal"><span style="font-family:"Century Gothic",sans-serif">Especially with PostgreSQL BDR auto-create-sql needs to be false and auto-clear-sql needs to be true, otherwise information is never cleared after a crash.<o:p></o:p></span></p>
<p class="MsoNormal"><span style="font-family:"Century Gothic",sans-serif"><o:p> </o:p></span></p>
<p class="MsoNormal"><span style="font-family:"Century Gothic",sans-serif">Also I see no documentation on the wiki on actually using FreeSWITCH with PostgreSQL BDR. I would be willing to start a page with what I have discovered so far. The only online documentation
I have found is <a href="https://gist.github.com/DigiDaz/1cfe3d5d32080a8e3d75a20bb5bc4fb5">
https://gist.github.com/DigiDaz/1cfe3d5d32080a8e3d75a20bb5bc4fb5</a>, which doesn’t have the primary keys set up quite right (calls and channels need to add hostname to the primary key or call recovery doesn’t work quite right) and doesn’t include voicemail.<o:p></o:p></span></p>
<p class="MsoNormal"><span style="font-family:"Century Gothic",sans-serif"><o:p> </o:p></span></p>
<p class="MsoNormal"><span style="font-family:"Century Gothic",sans-serif">I am very willing to setup the required edits but I don’t have write access so I would need to go through one of you who does.<o:p></o:p></span></p>
<p class="MsoNormal"><span style="font-family:"Century Gothic",sans-serif"><o:p> </o:p></span></p>
<p class="MsoNormal"><span style="font-family:"Century Gothic",sans-serif">Matthew Nichols
<o:p></o:p></span></p>
<p class="MsoNormal"><o:p> </o:p></p>
</div>
</div></blockquote><blockquote type="cite"><div><Matthew Nichols.vcf></div></blockquote><blockquote type="cite"><div><span>_________________________________________________________________________</span><br><span>Professional FreeSWITCH Consulting Services:</span><br><span><a href="mailto:consulting@freeswitch.org">consulting@freeswitch.org</a></span><br><span><a href="http://www.freeswitchsolutions.com">http://www.freeswitchsolutions.com</a></span><br><span></span><br><span>Official FreeSWITCH Sites</span><br><span><a href="http://www.freeswitch.org">http://www.freeswitch.org</a></span><br><span><a href="http://confluence.freeswitch.org">http://confluence.freeswitch.org</a></span><br><span><a href="http://www.cluecon.com">http://www.cluecon.com</a></span><br><span></span><br><span>FreeSWITCH-users mailing list</span><br><span><a href="mailto:FreeSWITCH-users@lists.freeswitch.org">FreeSWITCH-users@lists.freeswitch.org</a></span><br><span><a href="http://lists.freeswitch.org/mailman/listinfo/freeswitch-users">http://lists.freeswitch.org/mailman/listinfo/freeswitch-users</a></span><br><span>UNSUBSCRIBE:http://<a href="http://lists.freeswitch.org/mailman/options/freeswitch-users">lists.freeswitch.org/mailman/options/freeswitch-users</a></span><br><span><a href="http://www.freeswitch.org">http://www.freeswitch.org</a></span></div></blockquote></body></html>