<html><head></head><body><p dir="ltr">Replicating all DB tables between all FS nodes would eventually require to setup switchname all the same like using one common shared DB. </p>
<p dir="ltr">But just synching all tables will make each FS node to update its clients presence with others?</p>
<p dir="ltr">My understanding is that the presence update process starts with a client sip event, like register, which turns the FS to send presence updates to its subscribers, and finally to update the sip_presence table. <br>
So just updating the DB tables with other clients presence status will not trigger the FS to send presence updates.<br><br><br></p>
<div class="gmail_quote" >On Jul 6, 2016, at 18:04, Luis Daniel Lucio Quiroz <<a href="mailto:luis.daniel.lucio@gmail.com" target="_blank">luis.daniel.lucio@gmail.com</a>> wrote:<blockquote class="gmail_quote" style="margin: 0pt 0pt 0pt 0.8ex; border-left: 1px solid rgb(204, 204, 204); padding-left: 1ex;">
<div dir="ltr">
Easy, put your MariaDb in master-master replication mode (update to maria, mysql wont be useful)
<div>
Here is a little how to
</div>
<div>
<br>
</div>
<div>
<a href="http://inside-out.xyz/technology/how-to-configure-mariadb-synchronous-replication.html">http://inside-out.xyz/technology/how-to-configure-mariadb-synchronous-replication.html</a>
<br>
</div>
</div>
<div class="gmail_extra">
<br clear="all">
<div>
<div class="gmail_signature" data-smartmail="gmail_signature">
<div dir="ltr">
<div>
--
</div>
<div>
Luis Daniel Lucio Quiroz
<br>CISSP, CISM, CISA
<br>Linux, VoIP and much more fun
<br>
<a href="http://www.okay.com.mx" target="_blank">www.okay.com.mx</a>
<br>
<br>Need LCR? Check out LCR for FusionPBX with FreeSWITCH
<br>Need Billing? Check out Billing for FusionPBX with FreeSWITCH
</div>
</div>
</div>
</div>
<br>
<div class="gmail_quote">
2016-07-06 9:57 GMT-04:00 Assaf Dahary
<span dir="ltr"><<a href="mailto:adahary@gmail.com" target="_blank">adahary@gmail.com</a>></span>:
<br>
<blockquote class="gmail_quote" style="margin:0 0 0 .8ex;border-left:1px #ccc solid;padding-left:1ex">
<div lang="EN-US" link="blue" vlink="purple">
<div>
<div>
<p class="MsoNormal"><span style="font-size:11.0pt;font-family:"Calibri","sans-serif";color:#1f497d">Hi,<u></u><u></u></span></p>
<p class="MsoNormal"><span style="font-size:11.0pt;font-family:"Calibri","sans-serif";color:#1f497d"><u></u> <u></u></span></p>
<p class="MsoNormal"><span style="font-size:11.0pt;font-family:"Calibri","sans-serif";color:#1f497d">I have multiple FS nodes where each of them maintains locally its own MySql DB/tables (created automatically on FS installation with dsn setup).<u></u><u></u></span></p>
<p class="MsoNormal"><span style="font-size:11.0pt;font-family:"Calibri","sans-serif";color:#1f497d"><u></u> <u></u></span></p>
<p class="MsoNormal"><span style="font-size:11.0pt;font-family:"Calibri","sans-serif";color:#1f497d">Now I'm looking for a way to share clients presence between the FS nodes.<u></u><u></u></span></p>
<p class="MsoNormal"><span style="font-size:11.0pt;font-family:"Calibri","sans-serif";color:#1f497d"><u></u> <u></u></span></p>
<p class="MsoNormal"><span style="font-size:11.0pt;font-family:"Calibri","sans-serif";color:#1f497d">I read the latest discussion on this issue which suggested to use common DB for all FS nodes with the same switchname in the switch.xml.<u></u><u></u></span></p>
<p class="MsoNormal"><span style="font-size:11.0pt;font-family:"Calibri","sans-serif";color:#1f497d">But this will not work for me as in my case each FS node needs to maintains locally its own Freeswitch DB tables (there is a reason why it is setup like that).<u></u><u></u></span></p>
<p class="MsoNormal"><span style="font-size:11.0pt;font-family:"Calibri","sans-serif";color:#1f497d"><u></u> <u></u></span></p>
<p class="MsoNormal"><span style="font-size:11.0pt;font-family:"Calibri","sans-serif";color:#1f497d">In each FS node I see that the sip_presence table is being updated with each sip client event (reg, unreg, etc).<u></u><u></u></span></p>
<p class="MsoNormal"><span style="font-size:11.0pt;font-family:"Calibri","sans-serif";color:#1f497d">I already have a script that already handles each FS events so I can log all register/unregister/expire events.<u></u><u></u></span></p>
<p class="MsoNormal"><span style="font-size:11.0pt;font-family:"Calibri","sans-serif";color:#1f497d"> <u></u><u></u></span></p>
<p class="MsoNormal"><span style="font-size:11.0pt;font-family:"Calibri","sans-serif";color:#1f497d">So my question is, how can I reflect sip client presence events from one FS node to another?<u></u><u></u></span></p>
<p class="MsoNormal"><span style="font-size:11.0pt;font-family:"Calibri","sans-serif";color:#1f497d"><u></u> <u></u></span></p>
<p class="MsoNormal"><span style="font-size:11.0pt;font-family:"Calibri","sans-serif";color:#1f497d">Regards<span class="HOEnZb"><font color="#888888"><u></u><u></u></font></span></span></p>
<span class="HOEnZb"><font color="#888888"></font><p class="MsoNormal"><font color="#888888"><span style="font-size:11.0pt;font-family:"Calibri","sans-serif";color:#1f497d"><u></u> <u></u></span></font></p><p class="MsoNormal"><font color="#888888"><span style="font-size:11.0pt;font-family:"Calibri","sans-serif";color:#1f497d">Assaf<u></u><u></u></span></font></p><p class="MsoNormal"><font color="#888888"><span style="font-size:11.0pt;font-family:"Calibri","sans-serif";color:#1f497d"> <u></u><u></u></span></font></p></span>
</div>
</div>
</div>
<br>_________________________________________________________________________
<br> Professional FreeSWITCH Consulting Services:
<br>
<a href="mailto:consulting@freeswitch.org">consulting@freeswitch.org</a>
<br>
<a href="http://www.freeswitchsolutions.com" rel="noreferrer" target="_blank">http://www.freeswitchsolutions.com</a>
<br>
<br> Official FreeSWITCH Sites
<br>
<a href="http://www.freeswitch.org" rel="noreferrer" target="_blank">http://www.freeswitch.org</a>
<br>
<a href="http://confluence.freeswitch.org" rel="noreferrer" target="_blank">http://confluence.freeswitch.org</a>
<br>
<a href="http://www.cluecon.com" rel="noreferrer" target="_blank">http://www.cluecon.com</a>
<br>
<br> FreeSWITCH-users mailing list
<br>
<a href="mailto:FreeSWITCH-users@lists.freeswitch.org">FreeSWITCH-users@lists.freeswitch.org</a>
<br>
<a href="http://lists.freeswitch.org/mailman/listinfo/freeswitch-users" rel="noreferrer" target="_blank">http://lists.freeswitch.org/mailman/listinfo/freeswitch-users</a>
<br> UNSUBSCRIBE:
<a href="http://lists.freeswitch.org/mailman/options/freeswitch-users" rel="noreferrer" target="_blank">http://lists.freeswitch.org/mailman/options/freeswitch-users</a>
<br>
<a href="http://www.freeswitch.org" rel="noreferrer" target="_blank">http://www.freeswitch.org</a>
<br>
</blockquote>
</div>
<br>
</div>
<pre class="blue"> <hr><br>Professional FreeSWITCH Consulting Services: <br>consulting@freeswitch.org<br><a href="http://www.freeswitchsolutions.com">http://www.freeswitchsolutions.com</a><br><br>Official FreeSWITCH Sites<br><a href="http://www.freeswitch.org">http://www.freeswitch.org</a><br><a href="http://confluence.freeswitch.org">http://confluence.freeswitch.org</a><br><a href="http://www.cluecon.com">http://www.cluecon.com</a><br><br>FreeSWITCH-users mailing list<br>FreeSWITCH-users@lists.freeswitch.org<br><a href="http://lists.freeswitch.org/mailman/listinfo/freeswitch-users">http://lists.freeswitch.org/mailman/listinfo/freeswitch-users</a><br>UNSUBSCRIBE:<a href="http://lists.freeswitch.org/mailman/options/freeswitch-users">http://lists.freeswitch.org/mailman/options/freeswitch-users</a><br><a href="http://www.freeswitch.org">http://www.freeswitch.org</a></pre></blockquote></div></body></html>