<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"><<a href="mailto:nneul@mst.edu" target="_blank">nneul@mst.edu</a>></span> wrote:<br><blockquote class="gmail_quote" style="margin:0 0 0 .8ex;border-left:1px #ccc solid;padding-left:1ex">I'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>
> 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>
><br>
> mariaDB Galera Multi-Master Cluster<br>
><br>
><br>
> Features<br>
><br>
</span>> * Synchronous replication<br>
> * Active-active multi-master topology<br>
> * Read and write to any cluster node<br>
> * Automatic membership control, failed nodes drop from the cluster<br>
> * Automatic node joining<br>
> * T*rue parallel replication, on row level !!!!!!!!!!!!!!!*<br>
> * Direct client connections, native MySQL look & feel<br>
<span class="">><br>
><br>
> Benefits<br>
><br>
> The above features yield several benefits for a DBMS clustering solution, including:<br>
><br>
</span>> * No slave lag<br>
> * No lost transactions<br>
> * Both read and write scalability<br>
> * Smaller client latencies<br>
<span class="">><br>
><br>
> 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>
><br>
> Regards<br>
> Rainer Piper<br>
><br>
><br>
><br>
> Am 03.01.2015 um 07:38 schrieb Ashwin Rath:<br>
>> Thenk you all. My main concern was that master master replication is something that is used for a dual redundant<br>
>> deployment . Just not sure if it is reliable with multiple boxes . I have read about people having good luck with<br>
>> xtradb (percona) for MySQL but i think the general opinion is in favor of a cluster than having master-master<br>
>> replication with 'sharded' data.<br>
>><br>
>> @Luis : Yes they are all on the same LAN.<br>
>><br>
>><br>
>><br>
</span><span class="">>> On Sat, Jan 3, 2015 at 2:26 AM, Florent Krieg <<a href="mailto:flokrrr@gmail.com">flokrrr@gmail.com</a> <mailto:<a href="mailto:flokrrr@gmail.com">flokrrr@gmail.com</a>>> wrote:<br>
>><br>
>> Hi Ashwin,<br>
>><br>
>> I don't know very well Postgres but I achieved pretty much the same (horizontal scaling) with a MySQL cluster.<br>
>> Replication is a bit painful to setup and to maintain (especially master master, including db desynchronization<br>
>> when crashes occur and so on). I would go for a cluster, almost endlessly scalable and very very reliable. It is<br>
>> more costly to setup but I think it is worth the pain.<br>
>><br>
>> My feelings, I don't pretend to be a reference though :)<br>
>><br>
>> Florent<br>
>><br>
</span>>> Le 2 janv. 2015 20:42, "Ashwin Rath" <<a href="mailto:ashwinrath@gmail.com">ashwinrath@gmail.com</a> <mailto:<a href="mailto:ashwinrath@gmail.com">ashwinrath@gmail.com</a>>> a écrit :<br>
<span class="">>><br>
>> Hi All<br>
>><br>
>> I am trying to scale FS by having individual nodes running FS that have the core in Postgres. The idea is to<br>
>> have any number of FS boxes behind a load balancer depending on the load.<br>
>><br>
>> Just wanted to ask if master master replication is reliable for say 10 FS nodes holding presence as well as<br>
>> session info ?<br>
>><br>
>> or would it just bea better idea to build a highly available postgres sql cluster and point all FS to it ?<br>
>><br>
>><br>
>> --<br>
>> Ashwin Kumar Rath<br>
>><br>
>> _________________________________________________________________________<br>
>> Professional FreeSWITCH Consulting Services:<br>
</span>>> <a href="mailto:consulting@freeswitch.org">consulting@freeswitch.org</a> <mailto:<a href="mailto:consulting@freeswitch.org">consulting@freeswitch.org</a>><br>
<span class="">>> <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>
</span>>> <a href="mailto:FreeSWITCH-users@lists.freeswitch.org">FreeSWITCH-users@lists.freeswitch.org</a> <mailto:<a href="mailto:FreeSWITCH-users@lists.freeswitch.org">FreeSWITCH-users@lists.freeswitch.org</a>><br>
<span class="">>> <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>
>><br>
>><br>
>> _________________________________________________________________________<br>
>> Professional FreeSWITCH Consulting Services:<br>
</span>>> <a href="mailto:consulting@freeswitch.org">consulting@freeswitch.org</a> <mailto:<a href="mailto:consulting@freeswitch.org">consulting@freeswitch.org</a>><br>
<span class="">>> <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>
</span>>> <a href="mailto:FreeSWITCH-users@lists.freeswitch.org">FreeSWITCH-users@lists.freeswitch.org</a> <mailto:<a href="mailto:FreeSWITCH-users@lists.freeswitch.org">FreeSWITCH-users@lists.freeswitch.org</a>><br>
<span class="">>> <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>
>><br>
>><br>
>><br>
>><br>
>> --<br>
>> Ashwin Kumar Rath<br>
>><br>
>><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>
><br>
><br>
> --<br>
</span>> *Rainer Piper*<br>
<span class="">> Integration engineer<br>
> Koeslinstr. 56<br>
> 53123 BONN<br>
> GERMANY<br>
</span>> Phone: <a href="tel:%2B49%20228%2097167161" value="+4922897167161">+49 228 97167161</a> <callto:004922897167161><br>
<span class="">> P2P: <a href="http://sip:rainer@sip.soho-piper.de:5072" target="_blank">sip:rainer@sip.soho-piper.de:5072</a> (pjsip-test)<br>
> XMPP: <a href="mailto:rainer@xmpp.soho-piper.de">rainer@xmpp.soho-piper.de</a><br>
><br>
><br>
</span><span class="">> _________________________________________________________________________<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>
><br>
<br>
--<br>
</span>------------------------------------------------------------<br>
Nathan Neulinger <a href="mailto:nneul@mst.edu">nneul@mst.edu</a><br>
Missouri S&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>