Map of database maintenance

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)"

Last seven days

eqiad

Section	Work
s1	Change page.page_links_updated to fixed-length timestamp in wmf wikis (T371742) (ladsgroup)
s8	Drop deprecated abuse filter fields on wmf wikis (T367781) (arnaudb)

codfw

Section	Work
es2	Migrate servers in codfw racks C6 & C7 from asw to lsw (T373101) (arnaudb)
es3	Migrate codfw row C & D database hosts to new Leaf switches (T370852) (arnaudb) Migrate servers in codfw racks C6 & C7 from asw to lsw (T373101) (arnaudb)
es4	Migrate servers in codfw racks C6 & C7 from asw to lsw (T373101) (arnaudb)
es7	Migrate servers in codfw racks C6 & C7 from asw to lsw (T373101) (arnaudb) Switchover es7 master (es2039 -> es2038) (T374592) (arnaudb)
pc5	Bring pc5 into rotation (T374496) (ladsgroup)
s1	Change page.page_links_updated to fixed-length timestamp in wmf wikis (T371742) (ladsgroup) Migrate servers in codfw racks C6 & C7 from asw to lsw (T373101) (arnaudb)
s3	Remove cuc_actiontext, cuc_only_for_read_old, and cuc_private from cu_changes on WMF wikis (T370903) (ladsgroup) Migrate servers in codfw racks C6 & C7 from asw to lsw (T373101) (arnaudb) Switchover s3 master (db2209 -> db2205) (T374421) (arnaudb)
s4	Change page.page_links_updated to fixed-length timestamp in wmf wikis (T371742) (ladsgroup) Migrate servers in codfw racks C6 & C7 from asw to lsw (T373101) (arnaudb) Switchover s4 master (db2140 -> db2179) (T373330) (arnaudb) Switchover s4 master (db2179 -> db2140) (T374512) (arnaudb)
s5	Drop deprecated abuse filter fields on wmf wikis (T367781) (arnaudb) Remove cuc_actiontext, cuc_only_for_read_old, and cuc_private from cu_changes on WMF wikis (T370903) (ladsgroup) Migrate servers in codfw racks C4 & C5 from asw to lsw (T373097) (arnaudb) Migrate servers in codfw racks C6 & C7 from asw to lsw (T373101) (arnaudb) Switchover s5 master (db2123 -> db2213) (T374086) (arnaudb)
s6	Migrate servers in codfw racks C6 & C7 from asw to lsw (T373101) (arnaudb)
s7	Remove cuc_actiontext, cuc_only_for_read_old, and cuc_private from cu_changes on WMF wikis (T370903) (ladsgroup) Migrate servers in codfw racks C4 & C5 from asw to lsw (T373097) (arnaudb) Migrate servers in codfw racks C6 & C7 from asw to lsw (T373101) (arnaudb) Switchover s7 master (db2220 -> db2218) (T373175) (arnaudb)
s8	Migrate servers in codfw racks C4 & C5 from asw to lsw (T373097) (arnaudb) Migrate servers in codfw racks C6 & C7 from asw to lsw (T373101) (arnaudb)
x1	Migrate servers in codfw racks C6 & C7 from asw to lsw (T373101) (arnaudb)