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

Today (2024-05-02)

eqiad

Section	Work
s4	Create cuc_agent_id, cule_agent_id and cupe_agent_id columns in cu_changes, cu_log_event and cu_private_event tables respectively on WMF wikis (T361627) (marostegui)
s7	Switchover s7 master (db1181 -> db1236) (T363892) (marostegui)

codfw

Section	Work
s4	Create cuc_agent_id, cule_agent_id and cupe_agent_id columns in cu_changes, cu_log_event and cu_private_event tables respectively on WMF wikis (T361627) (marostegui)

Yesterday (2024-05-01)

eqiad

Section	Work
s1	Reimage and reclone db1234 (T363890) (marostegui)
s7	Create cuc_agent_id, cule_agent_id and cupe_agent_id columns in cu_changes, cu_log_event and cu_private_event tables respectively on WMF wikis (T361627) (marostegui)

codfw

Section	Work
s7	Create cuc_agent_id, cule_agent_id and cupe_agent_id columns in cu_changes, cu_log_event and cu_private_event tables respectively on WMF wikis (T361627) (marostegui)

Last seven days

eqiad

Section	Work
es5	Switchover es5 master (es1023 -> es1024) (T361548) (marostegui)
s1	Reimage and reclone db1234 (T363890) (marostegui)
s3	Gradually drop old pagelinks columns (T352010) (ladsgroup) Switchover s3 master (db1157 -> db1223) (T363672) (marostegui)
s4	Create cuc_agent_id, cule_agent_id and cupe_agent_id columns in cu_changes, cu_log_event and cu_private_event tables respectively on WMF wikis (T361627) (marostegui)
s5	Create cuc_agent_id, cule_agent_id and cupe_agent_id columns in cu_changes, cu_log_event and cu_private_event tables respectively on WMF wikis (T361627) (marostegui)
s7	Create cuc_agent_id, cule_agent_id and cupe_agent_id columns in cu_changes, cu_log_event and cu_private_event tables respectively on WMF wikis (T361627) (marostegui) Upgrade s7 to MariaDB 10.6 (T362745) (marostegui) Switchover s7 master (db1181 -> db1236) (T363892) (marostegui)

codfw

Section	Work
s1	Gradually drop old pagelinks columns (T352010) (ladsgroup)
s4	Make the cupe_actor column nullable on WMF wikis (T360332) (arnaudb) Create cuc_agent_id, cule_agent_id and cupe_agent_id columns in cu_changes, cu_log_event and cu_private_event tables respectively on WMF wikis (T361627) (marostegui) Switchover s4 master (db2179 -> db2140) (T363688) (arnaudb)
s5	Create cuc_agent_id, cule_agent_id and cupe_agent_id columns in cu_changes, cu_log_event and cu_private_event tables respectively on WMF wikis (T361627) (marostegui)
s6	Switchover s6 master (db2114 -> db2129) (T363713) (arnaudb)
s7	Make the cupe_actor column nullable on WMF wikis (T360332) (arnaudb) Create cuc_agent_id, cule_agent_id and cupe_agent_id columns in cu_changes, cu_log_event and cu_private_event tables respectively on WMF wikis (T361627) (marostegui) Switchover s7 master (db2121 -> db2218) (T363668) (marostegui)
s8	Gradually drop old pagelinks columns (T352010) (ladsgroup)