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

[Yuriy Nasida]

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 		 	   		  
-------------- next part --------------
An HTML attachment was scrubbed...
URL: http://lists.freeswitch.org/pipermail/freeswitch-users/attachments/20120309/94a61b19/attachment.html