Map of database maintenance

From Wikitech

Here you can follow maintenance on our databases. This is useful to spot potential causes for issues in production or avoid interfering with another maintenance work.

A script parses dbctl SAL logs and add entries here. Furthermore, DBAs can add manual entries in this list by logging SAL. It is important that SAL must contain the word "dbmaint", a phabricator ticket id, a section name and name of the datacenter. For example: "!log dbmaint on s2@codfw (T12345)"

Today (2024-04-15)

eqiad
Section Work
s7 Drop cl_collation_ext index from categorylinks in production (T356166) (marostegui)

Yesterday (2024-04-14)

Last seven days

eqiad
Section Work
s1 Make the cupe_actor column nullable on WMF wikis (T360332) (arnaudb)
s2
s3
s4 Drop cl_collation_ext index from categorylinks in production (T356166) (marostegui)
s6 Make the cupe_actor column nullable on WMF wikis (T360332) (arnaudb)
s7 Drop cl_collation_ext index from categorylinks in production (T356166) (marostegui)
codfw
Section Work
s1 Make the cupe_actor column nullable on WMF wikis (T360332) (arnaudb)
s2 Make the cupe_actor column nullable on WMF wikis (T360332) (arnaudb)
s3 Make the cupe_actor column nullable on WMF wikis (T360332) (arnaudb)
s4
s5 Upgrade s5 to MariaDB 10.6 (T360116) (arnaudb)
s6 Switchover s6 master (db2129 -> db2114) (T362302) (arnaudb)