Is there a way to store voicemail to a MySQL cluster like Asterisk does? This is one of the issues I have been trying to find an answer for, but I haven't been able to. It would be great if there were a LUA/Javascript command that would stream audio to the call directly from the database, or the other way around. This would be useful for voicemail recordings, IVR prompts, etc, when running several clustered FS servers. I have a MySQL Cluster spread across each of my FS servers that should be able to handle the additional load. Using MySQL cluster as an on-demand audio storage system would make access to the audio files fault-tolerant and distributed (even to other servers such as a web server for web voicemail playback). Any ideas on how this could be achieved? Brett Woollum Brett@Woollum.com ----- Original Message ----- From: "Yehavi Bourvine" <yehavi.bourvine@gmail.com> To: "FreeSWITCH Users Help" <freeswitch-users@lists.freeswitch.org> Sent: Saturday, October 9, 2010 12:49:51 AM GMT -08:00 US/Canada Pacific Subject: Re: [Freeswitch-users] Sharing storage between servers Hi, We use a NAS server to share the voicemail between two servers (one is FS, the other is WEB interface we wrote to handle voicemail via WEB). For the database: we use MySQL with replication. Regards, __Yehavi: 2010/10/9 Jody Rudolph < jody.rudolph@gmail.com > I am curious as to just how far you can take sharing disk storage for the purpose of clustering. Is anyone doing this with the voicemail storage directories? Is it possible to share the SQLite internal databases to avoid resorting to ODBC? I realize that isn't likely, but I have access to some high performance SAN hardware and want to take the most advantage possible. Thanks, Jody Rudolph _______________________________________________ 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 _______________________________________________ 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 had the same problem and did store the voicemail stuff on a NFS share. The NFS server does run on a heartbeat/drbd server. All the FreeSWITCH server does mount the high-available NFS share through the high-available IP address. Works very good - also in failover of the NFS Server. BR, Bernhard -----Ursprüngliche Nachricht----- Von: freeswitch-users-bounces@lists.freeswitch.org [mailto:freeswitch-users-bounces@lists.freeswitch.org] Im Auftrag von broken dash Gesendet: Montag, 17. Januar 2011 08:25 An: FreeSWITCH Users Help Betreff: Re: [Freeswitch-users] Sharing storage between servers Your question is also incredibly complex depending on the methods you could use as well. Storing the audio files within the mysql database would be REALLY slow... :-) I remember seeing a bounty for some type of Voicemail/IMAP integration but I'm not sure if anyone has furthered it. that would be a neat way to handle things since you could use an existing IMAP mail server setup, or build one and scale/cluster however you wish an basically use the IMAP mail system as the storage medium for your users voice mail. So the Voicemail's would also be email's and one could use the IMAP client on their desktop to also manage their messages. :-) Also could be done using webdav/fuse etc.. One could also use multiple icecast servers spread around and have liquidsoap sit in front of them so that when you go to record the message it hits liquidsoap locally where its configured to feed the single message out to multiple shoutcast servers spread around the globe in different data centers or something. This one is deff worth checking into tho.... http://www.automatthew.com/2007/12/amazon-simpledb-and-couchdb-compared.html Late 2 cents... Cheers, B On Sat, Oct 9, 2010 at 3:10 AM, Brett Woollum <brett@woollum.com> wrote:

Is there a way to store voicemail to a MySQL cluster like Asterisk does? This is one of the issues I have been trying to find an answer for, but I haven't been able to. It would be great if there were a LUA/Javascript command that would stream audio to the call directly from the database, or the other way around. This would be useful for voicemail recordings, IVR prompts, etc, when running several clustered FS servers. I have a MySQL Cluster spread across each of my FS servers that should be able to handle the additional load. Using MySQL cluster as an on-demand audio storage system would make access to the audio files fault-tolerant and distributed (even to other servers such as a web server for web voicemail playback).

Any ideas on how this could be achieved?

Brett Woollum Brett@Woollum.com

