I was on the (gs) grid service with a bunch of smaller MODx websites and I was satisfied
for years. Even as the (gs) reported
serious issues and a lot of maintenance was going on.
http://www.newlocalmedia.com/blog/107-host-review-media-temple.html
But then I too started getting 100+ db connection errors per month and extremely high latency. I tried using a separate MySQL container.
It was nice for a week, then it went back to the same ole errors and slowness. And when they had security issues they ran a weird front-end security
scan on my site!¿ (I bot-trapped my own host IP...) I also experienced this
http://bit.ly/fXLN1Z 
...I asked if he got an answer:
http://twitter.com/dhollander/status/22775334415896576 !!!
Every attempt discussing the latency matter would return in a blame game. They asked me to modify MODx Evo’s config and core files. >:(
So I let
@amdbuilder, site5 CEO
@BenAtSite5 + the ad (see footer)
convince me!

Now I’m on the
shared cloud hosting
and haven’t seen one single db connection error. I’m super pleased with the siteadmin tools and backend.
PHP and MySQL runs 79% faster for me here. But I never tried caching the database on the grid as @opengeek suggested.
//After tweeting about this I received a very professional reply:
http://twitter.com/mediatemple/status/22835227474788353
Thank You (mt) for years of super awesome hosting!

Hopefully we all get a better 2011
//February 2011: When Site5 got into huge problems and I experienced extreme downtime, they did not only kept to their guarantee but compensated me above it!