ROR Hosting having functionality like heroku and MySQL DBMS

I've bought a script which uses rails 2.3.5 and MySQL.

I deployed it on my computer and it was working fine but when I uploaded that script on heroku, some functionality does not work. When I checked the heroku logs, I realized that most of the errors were related to PostgreSQL.

I tried other hosting services but most of them don't let us install gems or they have a peculiar process for installing gems where we have to contact their admins for required gems.

Is there any other hosting service which has MySQL DBMS and which w开发者_开发百科ill allow us to install gems directly on their server?

Have you thought about using Heroku with a mysql Amazon RDS instance? Costs might be a bit non-trivial, starting at around $0.11 per hour, but it should do what you need. If budgets are tight, you could look at running mysql on a micro instance yourself (more complex to set up, but cheaper to run).

Either way, you can configure your Heroku application to connect to the mysql instance and pull data from there instead of your Heroku database. Should perform pretty well, as Heroku (currently at least) runs inside Amazon EC2.

I haven't had the chance to use it yet, but look into Cloud Foundry. It's fairly new and not as polished as Heroku, but their services include MySQL, Redis, and MongoDB data services.

you could try and get an invite for dotcloud, but it's still beta - it let's you choose from many different components to build you application on - mysql is one of them :)

I just saw an ad of Engine Yard on this very page. It looks promising. It has a graphical interface for installing gems and it lets us choose between MySQL and PostgrSQL.

Engine Yard