----- Original Message ----- From: "Yehavi Bourvine" <yehavi.bourvine@gmail.com> To: "FreeSWITCH Users Help" <freeswitch-users@lists.freeswitch.org> Sent: Saturday, October 9, 2010 12:49:51 AM GMT -08:00 US/Canada Pacific Subject: Re: [Freeswitch-users] Sharing storage between servers

Hi,

  We use a NAS server to share the voicemail between two servers (one is FS, the other is WEB interface we wrote to handle  voicemail via WEB).   For the database: we use MySQL with replication.

                          Regards, __Yehavi:

2010/10/9 Jody Rudolph <jody.rudolph@gmail.com>

...

I am curious as to just how far you can take sharing disk storage for the purpose of clustering. Is anyone doing this with the voicemail storage directories? Is it possible to share the SQLite internal databases to avoid resorting to ODBC? I realize that isn't likely, but I have access to some high performance SAN hardware and want to take the most advantage possible.

Thanks, Jody Rudolph

_______________________________________________ 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

_______________________________________________ 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 _______________________________________________ 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

_______________________________________________ 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

you can also simply use files in folder and replicate it to all of your nodes every 3mn... store binary in DB is more slow as in a folder ----- Original Message ----- From: "broken dash" <brokendash@gmail.com> To: "FreeSWITCH Users Help" <freeswitch-users@lists.freeswitch.org> Sent: Monday, January 17, 2011 2:24 AM Subject: Re: [Freeswitch-users] Sharing storage between servers Your question is also incredibly complex depending on the methods you could use as well. Storing the audio files within the mysql database would be REALLY slow... :-) I remember seeing a bounty for some type of Voicemail/IMAP integration but I'm not sure if anyone has furthered it. that would be a neat way to handle things since you could use an existing IMAP mail server setup, or build one and scale/cluster however you wish an basically use the IMAP mail system as the storage medium for your users voice mail. So the Voicemail's would also be email's and one could use the IMAP client on their desktop to also manage their messages. :-) Also could be done using webdav/fuse etc.. One could also use multiple icecast servers spread around and have liquidsoap sit in front of them so that when you go to record the message it hits liquidsoap locally where its configured to feed the single message out to multiple shoutcast servers spread around the globe in different data centers or something. This one is deff worth checking into tho.... http://www.automatthew.com/2007/12/amazon-simpledb-and-couchdb-compared.html Late 2 cents... Cheers, B On Sat, Oct 9, 2010 at 3:10 AM, Brett Woollum <brett@woollum.com> wrote:

Is there a way to store voicemail to a MySQL cluster like Asterisk does? This is one of the issues I have been trying to find an answer for, but I haven't been able to. It would be great if there were a LUA/Javascript command that would stream audio to the call directly from the database, or the other way around. This would be useful for voicemail recordings, IVR prompts, etc, when running several clustered FS servers. I have a MySQL Cluster spread across each of my FS servers that should be able to handle the additional load. Using MySQL cluster as an on-demand audio storage system would make access to the audio files fault-tolerant and distributed (even to other servers such as a web server for web voicemail playback).

Any ideas on how this could be achieved?

Brett Woollum Brett@Woollum.com

----- Original Message ----- From: "Yehavi Bourvine" <yehavi.bourvine@gmail.com> To: "FreeSWITCH Users Help" <freeswitch-users@lists.freeswitch.org> Sent: Saturday, October 9, 2010 12:49:51 AM GMT -08:00 US/Canada Pacific Subject: Re: [Freeswitch-users] Sharing storage between servers

Hi,

We use a NAS server to share the voicemail between two servers (one is FS, the other is WEB interface we wrote to handle voicemail via WEB). For the database: we use MySQL with replication.

Regards, __Yehavi:

2010/10/9 Jody Rudolph <jody.rudolph@gmail.com>

...

I am curious as to just how far you can take sharing disk storage for the purpose of clustering. Is anyone doing this with the voicemail storage directories? Is it possible to share the SQLite internal databases to avoid resorting to ODBC? I realize that isn't likely, but I have access to some high performance SAN hardware and want to take the most advantage possible.

Thanks, Jody Rudolph

_______________________________________________ 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

