Question about Droplets and private networks

July 28, 2014 1.9k views
andy731073
By:
andy731073

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

Log In to Comment
1 Answer
asb MOD July 28, 2014

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

How To Set Up Master Slave Replication on PostgreSQL on an Ubuntu 12.04 VPS
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.
Reply
Have another answer? Share your knowledge.