Question about Droplets and private networks

July 28, 2014 1.7k views

I have a web app running on DO now with a postgres backend. I'd like to setup a reporting server that will contain a replicated copy of the db. Can you explain to me, or provide an article how two droplets on my account communicate securely on your platform.
Regards,
Andy

1 Answer

So there are a few parts to this. First you need to enable private networking on your droplets:

Set Up And Use DigitalOcean Private Networking

Then, you need to get your PostgreSQL replication running:

Set Up Master Slave Replication on PostgreSQL

Finally, you need to set up a firewall so that the only connections allowed to the droplet with the replicated copy are via the private network:

Isolate Servers Within A Private Network Using IPTables

by Justin Ellingwood
PostgreSQL, or postgres, is a popular database management system often used to manage the information from websites and applications. In this guide, we will configure a master server postgres replication set up, which will allow us to replicate the changes from the master server onto the slave. This can be used to distribute reads to multiple machines.
Have another answer? Share your knowledge.