[Freeswitch-users] FreeSWITCH Core - Cassandra Database

[Ken Rice]

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

-------------- next part --------------
An HTML attachment was scrubbed...
URL: http://lists.freeswitch.org/pipermail/freeswitch-users/attachments/20130801/1e00f4df/attachment-0001.html