Hourly backup, only if something has changed

Sounds like streaming replication is what we want here, to me.

Run the forum on cheap server #1, streaming replicate to cheap server #2, if server #1 goes down, then:

  • stop replication from #1 to #2 (it already isn’t working, but remove the setup)
  • set up discourse on server #3
  • point DISCOURSE_DB_HOST on #3 to #2 (and rebuild)
  • take a backup on #3 using #2 as database
  • remove DISCOURSE_DB_HOST from #3 container definition (and rebuild)
  • restore backup on #3 using #3 as database
  • switch over DNS
  • re-set up streaming replication from #3 to #2

Certainly not a setup for the faint of heart when it comes to ops.

2 Likes