Hello all,
My orginzation has been using Moodle for quite some time now. I have inherited a disorganized, poorly managed Moodle enviornment (From what I can tell comparativly to SFSU, etc.). We plan on upgrading our Farm to Moodle 2.0 soon and are currently in the middle of discussing our planning, etc. Our enviornent is at a fairly decent size at the moment, and is expected to continue growing. At the moment we have something that looks something like this:
24 Moodle servers
2 MySQL servers
Every Moodle server is for a separate campus, and the MySQL databases are starting to grow fairly large per each campus. Originally we had all the MySQL db's on the same server and that was causing huge performance issues. Although I was not working for my company at this time, I believe that it could have been related to not configuring MySQL appropriately etc.
My question is this:
We have the resources (i.e. Hearty Virtualized farm, Citrix Netscaler, etc) to implement something efficient and reliable; however, I feel as if we are not using our resources to its full potential. I mainly wanted to know if I should look into MySQL clustering when we redesign our Moodle environment. I was personally thinking that it may be worthwhile to look into load balancing of some sort, and implement a MySQL clustered environment that was backed up and had replication enabled for reporting, etc.
What do you all think, and where would be a good source of information to look into how to do this specifically with Moodle. Obviously MySQL's site has plenty of information on implementing MySQL clustering, etc.
Thank you for your time,
Christopher L. Medina