Thank you Rainer for the info about MariaDB. I shall certainly try it out. I am trying this out for the first time. At present i am running some tests on Postgre with master master replication between freeswitch hosts.There would be say 5 FS boxes each having Postgre and FS and all the Postgres instances would be replicated in master-master mode. There is no cluster or HA DB. Each FreeSWITCH interacts only with its own postgres instance. Would the above configuration be the right way to move forward ? On Sun, Jan 4, 2015 at 12:46 AM, Nathan Neulinger <nneul@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-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
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
-- 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
_________________________________________________________________________ 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
-- ------------------------------------------------------------ Nathan Neulinger nneul@mst.edu Missouri S&T Information Technology (573) 612-1412 System Administrator - Architect
_________________________________________________________________________ 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