Hacker News new | ask | show | jobs
by geoka9 363 days ago
> We have a second VM on a different cloud that has a streaming replication of the Postgres database.

How did you setup/secure the connection between the clouds?

1 comments

The network allows relevant ports from the respective IPs and so does the UFW so the servers can communicate between in each other in a restricted way. Needless to say communication is encrypted with certificates.

Our logging server will switch primary DB in case the original primary DB server is down. Since we are counting on downtime, the monitoring server is by default not hosted in the same places as the primary DB but in the same place as the secondary DB.

We assume that each clod will go down but not at the same time.