You are browsing a read-only backup copy of Wikitech. The live site can be found at wikitech.wikimedia.org

Map of database maintenance: Difference between revisions

From Wikitech-static
Jump to navigation Jump to search
imported>Dexbot
m (Bot: Updating the report)
imported>Dexbot
m (Bot: Updating the report)
Line 1: Line 1:
{{/Header}}
{{/Header}}
== Today (2022-08-18) ==
== Today (2022-08-19) ==
== Yesterday (2022-08-17) ==
== Yesterday (2022-08-18) ==
{| class="wikitable"
{| class="wikitable"
|+ eqiad
|+ eqiad
|-
|-
! Section !! Work
! Section !! Work
|-
| s4 || [[phab:T312972|Rename index su_normalized on table spoofuser on wmf wikis (T312972)]] (marostegui)
|-
|-
| s5 || [[phab:T314041|Drop old templatelinks columns and indexes (T314041)]] (ladsgroup)
| s5 || [[phab:T314041|Drop old templatelinks columns and indexes (T314041)]] (ladsgroup)
|-
| s8 ||
* [[phab:T303603|Add actor and comment columns to cu_changes (T303603)]] (ladsgroup)
* [[phab:T309311|Make user_editcount unsigned in production (T309311)]] (ladsgroup)
* [[phab:T310485|Login (T310485)]] (ladsgroup)
* [[phab:T312863|Schema change to change primary key of templatelinks (T312863)]] (ladsgroup)
* [[phab:T314369|Switchover s8 master (db1104 -> db1109) (T314369)]] (ladsgroup)
* [[phab:T60674|Drop page.page_restrictions column from Wikimedia wikis (T60674)]] (ladsgroup)
|-
|-
|}
|}
Line 18: Line 28:
| s1 || [[phab:T314380|Switchover s1 master (db1163 -> db1118) (T314380)]] (ladsgroup)
| s1 || [[phab:T314380|Switchover s1 master (db1163 -> db1118) (T314380)]] (ladsgroup)
|-
|-
| s4 || [[phab:T312863|Schema change to change primary key of templatelinks (T312863)]] (ladsgroup)
| s4 ||  
* [[phab:T312863|Schema change to change primary key of templatelinks (T312863)]] (ladsgroup)
* [[phab:T312972|Rename index su_normalized on table spoofuser on wmf wikis (T312972)]] (marostegui)
|-
|-
| s5 || [[phab:T314041|Drop old templatelinks columns and indexes (T314041)]] (ladsgroup)
| s5 || [[phab:T314041|Drop old templatelinks columns and indexes (T314041)]] (ladsgroup)
|-
| s8 ||
* [[phab:T303603|Add actor and comment columns to cu_changes (T303603)]] (ladsgroup)
* [[phab:T309311|Make user_editcount unsigned in production (T309311)]] (ladsgroup)
* [[phab:T310485|Login (T310485)]] (ladsgroup)
* [[phab:T312863|Schema change to change primary key of templatelinks (T312863)]] (ladsgroup)
* [[phab:T314369|Switchover s8 master (db1104 -> db1109) (T314369)]] (ladsgroup)
* [[phab:T60674|Drop page.page_restrictions column from Wikimedia wikis (T60674)]] (ladsgroup)
|-
|-
|}
|}

Revision as of 00:00, 19 August 2022

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 (2022-08-19)

Yesterday (2022-08-18)

eqiad
Section Work
s4 Rename index su_normalized on table spoofuser on wmf wikis (T312972) (marostegui)
s5 Drop old templatelinks columns and indexes (T314041) (ladsgroup)
s8

Last seven days

eqiad
Section Work
s1 Switchover s1 master (db1163 -> db1118) (T314380) (ladsgroup)
s4
s5 Drop old templatelinks columns and indexes (T314041) (ladsgroup)
s8