Anyone used Amazon EC2 with a database or other high IO operation?
qhoxie: We have a highly trafficked and large dataset that we aimed to move from our datacenter to EC2.  This is all in MySQL.  Upon doing so, we had to spend significant effort trying to get our system stable and we ended up narrowing it down to EBS simply not being able to handle the IOPS we needed.We explored all the options available and worked with both Percona and Amazon on the issues, but it was clear that EBS and EC2 just are not meant to handle such load.  Our database is currently back running in our datacenter.There have been a number of reports with similar results using EBS.  It all depends on your particular IO profile, but since you said it was high, I encourage you to tread lightly.If you want more information you are welcome to email me.