codefordenver / hawthorn-client

Hawthorn is based on the concept of affinity groups, a group of individuals who come together around a shared experience, interest or common goal. With Hawthorn affinity groups, you are free to start or join conversations and share useful resources with people in your community.
http://hawth.org
Apache License 2.0
2 stars 1 forks source link

Migrate to a managed database #39

Closed trex closed 4 years ago

trex commented 4 years ago

The postgresql database is running on the local server, colocated with the Hawthorn web application. When Digital Ocean performed some emergency maintenance on the physical hardware where the droplet is hosted on January 14 it resulted in complete data loss of the Hawthorn database.

We can move to a managed database that lives on separate servers, has redundancy and regular snapshots so that the application is more resilient to dataloss going forward.

trex commented 4 years ago

I created a managed database in DigitalOcean and the authentication service writes it's database there. We now just need to migrate the application database over to the managed database service.

trex commented 4 years ago

This is done.