Database Operators Field Notes

A database operator is not a database team in a container. It can reconcile StatefulSets, users, backups, replicas, failover, and certificates. It cannot decide your recovery objective, storage class risk, schema migration policy, or when data loss is acceptable. Those boundaries need to be explicit before production data lands in the cluster. Draw The Ownership Model Write down what each layer owns: database operator -> database cluster lifecycle and reconciliation storage layer -> persistent volume provisioning and attach/mount behavior backup system -> backup storage, retention, and restore mechanics application team -> schema migrations, connection behavior, and query load platform team -> node capacity, security policy, networking, and observability data owner -> RPO/RTO, retention, and data-loss acceptance If every issue is “the operator is broken,” the ownership model is not useful enough. ...

MySQL operators can hide a lot of useful machinery behind a simple custom resource. That is convenient until replication or restore becomes an incident. The operating goal is not just a Running primary. It is a database service whose replication, backup, and restore behavior are understood before the outage. Know The Topology Before trusting the operator, record the topology it creates: primary instance. replica instances. writer endpoint. reader endpoint, if used. replication mode. binlog retention or archive behavior. backup schedule and target. failover policy. The topology should be visible to operators without reading the operator source code. ...

PostgreSQL operators make cluster lifecycle easier, but they do not remove the need to prove backup and failover behavior. A healthy operator can still manage a database whose backups are stale, replicas lag, clients cannot reconnect, or restores have never been tested. Backup Readiness For PostgreSQL, backup readiness has two parts: a base backup and the ability to recover to an accepted point using WAL or the operator’s equivalent archive mechanism. ...