traditional host v cloud host for MySQL/PHP-based site [closed]

I am developing in MySQL and PHP (on my Mac). I am developing a new site with perhaps thousands of PHP pages. What are the comparative features of a traditional host (such as Zen, 1&1 etc) as opposed to a cloud host (such as Google, AWS etc)?