[Freeswitch-users] reserve mysql database using odbc in the core

[Lloyd Aloysius]

I have similar setup, But two freeswitch server's and two mysql server's

freeswitch server 1 & server 2 connect mysql server1 all the time.

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?

Thanks
Lloyd


*
*



On Fri, Mar 9, 2012 at 11:08 AM, Yuriy Nasida <nasida at live.ru> wrote:

>  Ok, I have recieved really good advice in IRC chat from Andee.
>
> "install mysqlproxy on the freeswitch box, tell odbc to look at localhost
> and configure mysqlproxy to look to the two actual mysql servers
> + ip failover and as long as the replication is live you can failover
> without dropping calls"
>
> 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)
>
> So I plan to install two mysqlproxy on each box.
> Thus each FS will have the main and the reserve mysql server.
>
> I will continue and upgrade this thread.
>
> Thanks.
>
> ------------------------------
> From: nasida at live.ru
> To: freeswitch-users at lists.freeswitch.org
> Date: Fri, 9 Mar 2012 18:03:00 +0400
>
> Subject: Re: [Freeswitch-users] reserve mysql database using odbc in the
> core
>
>  Peter,
>
> Thanks for your answer. Yes I know about using MySQL + DRBD + heartbeat
> but I search the best way.
> 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.  http://wiki.freeswitch.org/wiki/Freeswitch_HA
>
> 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.
>
> 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.
>
>
> Thanks.
>
> ------------------------------
> From: peter.olsson at visionutveckling.se
> To: freeswitch-users at lists.freeswitch.org
> Date: Fri, 9 Mar 2012 12:32:11 +0000
> Subject: Re: [Freeswitch-users] reserve mysql database using odbc in the
> core
>
>  You need to setup MySQL to be able to failover. Most people use MySQL +
> DRBD + heartbeat for this kind of operation.
>
>
>
> /Peter
>
>
>
>
>
> *Från:* freeswitch-users-bounces at lists.freeswitch.org [mailto:
> freeswitch-users-bounces at lists.freeswitch.org] *För *Yuriy Nasida
> *Skickat:* den 9 mars 2012 12:45
> *Till:* freeswitch-users at lists.freeswitch.org
> *Ämne:* [Freeswitch-users] reserve mysql database using odbc in the core
>
>
>
> Hello guys!
>
>
>
> 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.
>
>
>
> http://wiki.freeswitch.org/wiki/Using_ODBC_in_the_core
>
>
>
> Thanks.
>
> !DSPAM:4f59ec5e32765716517795!
>
> _________________________________________________________________________
> Professional FreeSWITCH Consulting Services: consulting at freeswitch.org
> http://www.freeswitchsolutions.com FreeSWITCH-powered IP PBX: The CudaTel
> Communication Server  Official FreeSWITCH Sites
> http://www.freeswitch.org http://wiki.freeswitch.org
> http://www.cluecon.com FreeSWITCH-users mailing list
> FreeSWITCH-users at lists.freeswitch.org
> http://lists.freeswitch.org/mailman/listinfo/freeswitch-users UNSUBSCRIBE:
> http://lists.freeswitch.org/mailman/options/freeswitch-users
> http://www.freeswitch.org
>
> _________________________________________________________________________
> Professional FreeSWITCH Consulting Services: consulting at freeswitch.org
> http://www.freeswitchsolutions.com FreeSWITCH-powered IP PBX: The CudaTel
> Communication Server  Official FreeSWITCH Sites
> http://www.freeswitch.org http://wiki.freeswitch.org
> http://www.cluecon.com FreeSWITCH-users mailing list
> FreeSWITCH-users at lists.freeswitch.org
> http://lists.freeswitch.org/mailman/listinfo/freeswitch-users UNSUBSCRIBE:
> http://lists.freeswitch.org/mailman/options/freeswitch-users
> http://www.freeswitch.org
>
> _________________________________________________________________________
> Professional FreeSWITCH Consulting Services:
> consulting at freeswitch.org
> http://www.freeswitchsolutions.com
>
> 
> 
>
> Official FreeSWITCH Sites
> http://www.freeswitch.org
> http://wiki.freeswitch.org
> http://www.cluecon.com
>
> FreeSWITCH-users mailing list
> FreeSWITCH-users at lists.freeswitch.org
> http://lists.freeswitch.org/mailman/listinfo/freeswitch-users
> UNSUBSCRIBE:http://lists.freeswitch.org/mailman/options/freeswitch-users
> http://www.freeswitch.org
>
>
-------------- next part --------------
An HTML attachment was scrubbed...
URL: http://lists.freeswitch.org/pipermail/freeswitch-users/attachments/20120309/e078cc50/attachment.html