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!
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
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 _________________________________________________________________________ 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
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@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@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
_________________________________________________________________________ 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
_________________________________________________________________________ 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
FS can write the date about all current calls in special db. Both FS can use this db.I think it will help you.http://wiki.freeswitch.org/wiki/Freeswitch_HA From: lloyd.aloysius@gmail.com Date: Fri, 9 Mar 2012 11:45:04 -0500 To: freeswitch-users@lists.freeswitch.org Subject: Re: [Freeswitch-users] reserve mysql database using odbc in the core 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? ThanksLloyd On Fri, Mar 9, 2012 at 11:08 AM, Yuriy Nasida <nasida@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@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 _________________________________________________________________________ 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 _________________________________________________________________________ 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 _________________________________________________________________________ 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
participants (3)
-
Lloyd Aloysius
-
Peter Olsson
-
Yuriy Nasida