Hello
Except the secheduler job(s) you can do everything in MySQL. In most of the cases, MySQL will perform better then what you expected 😀
For the schedued job you can write your own app that will run as a service and do your job.
SQLyog has been tested to work under such condition(s) and it has come out with flying colours. Many of our customers have used it in even more heavy situation and didnt have any problem.
Best of all, SQLyog and MySQL are FREE !!! 😀
HTH