CODEWITHSUNDEEP
ruby-on-railsdatabaseheroku
Josh Grinberg
Josh Grinberg

Reputation: 523

How do I deploy my rails app to Heroku using an existing SQL database?

I have an existing MySQL database and would like to build a Rails app on top of it. How do I deploy my app to Heroku but still use my existing database instead of the default PostgreSQL database?

EDIT Rephrasing the question slightly (formerly, it was "Is it possible to deploy...").

Upvotes: 2

Views: 476

Answers (2)

mrtriangle
mrtriangle

Reputation: 544

Yes, although Heroku recommends that you use PostgreSQL, it is possible to migrate MySQL to Postgres with their service. They have an article in their docs for just such a scenario: https://devcenter.heroku.com/articles/heroku-mysql

They recommend you first install the http://rubygems.org/gems/mysql2psql gem

If your needs are MySQL specific and you have to use heroku clearDB has and addon https://addons.heroku.com/cleardb that you can use with your heroku app.

Upvotes: 0

Andrew Gorcester
Andrew Gorcester

Reputation: 19963

Yes. You can configure your application any way you like including specifying a non-Heroku database in your config file, and including using the default Heroku paradigm of using environment variables for config but with manually set database URLs in the environment variables.

You can either continue hosting your MySQL database separately, or migrate your data to a MySQL database hosted within the Heroku platform, like ClearDB (provided as a Heroku add-on).

Upvotes: 1

Related Questions