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