Database Clustering (revisited?)

Database Clustering (revisited?)

by Noveck Gowandan -
Number of replies: 2

Good day fellow Moodlers,

This topic has been bantered around for quite some time, but most responses seem to have been dated and at least a few years old.

We already have a load balanced web cluster for our fairly large moodle, supporting well over 25000 users. Our database, however is still potentially a single point of failure.

We have some plans to deploy master-slave replication across identical hardware. (MySQL / InnoDB/ Moodle 1.9)

Given there are so many newcomers to the Database Clustering playground, has anyone else successfully implemented a multinode (at least three) database cluster?

I was looking at Percona XtraDB Cluster and it looks relatively promising, however, I was hoping someone else had any hands-on deployment with this or any other viable cluster solution.

Cheers,
Noveck

Average of ratings: -
In reply to Noveck Gowandan

Re: Database Clustering (revisited?)

by jason everling -

We are currently using Galera from http://www.codership.com/content/using-galera-cluster with MySQL Server. Currently at 3 + 1 Nodes using the configuration and monitoring tool here, http://www.severalnines.com/galera-configurator/ . You can use the config tool for either coderships WSREP version or for Percona XtraDB . Percona and Coderships version are very similiar in the replication way, both use WSREP. We have not had any issues, nodes run on VMware Vsphere. If you can virtualize I would do it unless you have deep pockets to spend on 4 servers just for XtraDB. 3 nodes is fine but I would add the monitoring node, very informative with stats and alerts. The community version works fine unless you want to go all out in the enterprise version, comparison here, http://www.severalnines.com/clustercontrol

 

Thanks,

Jason

Average of ratings: Useful (1)