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@live.ru
To: freeswitch-users@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@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.

http://wiki.freeswitch.org/wiki/Using_ODBC_in_the_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