Preparing your design workspace

Loading the problem and your latest saved attempt…

Database-Per-Project Control Plane

Design fast, isolated provisioning and lifecycle management for one PostgreSQL database per customer project.

Problem statement

For this exercise, assume every customer project receives an isolated PostgreSQL database, credentials, network policy, backups, replicas, quotas, and a selected region.

The control plane should provision quickly, expose asynchronous lifecycle state, rotate credentials, resize safely, restore to a point in time, and delete with a recovery window. Exclude implementing the PostgreSQL engine and cloud block storage.

What to build

  1. Create a project database from a versioned template with isolated identity, network, and storage.
  2. Resize, pause, resume, rotate credentials, and observe operation progress idempotently.
  3. Create verified backups, restore to a new occurrence, and perform delayed auditable deletion.

At scale

  • Provision 10,000 new projects per hour across multiple regions.
  • Return durable operation acceptance below 500 ms and make a small database ready within 60 seconds at p95.
  • No credentials, network path, backup, or storage volume may cross project ownership.
  • Control-plane retry or failover must not create an untracked second billable database occurrence.