Database Architecture
Overview
Single PostgreSQL RDS instance with three schemas:
| Schema | Product | Entities |
|---|---|---|
public / statuspages | Statux Pages | Status pages, components, incidents |
alerts | Statux Alerts | Alerts, incidents, teams, schedules |
synthetics | Statux Synthetics | Checks, results, relays |
core | Shared | Organizations, users, subscriptions |
RDS Configuration
- Engine: PostgreSQL 15
- Instance: db.t3.micro (prod)
- Multi-AZ: Enabled
- Encryption: Enabled at rest
- Backups: 7-day retention
VPC Isolation
Database VPC (10.1.0.0/16) is fully private:
- No internet gateway
- Accessed via VPC peering from Application VPC
- Bastion access via Access VPC