[Freeswitch-users] Scaling FreeSWITCH horizontally with master master replication

[Rainer Piper]

Hi Ashwin,

take a look at mariaDB Galera Multi-Master Cluster 10.0.15.
I run 2x Cluster and each Cluster with 6x DB Nodes.
A total of 12x DB Server


    mariaDB Galera Multi-Master Cluster


    Features

  * Synchronous replication
  * Active-active multi-master topology
  * Read and write to any cluster node
  * Automatic membership control, failed nodes drop from the cluster
  * Automatic node joining
  * T*rue parallel replication, on row level !!!!!!!!!!!!!!!*
  * Direct client connections, native MySQL look & feel


    Benefits

The above features yield several benefits for a DBMS clustering 
solution, including:

  * No slave lag
  * No lost transactions
  * Both read and write scalability
  * Smaller client latencies


source: 
https://mariadb.com/kb/en/mariadb/documentation/replication/galera/what-is-mariadb-galera-cluster/

Regards
Rainer Piper



Am 03.01.2015 um 07:38 schrieb Ashwin Rath:
> 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.
>
> @Luis : Yes they are all on the same LAN.
>
>
>
> On Sat, Jan 3, 2015 at 2:26 AM, Florent Krieg <flokrrr at gmail.com 
> <mailto:flokrrr at gmail.com>> wrote:
>
>     Hi Ashwin,
>
>     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.
>
>     My feelings, I don't pretend to be a reference though :)
>
>     Florent
>
>     Le 2 janv. 2015 20:42, "Ashwin Rath" <ashwinrath at gmail.com
>     <mailto:ashwinrath at gmail.com>> a écrit :
>
>         Hi All
>
>         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.
>
>         Just wanted to ask if master master replication is reliable
>         for say 10 FS nodes holding presence as well as session info ?
>
>         or would it just bea better idea to build a highly available
>         postgres sql cluster and point all FS to it ?
>
>
>         -- 
>         Ashwin Kumar Rath
>
>         _________________________________________________________________________
>         Professional FreeSWITCH Consulting Services:
>         consulting at freeswitch.org <mailto:consulting at freeswitch.org>
>         http://www.freeswitchsolutions.com
>
>         Official FreeSWITCH Sites
>         http://www.freeswitch.org
>         http://confluence.freeswitch.org
>         http://www.cluecon.com
>
>         FreeSWITCH-users mailing list
>         FreeSWITCH-users at lists.freeswitch.org
>         <mailto:FreeSWITCH-users at 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 at freeswitch.org <mailto:consulting at freeswitch.org>
>     http://www.freeswitchsolutions.com
>
>     Official FreeSWITCH Sites
>     http://www.freeswitch.org
>     http://confluence.freeswitch.org
>     http://www.cluecon.com
>
>     FreeSWITCH-users mailing list
>     FreeSWITCH-users at lists.freeswitch.org
>     <mailto:FreeSWITCH-users at lists.freeswitch.org>
>     http://lists.freeswitch.org/mailman/listinfo/freeswitch-users
>     UNSUBSCRIBE:http://lists.freeswitch.org/mailman/options/freeswitch-users
>     http://www.freeswitch.org
>
>
>
>
> -- 
> Ashwin Kumar Rath
>
>
> _________________________________________________________________________
> Professional FreeSWITCH Consulting Services:
> consulting at freeswitch.org
> http://www.freeswitchsolutions.com
>
> Official FreeSWITCH Sites
> http://www.freeswitch.org
> http://confluence.freeswitch.org
> http://www.cluecon.com
>
> FreeSWITCH-users mailing list
> FreeSWITCH-users at lists.freeswitch.org
> http://lists.freeswitch.org/mailman/listinfo/freeswitch-users
> UNSUBSCRIBE:http://lists.freeswitch.org/mailman/options/freeswitch-users
> http://www.freeswitch.org


-- 
*Rainer Piper*
Integration engineer
Koeslinstr. 56
53123 BONN
GERMANY
Phone: +49 228 97167161 <callto:004922897167161>
P2P: sip:rainer at sip.soho-piper.de:5072 (pjsip-test)
XMPP: rainer at xmpp.soho-piper.de
-------------- next part --------------
An HTML attachment was scrubbed...
URL: http://lists.freeswitch.org/pipermail/freeswitch-users/attachments/20150103/892f9f40/attachment.html