<html>
<head>
<style><!--
.hmmessage P
{
margin:0px;
padding:0px
}
body.hmmessage
{
font-size: 10pt;
font-family:Tahoma
}
--></style></head>
<body class='hmmessage'><div dir='ltr'>
FS can write the date about all current calls in special db. Both FS can use this db.<div>I think it will help you.</div><div><a href="http://wiki.freeswitch.org/wiki/Freeswitch_HA">http://wiki.freeswitch.org/wiki/Freeswitch_HA</a> <br><br><br><div><div id="SkyDrivePlaceholder"></div><hr id="stopSpelling">From: lloyd.aloysius@gmail.com<br>Date: Fri, 9 Mar 2012 11:45:04 -0500<br>To: freeswitch-users@lists.freeswitch.org<br>Subject: Re: [Freeswitch-users] reserve mysql database using odbc in the core<br><br><font face="verdana,sans-serif">I have similar setup, But two freeswitch server's and two mysql server's</font><div><font face="verdana,sans-serif"><br></font></div><div><font face="verdana, sans-serif">freeswitch server 1 & server 2 connect mysql server1 all the time.</font></div>
<div><font face="verdana, sans-serif"><br></font></div><div><font face="verdana, sans-serif">My question is if freeswitch server 1 down. How to recover the calls from freeswitch 2? What are the settings ? How reliable this solution ... there is IP , Ports involves in the call path?</font></div>
<div><font face="verdana, sans-serif"><br></font></div><div><font face="verdana, sans-serif">Thanks</font></div><div><font face="verdana, sans-serif">Lloyd</font></div><div><font face="verdana, sans-serif"><br></font></div>
<div><font face="verdana, sans-serif"><br><div><span style="font-family:arial"><div><font face="verdana, sans-serif" color="#cc6600" size="1"><b><br></b></font></div></span></div></font><br>
<br><br><div class="ecxgmail_quote">On Fri, Mar 9, 2012 at 11:08 AM, Yuriy Nasida <span dir="ltr"><<a href="mailto:nasida@live.ru">nasida@live.ru</a>></span> wrote:<br><blockquote class="ecxgmail_quote" style="border-left:1px #ccc solid;padding-left:1ex">
<div><div dir="ltr">
<div><div>Ok, I have recieved really good advice in IRC chat from Andee.</div><div><br></div><div>"install mysqlproxy on the freeswitch box, tell odbc to look at localhost and configure mysqlproxy to look to the two actual mysql servers</div>
<div>+ ip failover and as long as the replication is live you can failover without dropping calls"</div><div><br></div><div>So if FS1 will down but mysql1 is live, I will save all current calls. If full box1 down, I will save some part of current calls (it is depends from replication timeout)</div>
<div><br></div><div>So I plan to install two mysqlproxy on each box.</div><div>Thus each FS will have the main and the reserve mysql server.</div><div><br></div><div>I will continue and upgrade this thread.</div><div><br>
</div><div>Thanks.</div><br><div><div></div><hr>From: <a href="mailto:nasida@live.ru">nasida@live.ru</a><br>To: <a href="mailto:freeswitch-users@lists.freeswitch.org">freeswitch-users@lists.freeswitch.org</a><br>
Date: Fri, 9 Mar 2012 18:03:00 +0400<div><div></div><div class="h5"><br>Subject: Re: [Freeswitch-users] reserve mysql database using odbc in the core<br><br>
<div dir="ltr">
<div><div>Peter,</div><div><br></div><div>Thanks for your answer. Yes I know about using MySQL + DRBD + heartbeat but I search the best way.</div><div>I plan to use 2 box only. each box will have (FS+mysql). Both FS has to use same mysql. It is necessary for feature - the recovering of current calls in FS2 if FS1 (i mean application level only, i.e. not full box1) will be broken. <a href="http://wiki.freeswitch.org/wiki/Freeswitch_HA" target="_blank">http://wiki.freeswitch.org/wiki/Freeswitch_HA</a></div>
<div><br></div><div>If full box1 will broken, FS2 from box2 has to use own mysql server (mysql2) which will be synchronized with mysql1 from box1 (by means of mysql replication). I will lose current calls but new calls will work fine.</div>
<div><br></div><div>I am not sure if it is possible. So I search possibility of using of backup mysql server if main server down. It may looks like second DNS or second SIP-proxy. I just need to put the second ip address of the standby mysql server on FS2. So FS2 will have two IP address of mysql servers: 1) ip adress of mysql1 (box1) 2) own ip.</div>
<div><br></div><div><br></div><div>Thanks.</div><br><div><div></div><hr>From: <a href="mailto:peter.olsson@visionutveckling.se">peter.olsson@visionutveckling.se</a><br>To: <a href="mailto:freeswitch-users@lists.freeswitch.org">freeswitch-users@lists.freeswitch.org</a><br>
Date: Fri, 9 Mar 2012 12:32:11 +0000<br>Subject: Re: [Freeswitch-users] reserve mysql database using odbc in the core<br><br>
<div>
<span lang="EN-US" style="font-size:10.0pt;font-family:"Calibri","sans-serif";color:#1f497d">You need to setup MySQL to be able to failover. Most people use MySQL + DRBD + heartbeat for this kind of operation.</span><BR>
<span lang="EN-US" style="font-size:10.0pt;font-family:"Calibri","sans-serif";color:#1f497d"> </span><BR>
<span lang="EN-US" style="font-size:10.0pt;font-family:"Calibri","sans-serif";color:#1f497d">/Peter</span><BR>
<span lang="EN-US" style="font-size:10.0pt;font-family:"Calibri","sans-serif";color:#1f497d"> </span><BR>
<span style="font-size:10.0pt;font-family:"Calibri","sans-serif";color:#1f497d"> </span><BR>
<div>
<div style="border:none;border-top:solid #b5c4df 1.0pt;padding:3.0pt 0cm 0cm 0cm">
<b><span style="font-size:10.0pt;font-family:"Tahoma","sans-serif"">Från:</span></b><span style="font-size:10.0pt;font-family:"Tahoma","sans-serif""> <a href="mailto:freeswitch-users-bounces@lists.freeswitch.org">freeswitch-users-bounces@lists.freeswitch.org</a> [mailto:<a href="mailto:freeswitch-users-bounces@lists.freeswitch.org">freeswitch-users-bounces@lists.freeswitch.org</a>]
<b>För </b>Yuriy Nasida<br>
<b>Skickat:</b> den 9 mars 2012 12:45<br>
<b>Till:</b> <a href="mailto:freeswitch-users@lists.freeswitch.org">freeswitch-users@lists.freeswitch.org</a><br>
<b>Ämne:</b> [Freeswitch-users] reserve mysql database using odbc in the core</span><BR>
</div>
</div>
<BR>
<div>
<div>
<span style="font-size:10.0pt;font-family:"Tahoma","sans-serif"">Hello guys!</span><BR>
</div>
<div>
<span style="font-size:10.0pt;font-family:"Tahoma","sans-serif""> </span><BR>
</div>
<div>
<span style="font-size:10.0pt;font-family:"Tahoma","sans-serif"">If anybody know how can I use reserve mysql database using odbc in the core? So if my first mysql server was down I would like that FS would use second mysql server for core.</span><BR>
</div>
<div>
<span style="font-size:10.0pt;font-family:"Tahoma","sans-serif""> </span><BR>
</div>
<div>
<span style="font-size:10.0pt;font-family:"Tahoma","sans-serif""><a href="http://wiki.freeswitch.org/wiki/Using_ODBC_in_the_core" target="_blank">http://wiki.freeswitch.org/wiki/Using_ODBC_in_the_core</a>
</span><BR>
</div>
<div>
<span style="font-size:10.0pt;font-family:"Tahoma","sans-serif""> </span><BR>
</div>
<span style="font-size:10.0pt;font-family:"Tahoma","sans-serif"">Thanks.
</span><BR>
</div>
<span style="font-size:10.0pt;font-family:"Tahoma","sans-serif"">!DSPAM:4f59ec5e32765716517795!
</span><BR>
</div>
<br>_________________________________________________________________________
Professional FreeSWITCH Consulting Services:
<a href="mailto:consulting@freeswitch.org">consulting@freeswitch.org</a>
<a href="http://www.freeswitchsolutions.com" target="_blank">http://www.freeswitchsolutions.com</a>
FreeSWITCH-powered IP PBX: The CudaTel Communication Server
<a href="http://www.cudatel.com" target="_blank">http://www.cudatel.com</a>
Official FreeSWITCH Sites
<a href="http://www.freeswitch.org" target="_blank">http://www.freeswitch.org</a>
<a href="http://wiki.freeswitch.org" target="_blank">http://wiki.freeswitch.org</a>
<a href="http://www.cluecon.com" target="_blank">http://www.cluecon.com</a>
FreeSWITCH-users mailing list
<a href="mailto:FreeSWITCH-users@lists.freeswitch.org">FreeSWITCH-users@lists.freeswitch.org</a>
<a href="http://lists.freeswitch.org/mailman/listinfo/freeswitch-users" target="_blank">http://lists.freeswitch.org/mailman/listinfo/freeswitch-users</a>
UNSUBSCRIBE:<a href="http://lists.freeswitch.org/mailman/options/freeswitch-users" target="_blank">http://lists.freeswitch.org/mailman/options/freeswitch-users</a>
<a href="http://www.freeswitch.org" target="_blank">http://www.freeswitch.org</a></div></div> </div>
<br>_________________________________________________________________________
Professional FreeSWITCH Consulting Services:
<a href="mailto:consulting@freeswitch.org">consulting@freeswitch.org</a>
<a href="http://www.freeswitchsolutions.com" target="_blank">http://www.freeswitchsolutions.com</a>
FreeSWITCH-powered IP PBX: The CudaTel Communication Server
<a href="http://www.cudatel.com" target="_blank">http://www.cudatel.com</a>
Official FreeSWITCH Sites
<a href="http://www.freeswitch.org" target="_blank">http://www.freeswitch.org</a>
<a href="http://wiki.freeswitch.org" target="_blank">http://wiki.freeswitch.org</a>
<a href="http://www.cluecon.com" target="_blank">http://www.cluecon.com</a>
FreeSWITCH-users mailing list
<a href="mailto:FreeSWITCH-users@lists.freeswitch.org">FreeSWITCH-users@lists.freeswitch.org</a>
<a href="http://lists.freeswitch.org/mailman/listinfo/freeswitch-users" target="_blank">http://lists.freeswitch.org/mailman/listinfo/freeswitch-users</a>
UNSUBSCRIBE:<a href="http://lists.freeswitch.org/mailman/options/freeswitch-users" target="_blank">http://lists.freeswitch.org/mailman/options/freeswitch-users</a>
<a href="http://www.freeswitch.org" target="_blank">http://www.freeswitch.org</a></div></div></div></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" target="_blank">http://www.freeswitchsolutions.com</a><br>
<br>
FreeSWITCH-powered IP PBX: The CudaTel Communication Server<br>
<a href="http://www.cudatel.com" target="_blank">http://www.cudatel.com</a><br>
<br>
Official FreeSWITCH Sites<br>
<a href="http://www.freeswitch.org" target="_blank">http://www.freeswitch.org</a><br>
<a href="http://wiki.freeswitch.org" target="_blank">http://wiki.freeswitch.org</a><br>
<a href="http://www.cluecon.com" 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" target="_blank">http://lists.freeswitch.org/mailman/listinfo/freeswitch-users</a><br>
UNSUBSCRIBE:<a href="http://lists.freeswitch.org/mailman/options/freeswitch-users" target="_blank">http://lists.freeswitch.org/mailman/options/freeswitch-users</a><br>
<a href="http://www.freeswitch.org" target="_blank">http://www.freeswitch.org</a><br>
<br></blockquote></div><br></div>
<br>_________________________________________________________________________
Professional FreeSWITCH Consulting Services:
consulting@freeswitch.org
http://www.freeswitchsolutions.com
FreeSWITCH-powered IP PBX: The CudaTel Communication Server
http://www.cudatel.com
Official FreeSWITCH Sites
http://www.freeswitch.org
http://wiki.freeswitch.org
http://www.cluecon.com
FreeSWITCH-users mailing list
FreeSWITCH-users@lists.freeswitch.org
http://lists.freeswitch.org/mailman/listinfo/freeswitch-users
UNSUBSCRIBE:http://lists.freeswitch.org/mailman/options/freeswitch-users
http://www.freeswitch.org</div></div> </div></body>
</html>