Hi,
Some of my colleagues have been looking at the following site
http://moodle.org/mod/forum/discuss.php?d=25852
and
It looks to me that the second site is looking at older versions of MySQL and Postgres
however they are still a little concerned about the stability of our Moodle setup.
It's currently hosted on a Windows server (2003, I think) with MySQL installed.
We currently have around 13,000 registered users, although we're expecting many of them to be essentially dormant.
What concerns us most is quotes like "MySQL will fall over with about 40-50 concurrent connections".
Now, is this old info, and MySQL has improved since then?
I understand it is possible to limit connections in apache. Is the same true of IIS?
Basically, I don't want to be left red-faced when Moodle goes live here. There are already a lot of people waiting for it to fail, as it's open source.
What concerns us most is quotes like "MySQL will fall over with about 40-50 concurrent connections".
I wouldn't take too much notice of statements like that. MySQL supports some of the busiest web sites on the planet.
You may find more useful information at
http://highperformancemysql.com/
Marcus