Page MenuHomePhabricator

Plan for FY20-21 Q1 fundraising database maintenance window
Open, Needs TriagePublic

Description

We have several proposed schema changes that can probably be batched together into one maintenance window. Date TBD.

  • drop several log_ tables and corresponding triggers (T257232)
  • delete log_ table data older than 1 year (?, still in discussion, see T257232)
  • delete old deleted contacts (?)
  • remove some indexes (?) (T247489)

Event Timeline

Jgreen created this task.Jul 14 2020, 12:49 PM
Jgreen moved this task from Triage to Up Next on the fundraising-tech-ops board.Jul 20 2020, 5:17 PM
DStrine moved this task from Triage to FR-Ops on the Fundraising-Backlog board.Jul 20 2020, 7:53 PM
Jgreen updated the task description. (Show Details)Aug 18 2020, 8:44 PM

During the maint window we removed some indexes as specified in T247489. They were almost instantaneous on the db cluster but took time to replicate to frdev. All completed before the end of the window.

Dwisehaupt updated the task description. (Show Details)Tue, Aug 25, 4:53 PM