Data & Observability
The stateful side: tuned PostgreSQL and MariaDB servers with per-app credentials, plus shipping cluster and database logs into the central log store.
Three databases, on purpose
The platform runs three relational databases — PostgreSQL (10.100.100.13), MariaDB (10.100.100.14...
Tuning a database for the hardware it has
A freshly installed database ships with cautious, generic defaults. On a box you've sized deliber...
Every app gets its own credentials
This is a hard rule in the lab: no application ever connects as the database admin. Each app gets...
Seeing what the cluster is doing: logs to Loki
The lab already had a central log store (Loki — see its book in Core Infrastructure), with a Prom...
Lessons on data and observability
Match storage to the workload: databases get local disk on dedicated VMs, never NFS. Tune for th...