search

mvysny / shepherd

Build & run apps automatically
1 stars 0 forks source link

Document a persistent database #9

Closed mvysny closed 1 year ago

mvysny commented 1 year ago

A PostgreSQL running on a persistent volume. Study and add an example.

mvysny commented 1 year ago
  1. How to create a persistent volume in Kubernetes, say 1GB in size?
  2. How to limit PostgreSQL database size in PostgreSQL, so that the database fails cleanly instead of ENOSPC?
  3. How to create a private network between PostgreSQL container and the main app container?
  4. What's the DNS mapping scheme, how to make those containers see each other?
mvysny commented 1 year ago

This article looks good: https://www.crunchydata.com/blog/stateful-postgres-storage-using-kubernetes

mvysny commented 1 year ago

On microk8s, the storage addon is an alias for hostpath-storage addon, and it is already enabled in Shepherd. Here's the documentation: https://microk8s.io/docs/addon-hostpath-storage

mvysny commented 1 year ago

Use https://github.com/mvysny/jdbi-orm-vaadin-crud-demo as an example app, after https://github.com/mvysny/jdbi-orm-vaadin-crud-demo/issues/29 is implemented.

mvysny commented 1 year ago

Documented at blog https://mvysny.github.io/kubernetes-vaadin-app-postgresql/

  1. Deploy jdbi-orm-vaadin-crud-demo with persistent postgresql on v-herd - done
  2. Document the config file in our own README.md