i am about to start an online service and am expecting good traffic, hence i am thinking of starting off with VPS servers. However, my question is when the traffic of the site increases to such an extent that the scaled up version of of VPS server cannot handle it.. Then at that time to switch to a dedicated server or a co- location would be difficult right.. because at that time the entire database will have to be transferred to the new location.. this will involve a major downtime for the site..
How is such situation handled so that the downtime involved is minimal ?