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

Sun Jan 4 08:14:13 MSK 2015

Adding that i am using the following add on to postgres for master master
replication :

http://2ndquadrant.com/en/resources/bdr/

On Sun, Jan 4, 2015 at 12:46 AM, Nathan Neulinger <nneul at mst.edu> wrote:

> 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
>
> _________________________________________________________________________
> 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
>

-- 
Ashwin Kumar Rath
-------------- next part --------------
An HTML attachment was scrubbed...
URL: http://lists.freeswitch.org/pipermail/freeswitch-users/attachments/20150104/ecdf0ddb/attachment.html 