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.