I should mention that I'm running Windows with MSSQL. I imagine the performance should be the same but there must be some differences of course.
I like the option of rackspace allowing for a dedicated server next to the cloud but I should probably give EC2 a few test runs of my own too. I think if EC2 is going to work it wont be an overnight solution. I'll have to move over slowly, learning to tune the box as I use it more.
Actually, you might want to try and get in on Microsoft's Azure beta.
As far as Windows Azure being early in its life, you are correct. However, it has been in beta for about a year and it is running Windows Server 2008, which has been in the market for almost two years. You may also want to look at the Windows Azure forums at http://bit.ly/MSDNWinAzureForum to get an idea of other people's experiences with it.
You can also get more info about Azure and its beta availability at http://bit.ly/WinAzurePlatformDevCenter
(Jason - working for M80, representing Microsoft)
Those databases are all on XLarge instances, so there is minimal sharing, and we've also gone to great lengths to make sure all of our normal queries are in indexes, so the disk gets hit less.
We also have a read slave for every database to alleviate read loads.
One thing you might want to do is run 'iostat -xtc' on your current box and put that in a log file. Then go back and analyze it and see what your average and peak reads and writes are. Amazon's max for a single EBS appears to be about 1000 ops / second (at least, that is what we were doing when they told us we maxed out the performance of the disk).
Good luck!
Edit: I forgot to mention that on all the database disks, we use ext2 and noatime. Both decrease the total number of writes necessary, and have very little downside (the biggest being that you have to fsck on a crash).