How to use Drupal in the cloud with on demand instances
Rackspace put together a pretty decent start to this subject here which uses a couple of specific technologies which you might not want to use, but the principles are the same.

You might also need to look at Mysql clustering, but only really if you're hitting serious traffic levels