<div dir="ltr"><div><div><br>Thank you Rainer for the info about MariaDB. I shall certainly try it out.<br><br></div><div>I am trying this out for the first time.<br></div><div><br></div>At present i am running some tests on Postgre with master master replication between freeswitch hosts.There would be say 5 FS boxes each having Postgre and FS and all the Postgres instances would be replicated in master-master mode. There is no cluster or HA DB. Each FreeSWITCH interacts only with its own postgres instance.<br><br></div><div><div><div>Would the above configuration be the right way to move forward ? <br></div><div><br><div><div><span class=""><font color="#888888"><b><br><br></b>
      </font></span></div></div></div></div></div></div><div class="gmail_extra"><br><div class="gmail_quote">On Sun, Jan 4, 2015 at 12:46 AM, Nathan Neulinger <span dir="ltr">&lt;<a href="mailto:nneul@mst.edu" target="_blank">nneul@mst.edu</a>&gt;</span> wrote:<br><blockquote class="gmail_quote" style="margin:0 0 0 .8ex;border-left:1px #ccc solid;padding-left:1ex">I&#39;m currently using Percona XTraDB cluster in a 3 node setup as backend for FS, with keepalived used for managing the<br>
live database IP. How is the stability/maturity of the MariaDB implementation?<br>
<br>
What are you using to manage the the rapid failover between DB nodes/ip failover?<br>
<br>
-- Nathan<br>
<span class=""><br>
On 01/03/2015 01:21 AM, Rainer Piper wrote:<br>
&gt; Hi Ashwin,<br>
&gt;<br>
&gt; take a look at mariaDB Galera Multi-Master Cluster 10.0.15.<br>
&gt; I run 2x Cluster and each Cluster with 6x DB Nodes.<br>
&gt; A total of 12x DB Server<br>
&gt;<br>
&gt;<br>
&gt;     mariaDB Galera Multi-Master Cluster<br>
&gt;<br>
&gt;<br>
&gt;     Features<br>
&gt;<br>
</span>&gt;   * Synchronous replication<br>
&gt;   * Active-active multi-master topology<br>
&gt;   * Read and write to any cluster node<br>
&gt;   * Automatic membership control, failed nodes drop from the cluster<br>
&gt;   * Automatic node joining<br>
&gt;   * T*rue parallel replication, on row level !!!!!!!!!!!!!!!*<br>
&gt;   * Direct client connections, native MySQL look &amp; feel<br>
<span class="">&gt;<br>
&gt;<br>
&gt;     Benefits<br>
&gt;<br>
&gt; The above features yield several benefits for a DBMS clustering solution, including:<br>
&gt;<br>
</span>&gt;   * No slave lag<br>
&gt;   * No lost transactions<br>
&gt;   * Both read and write scalability<br>
&gt;   * Smaller client latencies<br>
<span class="">&gt;<br>
&gt;<br>
&gt; source: <a href="https://mariadb.com/kb/en/mariadb/documentation/replication/galera/what-is-mariadb-galera-cluster/" target="_blank">https://mariadb.com/kb/en/mariadb/documentation/replication/galera/what-is-mariadb-galera-cluster/</a><br>
&gt;<br>
&gt; Regards<br>
&gt; Rainer Piper<br>
&gt;<br>
&gt;<br>
&gt;<br>
&gt; Am 03.01.2015 um 07:38 schrieb Ashwin Rath:<br>
&gt;&gt; Thenk you all. My main concern was that master master replication is something that is used for a dual redundant<br>
&gt;&gt; deployment . Just not sure if it is reliable with multiple boxes . I have read about people having good luck with<br>
&gt;&gt; xtradb (percona) for MySQL but i think the general opinion is in favor of a cluster than having master-master<br>
&gt;&gt; replication with &#39;sharded&#39; data.<br>
&gt;&gt;<br>
&gt;&gt; @Luis : Yes they are all on the same LAN.<br>
&gt;&gt;<br>
&gt;&gt;<br>
&gt;&gt;<br>
</span><span class="">&gt;&gt; On Sat, Jan 3, 2015 at 2:26 AM, Florent Krieg &lt;<a href="mailto:flokrrr@gmail.com">flokrrr@gmail.com</a> &lt;mailto:<a href="mailto:flokrrr@gmail.com">flokrrr@gmail.com</a>&gt;&gt; wrote:<br>
&gt;&gt;<br>
&gt;&gt;     Hi Ashwin,<br>
&gt;&gt;<br>
&gt;&gt;     I don&#39;t know very well Postgres but I achieved pretty much the same (horizontal scaling) with a MySQL cluster.<br>
&gt;&gt;     Replication is a bit painful to setup and to maintain (especially master master, including db desynchronization<br>
&gt;&gt;     when crashes occur and so on). I would go for a cluster, almost endlessly scalable and very very reliable. It is<br>
&gt;&gt;     more costly to setup but I think it is worth the pain.<br>
&gt;&gt;<br>
&gt;&gt;     My feelings, I don&#39;t pretend to be a reference though :)<br>
&gt;&gt;<br>
&gt;&gt;     Florent<br>
&gt;&gt;<br>
</span>&gt;&gt;     Le 2 janv. 2015 20:42, &quot;Ashwin Rath&quot; &lt;<a href="mailto:ashwinrath@gmail.com">ashwinrath@gmail.com</a> &lt;mailto:<a href="mailto:ashwinrath@gmail.com">ashwinrath@gmail.com</a>&gt;&gt; a écrit :<br>
<span class="">&gt;&gt;<br>
&gt;&gt;         Hi All<br>
&gt;&gt;<br>
&gt;&gt;         I am trying to scale FS by having individual nodes running FS that have the core in Postgres. The idea is to<br>
&gt;&gt;         have any number of FS boxes behind a load balancer depending on the load.<br>
&gt;&gt;<br>
&gt;&gt;         Just wanted to ask if master master replication is reliable for say 10 FS nodes holding presence as well as<br>
&gt;&gt;         session info ?<br>
&gt;&gt;<br>
&gt;&gt;         or would it just bea better idea to build a highly available postgres sql cluster and point all FS to it ?<br>
&gt;&gt;<br>
&gt;&gt;<br>
&gt;&gt;         --<br>
&gt;&gt;         Ashwin Kumar Rath<br>
&gt;&gt;<br>
&gt;&gt;         _________________________________________________________________________<br>
&gt;&gt;         Professional FreeSWITCH Consulting Services:<br>
</span>&gt;&gt;         <a href="mailto:consulting@freeswitch.org">consulting@freeswitch.org</a> &lt;mailto:<a href="mailto:consulting@freeswitch.org">consulting@freeswitch.org</a>&gt;<br>
<span class="">&gt;&gt;         <a href="http://www.freeswitchsolutions.com" target="_blank">http://www.freeswitchsolutions.com</a><br>
&gt;&gt;<br>
&gt;&gt;         Official FreeSWITCH Sites<br>
&gt;&gt;         <a href="http://www.freeswitch.org" target="_blank">http://www.freeswitch.org</a><br>
&gt;&gt;         <a href="http://confluence.freeswitch.org" target="_blank">http://confluence.freeswitch.org</a><br>
&gt;&gt;         <a href="http://www.cluecon.com" target="_blank">http://www.cluecon.com</a><br>
&gt;&gt;<br>
&gt;&gt;         FreeSWITCH-users mailing list<br>
</span>&gt;&gt;         <a href="mailto:FreeSWITCH-users@lists.freeswitch.org">FreeSWITCH-users@lists.freeswitch.org</a> &lt;mailto:<a href="mailto:FreeSWITCH-users@lists.freeswitch.org">FreeSWITCH-users@lists.freeswitch.org</a>&gt;<br>
<span class="">&gt;&gt;         <a href="http://lists.freeswitch.org/mailman/listinfo/freeswitch-users" target="_blank">http://lists.freeswitch.org/mailman/listinfo/freeswitch-users</a><br>
&gt;&gt;         UNSUBSCRIBE:<a href="http://lists.freeswitch.org/mailman/options/freeswitch-users" target="_blank">http://lists.freeswitch.org/mailman/options/freeswitch-users</a><br>
&gt;&gt;         <a href="http://www.freeswitch.org" target="_blank">http://www.freeswitch.org</a><br>
&gt;&gt;<br>
&gt;&gt;<br>
&gt;&gt;     _________________________________________________________________________<br>
&gt;&gt;     Professional FreeSWITCH Consulting Services:<br>
</span>&gt;&gt;     <a href="mailto:consulting@freeswitch.org">consulting@freeswitch.org</a> &lt;mailto:<a href="mailto:consulting@freeswitch.org">consulting@freeswitch.org</a>&gt;<br>
<span class="">&gt;&gt;     <a href="http://www.freeswitchsolutions.com" target="_blank">http://www.freeswitchsolutions.com</a><br>
&gt;&gt;<br>
&gt;&gt;     Official FreeSWITCH Sites<br>
&gt;&gt;     <a href="http://www.freeswitch.org" target="_blank">http://www.freeswitch.org</a><br>
&gt;&gt;     <a href="http://confluence.freeswitch.org" target="_blank">http://confluence.freeswitch.org</a><br>
&gt;&gt;     <a href="http://www.cluecon.com" target="_blank">http://www.cluecon.com</a><br>
&gt;&gt;<br>
&gt;&gt;     FreeSWITCH-users mailing list<br>
</span>&gt;&gt;     <a href="mailto:FreeSWITCH-users@lists.freeswitch.org">FreeSWITCH-users@lists.freeswitch.org</a> &lt;mailto:<a href="mailto:FreeSWITCH-users@lists.freeswitch.org">FreeSWITCH-users@lists.freeswitch.org</a>&gt;<br>
<span class="">&gt;&gt;     <a href="http://lists.freeswitch.org/mailman/listinfo/freeswitch-users" target="_blank">http://lists.freeswitch.org/mailman/listinfo/freeswitch-users</a><br>
&gt;&gt;     UNSUBSCRIBE:<a href="http://lists.freeswitch.org/mailman/options/freeswitch-users" target="_blank">http://lists.freeswitch.org/mailman/options/freeswitch-users</a><br>
&gt;&gt;     <a href="http://www.freeswitch.org" target="_blank">http://www.freeswitch.org</a><br>
&gt;&gt;<br>
&gt;&gt;<br>
&gt;&gt;<br>
&gt;&gt;<br>
&gt;&gt; --<br>
&gt;&gt; Ashwin Kumar Rath<br>
&gt;&gt;<br>
&gt;&gt;<br>
&gt;&gt; _________________________________________________________________________<br>
&gt;&gt; Professional FreeSWITCH Consulting Services:<br>
&gt;&gt; <a href="mailto:consulting@freeswitch.org">consulting@freeswitch.org</a><br>
&gt;&gt; <a href="http://www.freeswitchsolutions.com" target="_blank">http://www.freeswitchsolutions.com</a><br>
&gt;&gt;<br>
&gt;&gt; Official FreeSWITCH Sites<br>
&gt;&gt; <a href="http://www.freeswitch.org" target="_blank">http://www.freeswitch.org</a><br>
&gt;&gt; <a href="http://confluence.freeswitch.org" target="_blank">http://confluence.freeswitch.org</a><br>
&gt;&gt; <a href="http://www.cluecon.com" target="_blank">http://www.cluecon.com</a><br>
&gt;&gt;<br>
&gt;&gt; FreeSWITCH-users mailing list<br>
&gt;&gt; <a href="mailto:FreeSWITCH-users@lists.freeswitch.org">FreeSWITCH-users@lists.freeswitch.org</a><br>
&gt;&gt; <a href="http://lists.freeswitch.org/mailman/listinfo/freeswitch-users" target="_blank">http://lists.freeswitch.org/mailman/listinfo/freeswitch-users</a><br>
&gt;&gt; UNSUBSCRIBE:<a href="http://lists.freeswitch.org/mailman/options/freeswitch-users" target="_blank">http://lists.freeswitch.org/mailman/options/freeswitch-users</a><br>
&gt;&gt; <a href="http://www.freeswitch.org" target="_blank">http://www.freeswitch.org</a><br>
&gt;<br>
&gt;<br>
&gt; --<br>
</span>&gt; *Rainer Piper*<br>
<span class="">&gt; Integration engineer<br>
&gt; Koeslinstr. 56<br>
&gt; 53123 BONN<br>
&gt; GERMANY<br>
</span>&gt; Phone: <a href="tel:%2B49%20228%2097167161" value="+4922897167161">+49 228 97167161</a> &lt;callto:004922897167161&gt;<br>
<span class="">&gt; P2P: <a href="http://sip:rainer@sip.soho-piper.de:5072" target="_blank">sip:rainer@sip.soho-piper.de:5072</a> (pjsip-test)<br>
&gt; XMPP: <a href="mailto:rainer@xmpp.soho-piper.de">rainer@xmpp.soho-piper.de</a><br>
&gt;<br>
&gt;<br>
</span><span class="">&gt; _________________________________________________________________________<br>
&gt; Professional FreeSWITCH Consulting Services:<br>
&gt; <a href="mailto:consulting@freeswitch.org">consulting@freeswitch.org</a><br>
&gt; <a href="http://www.freeswitchsolutions.com" target="_blank">http://www.freeswitchsolutions.com</a><br>
&gt;<br>
&gt; Official FreeSWITCH Sites<br>
&gt; <a href="http://www.freeswitch.org" target="_blank">http://www.freeswitch.org</a><br>
&gt; <a href="http://confluence.freeswitch.org" target="_blank">http://confluence.freeswitch.org</a><br>
&gt; <a href="http://www.cluecon.com" target="_blank">http://www.cluecon.com</a><br>
&gt;<br>
&gt; FreeSWITCH-users mailing list<br>
&gt; <a href="mailto:FreeSWITCH-users@lists.freeswitch.org">FreeSWITCH-users@lists.freeswitch.org</a><br>
&gt; <a href="http://lists.freeswitch.org/mailman/listinfo/freeswitch-users" target="_blank">http://lists.freeswitch.org/mailman/listinfo/freeswitch-users</a><br>
&gt; UNSUBSCRIBE:<a href="http://lists.freeswitch.org/mailman/options/freeswitch-users" target="_blank">http://lists.freeswitch.org/mailman/options/freeswitch-users</a><br>
&gt; <a href="http://www.freeswitch.org" target="_blank">http://www.freeswitch.org</a><br>
&gt;<br>
<br>
--<br>
</span>------------------------------------------------------------<br>
Nathan Neulinger                       <a href="mailto:nneul@mst.edu">nneul@mst.edu</a><br>
Missouri S&amp;T Information Technology    <a href="tel:%28573%29%20612-1412" value="+15736121412">(573) 612-1412</a><br>
System Administrator - Architect<br>
<div class="HOEnZb"><div class="h5"><br>
_________________________________________________________________________<br>
Professional FreeSWITCH Consulting Services:<br>
<a href="mailto:consulting@freeswitch.org">consulting@freeswitch.org</a><br>
<a href="http://www.freeswitchsolutions.com" target="_blank">http://www.freeswitchsolutions.com</a><br>
<br>
Official FreeSWITCH Sites<br>
<a href="http://www.freeswitch.org" target="_blank">http://www.freeswitch.org</a><br>
<a href="http://confluence.freeswitch.org" target="_blank">http://confluence.freeswitch.org</a><br>
<a href="http://www.cluecon.com" target="_blank">http://www.cluecon.com</a><br>
<br>
FreeSWITCH-users mailing list<br>
<a href="mailto:FreeSWITCH-users@lists.freeswitch.org">FreeSWITCH-users@lists.freeswitch.org</a><br>
<a href="http://lists.freeswitch.org/mailman/listinfo/freeswitch-users" target="_blank">http://lists.freeswitch.org/mailman/listinfo/freeswitch-users</a><br>
UNSUBSCRIBE:<a href="http://lists.freeswitch.org/mailman/options/freeswitch-users" target="_blank">http://lists.freeswitch.org/mailman/options/freeswitch-users</a><br>
<a href="http://www.freeswitch.org" target="_blank">http://www.freeswitch.org</a><br>
</div></div></blockquote></div><br><br clear="all"><br>-- <br><div class="gmail_signature">Ashwin Kumar Rath<br></div>
</div>