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@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@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@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@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@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@lists.freeswitch.org [mailto:freeswitch-users-bounces@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@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
-- Ken _http://www.FreeSWITCH.org http://www.ClueCon.com http://www.OSTAG.org _irc.freenode.net #freeswitch
_________________________________________________________________________ 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