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-m... 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@gmail.com <mailto:flokrrr@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@gmail.com <mailto:ashwinrath@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@freeswitch.org <mailto:consulting@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@lists.freeswitch.org <mailto:FreeSWITCH-users@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@freeswitch.org <mailto:consulting@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@lists.freeswitch.org <mailto:FreeSWITCH-users@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@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@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@sip.soho-piper.de:5072 (pjsip-test) XMPP: rainer@xmpp.soho-piper.de