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

[Nathan Neulinger]

I'm currently using Percona XTraDB cluster in a 3 node setup as backend for FS, with keepalived used for managing the 
live database IP. How is the stability/maturity of the MariaDB implementation?

What are you using to manage the the rapid failover between DB nodes/ip failover?

-- Nathan

On 01/03/2015 01:21 AM, Rainer Piper wrote:
> 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
>
>
> _________________________________________________________________________
> 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
>

-- 
------------------------------------------------------------
Nathan Neulinger                       nneul at mst.edu
Missouri S&T Information Technology    (573) 612-1412
System Administrator - Architect