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@visionutveckling.se
To: freeswitch-users@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@lists.freeswitch.org [mailto:freeswitch-users-bounces@lists.freeswitch.org] För Yuriy Nasida
Skickat: den 9 mars 2012 12:45
Till: freeswitch-users@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.

 

 

Thanks.

!DSPAM:4f59ec5e32765716517795!


_________________________________________________________________________ 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