Page MenuHomePhabricator

Orchestrator db logical backups
Closed, ResolvedPublic

Description

Orchestrator primary database lives on db2093 under its own name: orchestrator.
It is still early to think about backups, but at some point we'd like to get it on our logical backups.

At this point it is just 6MB

root@db2093:/srv/sqldata# du -sh orchestrator/
5.9M	orchestrator/

Event Timeline

Marostegui changed the task status from Open to Stalled.Oct 28 2020, 8:25 AM
Marostegui triaged this task as Medium priority.
Marostegui moved this task from Triage to Blocked on the DBA board.
Marostegui moved this task from Triage to Blocked on the Data-Persistence-Backup board.

I have added it to the logical backup process by adding the right grants to the existing dump user/process to the new database, but let's revisit once people working on the setup are happy with the deployment.

Marostegui assigned this task to jcrespo.
Marostegui added a subscriber: Kormat.

I am going to close this as resolved. I have checked the backups at dbprov2003 and they look good.
orchestrator.database_instance.sql.gz looks good and has the correct data.

Thanks!