[Freeswitch-users] FreeSWITCH Core - Cassandra Database

john at millican.us john at millican.us
Thu Aug 1 23:45:45 MSD 2013


Hello,
If you are looking for a master-master replication I can say that 
Percona Xtradb cluster works very well.  There are a few extra settings 
that need to be in my.cnf pertaining to wsrep but not too bad to set up, 
certainly not painful.  I am currently running a 3 master cluster for an 
eCommerce site.   I can not speak to cross data center replication 
though as all three are racked above one another.  MMySQL is pretty 
quick but can it not compare to MongoDB or CouchBase.  I have used many 
SQL db and a few NoSQL and the NoSQL are much faster, easier to scale, 
and just plain more fun. My opinion and of course YMMV
JohnM

On 8/1/2013 1:38 PM, Ken Rice wrote:
> Re: [Freeswitch-users] FreeSWITCH Core - Cassandra Database Postgresql 
> offers streaming replication in PG9 versions... Its a 
> master/(warm)standby system but it works quite well (I use the native 
> pgsql replication for high volume calling). PostgreSQL is BSD licensed 
> so this has also lead to several addons that use various methods for 
> replication... Some are opensourced others are not...
>
> On 8/1/13 12:10 PM, "Lloyd Aloysius" <lloyd.aloysius at sunteltech.ca> wrote:
>
>     Ken,
>
>     Thank you for the information. Can you please tell me how can we
>     scale with postgres with multiple Data centers. I think postgres
>     - replication is not possible?
>
>
>     Thanks
>     Lloyd
>     *
>       <http://www.sunteltech.ca/blog/>
>     *
>
>     On Thu, Aug 1, 2013 at 12:52 PM, Ken Rice <krice at freeswitch.org>
>     wrote:
>
>         the core of freeswtich requires a sql database. changing it to
>         use a nosql database is not a trivial task.
>
>         Postgres is probably the most recommended database to use and
>         is used in many high volume production environments. (its that
>         the developers of freeswitch primarily use)
>         Ken
>         Sent from my iPad
>
>         On Aug 1, 2013, at 11:40, Ashwin Jain <ashwinrkjain at gmail.com>
>         wrote:
>
>             Hi,
>
>             I am also looking for similar kind of solution.
>
>             I have a web application for which I am using backend as
>             Cassandra.
>             My web application also controls Freeswitch (as in it
>             contains the UI for setting up bridging for calls). So,
>             right now, for that I wrote a sync service which fetches
>             data from Cassandra and puts it in MySQL.
>
>
>
>             On Thu, Aug 1, 2013 at 9:53 PM, Lloyd Aloysius
>             <lloyd.aloysius at sunteltech.ca> wrote:
>
>
>                 if you use MySQL  replication is painful. It is not
>                 faster. Binary logs are killing the cpu and memory.
>                 Lots of interest in this direction. I saw OpenSIP
>                 using Casendra Driver for distribution.
>
>                 LLoyd
>                 *  <http://www.sunteltech.ca/blog/>
>                 *
>
>                 On Thu, Aug 1, 2013 at 12:04 PM, Jeff Leung
>                 <jleung at v10networks.ca> wrote:
>
>                     I'm not sure of Cassandra database will work as a
>                     database for the FreeSWICH core since the syntax
>                     looks SQL but isn't.
>
>                     If It provides ODBC connectivity, you may as well
>                     as give it a shot.
>
>
>                     *From:*
>                     freeswitch-users-bounces at lists.freeswitch.org
>                     [mailto:freeswitch-users-bounces at lists.freeswitch.org]
>                     *On Behalf Of *Lloyd Aloysius
>                     *Sent:* Thursday, August 1, 2013 8:14 AM
>                     *To:* FreeSWITCH Users Help
>                     *Subject:* [Freeswitch-users] FreeSWITCH Core -
>                     Cassandra Database
>
>
>
>                     Hi All
>
>
>
>                     Does any one have experience with FreeSWITCH Core
>                     and Cassandra Database. Sounds like Cassandra
>                     (http://cassandra.apache.org/) have a better
>                     replication system. This will help to distribute
>                     freeswitch across multiple data centers and
>                     provide a better fail over system.
>
>
>
>                     Any feedback ? Thank you in advance.
>
>
>
>                     Thanks
>
>                     Lloyd
>
>                     _________________________________________________________________________
>                     Professional FreeSWITCH Consulting Services:
>                     consulting at freeswitch.org
>                     http://www.freeswitchsolutions.com
>
>                     FreeSWITCH-powered IP PBX: The CudaTel
>                     Communication Server
>                     
>
>                     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
>
>
>
>                 _________________________________________________________________________
>                 Professional FreeSWITCH Consulting Services:
>                 consulting at freeswitch.org
>                 http://www.freeswitchsolutions.com
>
>                 FreeSWITCH-powered IP PBX: The CudaTel Communication
>                 Server
>                 
>
>                 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
>
>
>
>
> -- 
> Ken
> _http://www.FreeSWITCH.org
> http://www.ClueCon.com
> http://www.OSTAG.org
> _irc.freenode.net #freeswitch
>
>
> _________________________________________________________________________
> 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/20130801/fb73aa29/attachment-0001.html 


Join us at ClueCon 2011 Aug 9-11, 2011
More information about the FreeSWITCH-users mailing list