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

[Yuriy Nasida]

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




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/8cd22fa9/attachment-0001.html