_______________________________________________ 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 _______________________________________________ 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

_______________________________________________ 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 used too in experimental state, but I noticed in case of network node problem OCFS2 locked with big delay on other nodes. However it's stable. ----- Original Message ----- From: João Mesquita To: FreeSWITCH Users Help Sent: Monday, January 17, 2011 11:26 AM Subject: Re: [Freeswitch-users] Sharing storage between servers I've used OCFS2 in the past and even though there wasn't a production system and there wasn't a lot of volume, it was pretty stable and easy to setup. João Mesquita On Mon, Jan 17, 2011 at 1:15 PM, Madovsky <infos@madovsky.org> wrote: you can also simply use files in folder and replicate it to all of your nodes every 3mn... store binary in DB is more slow as in a folder ----- Original Message ----- From: "broken dash" <brokendash@gmail.com> To: "FreeSWITCH Users Help" <freeswitch-users@lists.freeswitch.org> Sent: Monday, January 17, 2011 2:24 AM Subject: Re: [Freeswitch-users] Sharing storage between servers Your question is also incredibly complex depending on the methods you could use as well. Storing the audio files within the mysql database would be REALLY slow... :-) I remember seeing a bounty for some type of Voicemail/IMAP integration but I'm not sure if anyone has furthered it. that would be a neat way to handle things since you could use an existing IMAP mail server setup, or build one and scale/cluster however you wish an basically use the IMAP mail system as the storage medium for your users voice mail. So the Voicemail's would also be email's and one could use the IMAP client on their desktop to also manage their messages. :-) Also could be done using webdav/fuse etc.. One could also use multiple icecast servers spread around and have liquidsoap sit in front of them so that when you go to record the message it hits liquidsoap locally where its configured to feed the single message out to multiple shoutcast servers spread around the globe in different data centers or something. This one is deff worth checking into tho.... http://www.automatthew.com/2007/12/amazon-simpledb-and-couchdb-compared.html Late 2 cents... Cheers, B On Sat, Oct 9, 2010 at 3:10 AM, Brett Woollum <brett@woollum.com> wrote: > Is there a way to store voicemail to a MySQL cluster like Asterisk does? > This is one of the issues I have been trying to find an answer for, but I > haven't been able to. It would be great if there were a LUA/Javascript > command that would stream audio to the call directly from the database, or > the other way around. This would be useful for voicemail recordings, IVR > prompts, etc, when running several clustered FS servers. I have a MySQL > Cluster spread across each of my FS servers that should be able to handle > the additional load. Using MySQL cluster as an on-demand audio storage > system would make access to the audio files fault-tolerant and distributed > (even to other servers such as a web server for web voicemail playback). > > Any ideas on how this could be achieved? > > Brett Woollum > Brett@Woollum.com > > > ----- Original Message ----- > From: "Yehavi Bourvine" <yehavi.bourvine@gmail.com> > To: "FreeSWITCH Users Help" <freeswitch-users@lists.freeswitch.org> > Sent: Saturday, October 9, 2010 12:49:51 AM GMT -08:00 US/Canada Pacific > Subject: Re: [Freeswitch-users] Sharing storage between servers > > Hi, > > We use a NAS server to share the voicemail between two servers (one is FS, > the other is WEB interface we wrote to handle voicemail via WEB). > For the database: we use MySQL with replication. > > Regards, __Yehavi: > > 2010/10/9 Jody Rudolph <jody.rudolph@gmail.com> >> >> I am curious as to just how far you can take sharing disk storage for the >> purpose of clustering. Is anyone doing this with the voicemail storage >> directories? Is it possible to share the SQLite internal databases to >> avoid >> resorting to ODBC? I realize that isn't likely, but I have access to some >> high performance SAN hardware and want to take the most advantage >> possible. >> >> >> Thanks, >> Jody Rudolph >> >> _______________________________________________ >> 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 >> > > > _______________________________________________ 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 > _______________________________________________ > 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 > > _______________________________________________ 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 _______________________________________________ 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 ------------------------------------------------------------------------------ _______________________________________________ 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