Scaling to a million page views or so a day is not difficult. With the technologies available at hand there is less need for big hardware to do it. For instance you could grab a few Amazon EC2 nodes, use one as a balancer to the others. Grab nginx for the web server, proxy to your application, varnish for static caching. Alot is going to be determined by the way you access the database, there is no need to go to nosql when mysql can scale beyond your needs. Limit your queries, only select the data you need instead, use indexes, be smart about table structures.
If you ever do get to facebook/twitter like traffic, you'll probably have money and entire ops team to deal with it.