Automate nightly MySQL backups with retention #28

Open
opened 2026-07-01 01:01:41 +00:00 by manlycucumber · 0 comments
manlycucumber commented 2026-07-01 01:01:41 +00:00 (Migrated from github.com)

Problem

Tenant keys, quotas, and audit data live in MySQL. We need automated, retained backups to survive data loss on DreamHost.

Acceptance criteria

  • A scheduled job dumps the MySQL database nightly to off-host storage
  • Backups follow a retention policy (e.g. daily for N days, weekly for M weeks)
  • Backup success/failure is reported to operators
  • Backup artifacts are access-controlled and not publicly reachable
## Problem Tenant keys, quotas, and audit data live in MySQL. We need automated, retained backups to survive data loss on DreamHost. ## Acceptance criteria - [ ] A scheduled job dumps the MySQL database nightly to off-host storage - [ ] Backups follow a retention policy (e.g. daily for N days, weekly for M weeks) - [ ] Backup success/failure is reported to operators - [ ] Backup artifacts are access-controlled and not publicly reachable
Sign in to join this conversation.
No milestone
No project
No assignees
1 participant
Notifications
Due date
The due date is invalid or out of range. Please use the format "yyyy-mm-dd".

No due date set.

Dependencies

No dependencies set.

Reference
Directorium/Site#28
No description provided.