Question

How to make Rails use a database from another droplet?

  • Posted February 10, 2013

Separating the database from the actual Rails app is probably the first thing everyone will do when they want to scale their app, but stiil, I’m unable to find a tutorial on how to do it. It will be great if you can include one in the “Articles and Tutorials” section or at least give me a link to a page that explains how to solve this problem. Thanks.

PS: I’ll probably use Nginx as an web server, PostgreSQL as RDBMS so it’s better if the tutorial will use them.

Subscribe
Share

Submit an answer
You can type!ref in this text area to quickly search our full set of tutorials, documentation & marketplace offerings and insert the link!

These answers are provided by our Community. If you find them useful, show some love by clicking the heart. If you run into issues leave a comment, or add your own answer to help others.

First, in your rails application, edit database.yml to point to your other droplet’s IP, database name, user, password… etc. Secondly, in your database droplet, make sure you allow access to that user from your other droplet. <br> <br>Configuring access to PostgreSQL should help you http://www.dcache.org/manuals/Book-1.9.12/cookbook/cb-postgres-configure.shtml <br> <br>