Configure Databases

Database components create managed relational databases for StationOps environments. Configure the engine once, then size, protect, and retain it appropriately in each environment.

Create a Database

1. Open an infrastructure configuration and select Add component > Database.
2. Enter a stable component name.
3. Select PostgreSQL, MySQL, or MariaDB and choose an available version.
4. Select quick metrics and any additional operational metrics.
5. Configure credentials and password handling.
6. Open each environment tab and configure instance capacity, backup retention, port, public access, and removal policy.
7. Save the component.

Environment Controls

• Instance type controls CPU and memory. Use separate sizing decisions for non-production and production.
• Backup retention determines how long automated backups remain available.
• Public access makes network exposure possible. Leave it disabled unless an external client genuinely requires it and network rules are restricted.
• Port should match the engine and application client configuration.
• Removal policy can delete, retain, or snapshot the database when the component is removed.

Connect a Service

Grant access only to the services that use the database. In the service's environment variables, select the database-derived host, port, username, and password values instead of copying generated connection details.

Keep schema migrations backward compatible with the previous application release so a deployment can roll forward or back safely.

Operational Checklist

• Test restore procedures, not only backup creation.
• Monitor storage, connections, latency, and CPU.
• Avoid public access where VPC connectivity is sufficient.
• Review engine-version support before upgrading.
• Verify removal policy in every environment.