The above features yield several benefits for a DBMS clustering solution, including:
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> 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> a écrit :
_________________________________________________________________________or would it just bea better idea to build a highly available postgres sql cluster and point all FS to it ?Just wanted to ask if master master replication is reliable for say 10 FS nodes holding presence as well as session info ?Hi AllI 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.
--
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
_________________________________________________________________________
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
--
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