How to make Rails use a database from another droplet?

Posted February 10, 2013 2.4k views
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.

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.

Submit an Answer
1 answer
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.

Configuring access to PostgreSQL should help you