[Freeswitch-users] FreeSWITCH Core - Cassandra Database

[Nathan Neulinger]

I've had good luck with a small deployment on percona as well, though there are a few minor issues (maybe stuff that can 
be corrected):

1. When FS tries to create indexes on various tables that already exist, it winds up causing a bunch of 
complaints/failures in the percona logs and creating various GAL_ dump files.

2. The external management of percona can be a mess. I tried running with Pacemaker/Corosync and really didn't have good 
luck with it failing over the floating IP properly, so I switched things back over to Keepalived, which I'm using for 
the freeswitch instances.

-- Nathan

On 08/01/2013 02:45 PM, john at millican.us wrote:
> 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
>>
>>                     
>>                     
>>
>>                     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
>>
>>                 
>>                 
>>
>>                 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
>

-- 
------------------------------------------------------------
Nathan Neulinger                       nneul at mst.edu
Missouri S&T Information Technology    (573) 612-1412
System Administrator - Architect