ummm a mysql database should be able to hand any load an MS SQL database could

http://www.eweek.com/article2/0,3959,293,00.asp

Granted this is two years old but I don't see how mysql could have fallen on such hard times.

If anything you need to make sure you have the hardware to handle the load and program the app right, mysql will take care of itself