Database Hosting

[ssoriche]

Depending on the hosting solution, there are two options. If we're hosting with DigitalOcean, they offer a hosted PostgreSQL service starting at $15/month. This removes the requirement of running the server ourselves and offloads the processing and storage requirements from our servers.

Staying with hosting in kubernetes ourselves, there's the CloudNativePG operator https://cloudnative-pg.io/. This operator creates the database servers, replicas and sets up replication and failure over based on a database declaration in the kubernetes manifests.

[ranguard]

https://docs.digitalocean.com/products/platform/availability-matrix/ suggests we could run it in Frankfurt (new Hetzner) and you can access it over the public internet... so we could go with DigitalOcean for PostgreSQL even if we don't use them for anything else..

We would have to do this as part of moving metacpan-api to K8's - but no reason someone couldn't work on this now?, other than we would want a different database in the cluster for LW and BM, then would just setup a new one for Hetzner.

@ssoriche thoughts?

Side notes... I did look at serverless offerings as well, but feel we probably want something running most of the time so would end up paying more for the compute cost...

• https://neon.tech/pricing#compute-hour
• https://xata.io/pricing

[ranguard]

Created #59 to setup CloudNativePG - as we want postgres and managing Digial Ocean separately just for Pg wouldn't be sensible