<html>
<head>
<meta content="text/html; charset=windows-1252"
http-equiv="Content-Type">
</head>
<body bgcolor="#FFFFFF" text="#000000">
<div class="moz-cite-prefix">Hi Ashwin,<br>
<br>
take a look at mariaDB Galera Multi-Master Cluster 10.0.15. <br>
I run 2x Cluster and each Cluster with 6x DB Nodes.<br>
A total of 12x DB Server<br>
<br>
<h2>mariaDB Galera Multi-Master Cluster</h2>
<h2>Features
</h2>
<ul start="1">
<li>Synchronous replication
</li>
<li>Active-active multi-master topology
</li>
<li>Read and write to any cluster node
</li>
<li>Automatic membership control, failed nodes drop from the
cluster
</li>
<li>Automatic node joining
</li>
<li>T<b>rue parallel replication, on row level !!!!!!!!!!!!!!!</b>
</li>
<li>Direct client connections, native MySQL look & feel
</li>
</ul>
<h2 class="anchored_heading" id="benefits">Benefits</h2>
<p>The above features yield several benefits for a DBMS clustering
solution, including:</p>
<ul start="1">
<li>No slave lag
</li>
<li>No lost transactions
</li>
<li>Both read and write scalability
</li>
<li>Smaller client latencies
</li>
</ul>
<br>
source:
<a class="moz-txt-link-freetext" href="https://mariadb.com/kb/en/mariadb/documentation/replication/galera/what-is-mariadb-galera-cluster/">https://mariadb.com/kb/en/mariadb/documentation/replication/galera/what-is-mariadb-galera-cluster/</a><br>
<br>
Regards<br>
Rainer Piper<br>
<br>
<br>
<br>
Am 03.01.2015 um 07:38 schrieb Ashwin Rath:<br>
</div>
<blockquote
cite="mid:CAA_Nwu7DmQnQMVJr3zY23Jti1siPoDWFPWMJQE2N63AcYoozFw@mail.gmail.com"
type="cite">
<div dir="ltr">
<div>Thenk you all. My main concern was that master master
replication is something that is used for a dual redundant
deployment . Just not sure if it is reliable with multiple
boxes . I have read about people having good luck with xtradb
(percona) for MySQL but i think the general opinion is in
favor of a cluster than having master-master replication with
'sharded' data.<br>
<br>
</div>
@Luis : Yes they are all on the same LAN. <br>
<br>
<br>
</div>
<div class="gmail_extra"><br>
<div class="gmail_quote">On Sat, Jan 3, 2015 at 2:26 AM, Florent
Krieg <span dir="ltr"><<a moz-do-not-send="true"
href="mailto:flokrrr@gmail.com" target="_blank">flokrrr@gmail.com</a>></span>
wrote:<br>
<blockquote class="gmail_quote" style="margin:0 0 0
.8ex;border-left:1px #ccc solid;padding-left:1ex">
<p dir="ltr">Hi Ashwin,</p>
<p dir="ltr">I don't know very well Postgres but I achieved
pretty much the same (horizontal scaling) with a MySQL
cluster. Replication is a bit painful to setup and to
maintain (especially master master, including db
desynchronization when crashes occur and so on). I would
go for a cluster, almost endlessly scalable and very very
reliable. It is more costly to setup but I think it is
worth the pain.</p>
<p dir="ltr">My feelings, I don't pretend to be a reference
though :)</p>
<p dir="ltr">Florent</p>
<div class="gmail_quote">Le 2 janv. 2015 20:42, "Ashwin
Rath" <<a moz-do-not-send="true"
href="mailto:ashwinrath@gmail.com" target="_blank">ashwinrath@gmail.com</a>>
a écrit :<br type="attribution">
<blockquote class="gmail_quote" style="margin:0 0 0
.8ex;border-left:1px #ccc solid;padding-left:1ex">
<div>
<div class="h5">
<div dir="ltr">
<div>
<div>
<div>Hi All<br>
<br>
</div>
I am trying to scale FS by having individual
nodes running FS that have the core in
Postgres. The idea is to have any number of FS
boxes behind a load balancer depending on the
load.<br>
<br>
</div>
Just wanted to ask if master master replication
is reliable for say 10 FS nodes holding presence
as well as session info ?<br>
<br>
</div>
or would it just bea better idea to build a highly
available postgres sql cluster and point all FS to
it ?<br>
<div>
<div>
<div><br clear="all">
<div>
<div><br>
-- <br>
<div>Ashwin Kumar Rath<br>
</div>
</div>
</div>
</div>
</div>
</div>
</div>
<br>
</div>
</div>
<span class="">_________________________________________________________________________<br>
Professional FreeSWITCH Consulting Services:<br>
<a moz-do-not-send="true"
href="mailto:consulting@freeswitch.org"
target="_blank">consulting@freeswitch.org</a><br>
<a moz-do-not-send="true"
href="http://www.freeswitchsolutions.com"
target="_blank">http://www.freeswitchsolutions.com</a><br>
<br>
Official FreeSWITCH Sites<br>
<a moz-do-not-send="true"
href="http://www.freeswitch.org" target="_blank">http://www.freeswitch.org</a><br>
<a moz-do-not-send="true"
href="http://confluence.freeswitch.org"
target="_blank">http://confluence.freeswitch.org</a><br>
<a moz-do-not-send="true"
href="http://www.cluecon.com" target="_blank">http://www.cluecon.com</a><br>
<br>
FreeSWITCH-users mailing list<br>
<a moz-do-not-send="true"
href="mailto:FreeSWITCH-users@lists.freeswitch.org"
target="_blank">FreeSWITCH-users@lists.freeswitch.org</a><br>
<a moz-do-not-send="true"
href="http://lists.freeswitch.org/mailman/listinfo/freeswitch-users"
target="_blank">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"
target="_blank">http://lists.freeswitch.org/mailman/options/freeswitch-users</a><br>
<a moz-do-not-send="true"
href="http://www.freeswitch.org" target="_blank">http://www.freeswitch.org</a><br>
</span></blockquote>
</div>
<br>
_________________________________________________________________________<br>
Professional FreeSWITCH Consulting Services:<br>
<a moz-do-not-send="true"
href="mailto:consulting@freeswitch.org">consulting@freeswitch.org</a><br>
<a moz-do-not-send="true"
href="http://www.freeswitchsolutions.com" target="_blank">http://www.freeswitchsolutions.com</a><br>
<br>
Official FreeSWITCH Sites<br>
<a moz-do-not-send="true" href="http://www.freeswitch.org"
target="_blank">http://www.freeswitch.org</a><br>
<a moz-do-not-send="true"
href="http://confluence.freeswitch.org" target="_blank">http://confluence.freeswitch.org</a><br>
<a moz-do-not-send="true" href="http://www.cluecon.com"
target="_blank">http://www.cluecon.com</a><br>
<br>
FreeSWITCH-users mailing list<br>
<a moz-do-not-send="true"
href="mailto: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"
target="_blank">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"
target="_blank">http://lists.freeswitch.org/mailman/options/freeswitch-users</a><br>
<a moz-do-not-send="true" href="http://www.freeswitch.org"
target="_blank">http://www.freeswitch.org</a><br>
</blockquote>
</div>
<br>
<br clear="all">
<br>
-- <br>
<div class="gmail_signature">Ashwin Kumar Rath<br>
</div>
</div>
<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>
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://confluence.freeswitch.org">http://confluence.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>
<br>
<div class="moz-signature">-- <br>
<b>Rainer Piper</b>
<br>
Integration engineer
<br>
Koeslinstr. 56
<br>
53123 BONN <br>
GERMANY
<br>
Phone: <a href="callto:004922897167161" nr="+4922897167161"
class="telified" title="Als Telefonnummer verwenden"
style="color:#00001f;background-color:#ffffdf;-moz-border-radius:3px;cursor:pointer">+49
228 97167161</a>
<br>
P2P: <a class="moz-txt-link-freetext" href="sip:rainer@sip.soho-piper.de:5072">sip:rainer@sip.soho-piper.de:5072</a> (pjsip-test)
<br>
XMPP: <a class="moz-txt-link-abbreviated" href="mailto:rainer@xmpp.soho-piper.de">rainer@xmpp.soho-piper.de</a></div>
</body>
</html>