Last Updated: February 25, 2016
·
10.36K
· dperrymorrow

Using External Database with Heroku

#rails
#heroku

Heroku is awsome as long as you dont need a large database or background jobs, then it gets expensive really quick.

Want to use an external database with heroku? It's pretty easy.

heroku config:add DATABASE_URL=mysql://user:pass@server:port/database_name

which is equivalent to...

[adapter]://[username]:[password]:[server_address]:[port]/[database_name]

this will setup your production database settings with the supplied information.

#rails
#heroku

Written by David Morrow

Say Thanks
Respond

Related protips

Avoid Heroku idling with New Relic pings

59.89K
16

1600% faster app requests with Rails on Heroku

36.35K
7

Free background jobs on heroku

27.79K
17

5 Responses
Add your response

mr_bhatt

Was hunting for exactly this. Thanks for the information.
Yep, the 10K limit for a free database on Heroku is like just for testing purposes.

over 1 year ago ·
dperrymorrow

glad you found it useful,

over 1 year ago ·
hugoerg56

thanks!

over 1 year ago ·
Saager Mhatre

Wait, does that mean that Heroku leaves the ports open to the public?!?

over 1 year ago ·
dperrymorrow

no i think it would be the other way around, you would have to have your database open to the outside to let your heroku app reach it.

when i did this it was a clear db mysql add on to heroku.

over 1 year ago ·

Have a fresh tip? Share with Coderwall community!

Post
Post a tip
Best #Rails Authors
sebastialonso
223.8K
#rails
#CSS
#JavaScript
sergiotapia
141.3K
#rails
#Ruby
#Elixir
jamesdullaghan
90.45K
#rails
#JavaScript
#Ruby
edokun_
87.62K
#rails
#Ruby
#Python
rorykoehler
78.89K
#rails
#Postgres
#Coffeescript
Related Tags
#rails
#heroku
Sponsored by
#native_company#
#native_desc#
#native_cta#
Filed Under
Ruby on Rails Development Tips
Awesome Job
See All Jobs
Post a job for only $299
Thanks to our sponsor
Sponsored by #native_company# — Learn More
#native_title# #native_desc#
#native_cta#