<html>
<head>
<meta content="text/html; charset=ISO-8859-1"
http-equiv="Content-Type">
</head>
<body text="#000000" bgcolor="#FFFFFF">
<div class="moz-cite-prefix">Hello,<br>
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<br>
JohnM<br>
<br>
On 8/1/2013 1:38 PM, Ken Rice wrote:<br>
</div>
<blockquote cite="mid:CE200751.7876B%25krice@freeswitch.org"
type="cite">
<title>Re: [Freeswitch-users] FreeSWITCH Core - Cassandra Database</title>
<font face="Monaco, Courier New"><span style="font-size:11pt">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... <br>
<br>
On 8/1/13 12:10 PM, "Lloyd Aloysius" <<a
moz-do-not-send="true" href="lloyd.aloysius@sunteltech.ca">lloyd.aloysius@sunteltech.ca</a>>
wrote:<br>
<br>
</span></font>
<blockquote><span style="font-size:11pt"><font face="Verdana,
Helvetica, Arial">Ken,<br>
<br>
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?<br>
<br>
<br>
Thanks<br>
Lloyd<br>
</font></span><font face="Verdana, Helvetica, Arial"><font
color="#CC6600"><font size="2"><span style="font-size:10pt"><b><br>
<<a moz-do-not-send="true"
href="http://www.sunteltech.ca/blog/">http://www.sunteltech.ca/blog/</a>>
<br>
</b></span></font></font></font><font face="Monaco,
Courier New"><span style="font-size:11pt"><br>
<br>
On Thu, Aug 1, 2013 at 12:52 PM, Ken Rice <<a
moz-do-not-send="true" href="krice@freeswitch.org">krice@freeswitch.org</a>>
wrote:<br>
</span></font>
<blockquote><font face="Monaco, Courier New"><span
style="font-size:11pt">the core of freeswtich requires a
sql database. changing it to use a nosql database is not a
trivial task. <br>
<br>
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)<br>
Ken<br>
Sent from my iPad<br>
<br>
On Aug 1, 2013, at 11:40, Ashwin Jain <<a
moz-do-not-send="true" href="ashwinrkjain@gmail.com">ashwinrkjain@gmail.com</a>>
wrote:<br>
<br>
</span></font>
<blockquote><font face="Monaco, Courier New"><span
style="font-size:11pt">Hi,<br>
<br>
I am also looking for similar kind of solution.<br>
<br>
I have a web application for which I am using backend as
Cassandra. <br>
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.<br>
<br>
<br>
<br>
On Thu, Aug 1, 2013 at 9:53 PM, Lloyd Aloysius <<a
moz-do-not-send="true"
href="lloyd.aloysius@sunteltech.ca">lloyd.aloysius@sunteltech.ca</a>>
wrote:<br>
</span></font>
<blockquote><span style="font-size:11pt"><font
face="Verdana, Helvetica, Arial"><br>
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.<br>
<font color="#888888"><br>
LLoyd<br>
</font></font></span><font face="Verdana, Helvetica,
Arial"><font color="#CC6600"><font size="2"><span
style="font-size:10pt"><b> <<a
moz-do-not-send="true"
href="http://www.sunteltech.ca/blog/">http://www.sunteltech.ca/blog/</a>>
<br>
</b></span></font></font></font><font
face="Monaco, Courier New"><span style="font-size:11pt"><br>
<br>
On Thu, Aug 1, 2013 at 12:04 PM, Jeff Leung <<a
moz-do-not-send="true" href="jleung@v10networks.ca">jleung@v10networks.ca</a>>
wrote:<br>
</span></font>
<blockquote><font face="Monaco, Courier New"><span
style="font-size:11pt">I’m not sure of Cassandra
database will work as a database for the FreeSWICH
core since the syntax looks SQL but isn’t.<br>
<br>
If It provides ODBC connectivity, you may as well as
give it a shot.<br>
<br>
<br>
</span><font size="2"><span style="font-size:10pt"><b>From:</b>
<a moz-do-not-send="true"
href="freeswitch-users-bounces@lists.freeswitch.org">freeswitch-users-bounces@lists.freeswitch.org</a>
[<a moz-do-not-send="true"
href="mailto:freeswitch-users-bounces@lists.freeswitch.org">mailto:freeswitch-users-bounces@lists.freeswitch.org</a>]
<b>On Behalf Of </b>Lloyd Aloysius<br>
<b>Sent:</b> Thursday, August 1, 2013 8:14 AM<br>
<b>To:</b> FreeSWITCH Users Help<br>
<b>Subject:</b> [Freeswitch-users] FreeSWITCH Core
- Cassandra Database<br>
</span></font><span style="font-size:11pt"><br>
<br>
<br>
Hi All<br>
<br>
<br>
<br>
Does any one have experience with FreeSWITCH Core
and Cassandra Database. Sounds like Cassandra (<a
moz-do-not-send="true"
href="http://cassandra.apache.org/">http://cassandra.apache.org/</a>)
have a better replication system. This will help to
distribute freeswitch across multiple data centers
and provide a better fail over system.<br>
<br>
<br>
<br>
Any feedback ? Thank you in advance.<br>
<br>
<br>
<br>
Thanks<br>
<br>
Lloyd<br>
<br>
_________________________________________________________________________<br>
Professional FreeSWITCH Consulting Services:<br>
<a moz-do-not-send="true"
href="consulting@freeswitch.org">consulting@freeswitch.org</a><br>
<a moz-do-not-send="true"
href="http://www.freeswitchsolutions.com">http://www.freeswitchsolutions.com</a><br>
<br>
FreeSWITCH-powered IP PBX: The CudaTel Communication
Server<br>
<a moz-do-not-send="true"
href="http://www.cudatel.com">http://www.cudatel.com</a><br>
<br>
Official FreeSWITCH Sites<br>
<a moz-do-not-send="true"
href="http://www.freeswitch.org">http://www.freeswitch.org</a><br>
<a moz-do-not-send="true"
href="http://wiki.freeswitch.org">http://wiki.freeswitch.org</a><br>
<a moz-do-not-send="true"
href="http://www.cluecon.com">http://www.cluecon.com</a><br>
<br>
FreeSWITCH-users mailing list<br>
<a moz-do-not-send="true"
href="FreeSWITCH-users@lists.freeswitch.org">FreeSWITCH-users@lists.freeswitch.org</a><br>
<a moz-do-not-send="true"
href="http://lists.freeswitch.org/mailman/listinfo/freeswitch-users">http://lists.freeswitch.org/mailman/listinfo/freeswitch-users</a><br>
UNSUBSCRIBE:<a moz-do-not-send="true"
href="http://lists.freeswitch.org/mailman/options/freeswitch-users">http://lists.freeswitch.org/mailman/options/freeswitch-users</a><br>
<a moz-do-not-send="true"
href="http://www.freeswitch.org">http://www.freeswitch.org</a><br>
<br>
</span></font></blockquote>
<font face="Monaco, Courier New"><span
style="font-size:11pt"><br>
<br>
_________________________________________________________________________<br>
Professional FreeSWITCH Consulting Services:<br>
<a moz-do-not-send="true"
href="consulting@freeswitch.org">consulting@freeswitch.org</a><br>
<a moz-do-not-send="true"
href="http://www.freeswitchsolutions.com">http://www.freeswitchsolutions.com</a><br>
<br>
FreeSWITCH-powered IP PBX: The CudaTel Communication
Server<br>
<a moz-do-not-send="true"
href="http://www.cudatel.com">http://www.cudatel.com</a><br>
<br>
Official FreeSWITCH Sites<br>
<a moz-do-not-send="true"
href="http://www.freeswitch.org">http://www.freeswitch.org</a><br>
<a moz-do-not-send="true"
href="http://wiki.freeswitch.org">http://wiki.freeswitch.org</a><br>
<a moz-do-not-send="true"
href="http://www.cluecon.com">http://www.cluecon.com</a><br>
<br>
FreeSWITCH-users mailing list<br>
<a moz-do-not-send="true"
href="FreeSWITCH-users@lists.freeswitch.org">FreeSWITCH-users@lists.freeswitch.org</a><br>
<a moz-do-not-send="true"
href="http://lists.freeswitch.org/mailman/listinfo/freeswitch-users">http://lists.freeswitch.org/mailman/listinfo/freeswitch-users</a><br>
UNSUBSCRIBE:<a moz-do-not-send="true"
href="http://lists.freeswitch.org/mailman/options/freeswitch-users">http://lists.freeswitch.org/mailman/options/freeswitch-users</a><br>
<a moz-do-not-send="true"
href="http://www.freeswitch.org">http://www.freeswitch.org</a><br>
<br>
</span></font></blockquote>
<font face="Monaco, Courier New"><span
style="font-size:11pt"><br>
<br>
</span></font></blockquote>
</blockquote>
</blockquote>
<font face="Monaco, Courier New"><span style="font-size:11pt"><br>
-- <br>
Ken<br>
<font color="#0000FF"><u><a moz-do-not-send="true"
href="http://www.FreeSWITCH.org">http://www.FreeSWITCH.org</a><br>
<a moz-do-not-send="true" href="http://www.ClueCon.com">http://www.ClueCon.com</a><br>
<a moz-do-not-send="true" href="http://www.OSTAG.org">http://www.OSTAG.org</a><br>
</u></font>irc.freenode.net #freeswitch<br>
</span></font>
<br>
<fieldset class="mimeAttachmentHeader"></fieldset>
<br>
<pre wrap="">_________________________________________________________________________
Professional FreeSWITCH Consulting Services:
<a class="moz-txt-link-abbreviated" href="mailto:consulting@freeswitch.org">consulting@freeswitch.org</a>
<a class="moz-txt-link-freetext" href="http://www.freeswitchsolutions.com">http://www.freeswitchsolutions.com</a>
FreeSWITCH-powered IP PBX: The CudaTel Communication Server
<a class="moz-txt-link-freetext" href="http://www.cudatel.com">http://www.cudatel.com</a>
Official FreeSWITCH Sites
<a class="moz-txt-link-freetext" href="http://www.freeswitch.org">http://www.freeswitch.org</a>
<a class="moz-txt-link-freetext" href="http://wiki.freeswitch.org">http://wiki.freeswitch.org</a>
<a class="moz-txt-link-freetext" href="http://www.cluecon.com">http://www.cluecon.com</a>
FreeSWITCH-users mailing list
<a class="moz-txt-link-abbreviated" href="mailto:FreeSWITCH-users@lists.freeswitch.org">FreeSWITCH-users@lists.freeswitch.org</a>
<a class="moz-txt-link-freetext" href="http://lists.freeswitch.org/mailman/listinfo/freeswitch-users">http://lists.freeswitch.org/mailman/listinfo/freeswitch-users</a>
UNSUBSCRIBE:<a class="moz-txt-link-freetext" href="http://lists.freeswitch.org/mailman/options/freeswitch-users">http://lists.freeswitch.org/mailman/options/freeswitch-users</a>
<a class="moz-txt-link-freetext" href="http://www.freeswitch.org">http://www.freeswitch.org</a>
</pre>
</blockquote>
<br>
</body>
</html>