Dear Sir/Madam, This is Mr. Lau from Hong Kong. My institution is going to use Moodle 2.0.2+ as our production CMS platform. We have over 30000 users and 2000 courses. In http://moodle.org/stats/, we know that some universities have large number of courses and users in Moodle, e.g. over 100k courses and 50k users. They may run Moodle cluster and database cluster to cope with such high usage. In our environment, would you recommend me to use MySQL single instance or MySQL cluster or MS SQL server? Besides, is it a must to use MySQL 5.0.25 for Moodle 2.0.2+? Can we use MySQL 5.0.77? Thanks Mr. Lau
MySQL 5.0.77 is OK for Moodle 2.0.x but it is recommended that you seriously pursue an aggressive and consistent update policy, keep things near current release of things. With that many users and courses, a cluster would probably be a better option. It also helps redundancy in the case of a failure. You have to be consistent in your delivery, you run a service business and that service needs to be run whenever the user needs it, not when it suits you. A cluster that load-shares is safer than a single instance.
Since this is about scaling, pl. continue the discussion in the "Hardware and Performance" http://moodle.org/mod/forum/discuss.php?d=171025