There are literally more Heroku folks in this thread than unaffiliated commenters :P well played.

Personally I'd just be happy with a master-master postgres db or sharding, for $money, where money is some amount enough to make that happen without me worrying about it.