You are browsing a read-only backup copy of Wikitech. The primary 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-02) ==
== Today (2022-08-03) ==
== Yesterday (2022-08-01) ==
== Yesterday (2022-08-02) ==
{| class="wikitable"
{| class="wikitable"
|+ eqiad
|+ eqiad
Line 7: Line 7:
! Section !! Work
! Section !! Work
|-
|-
| s3 || [[phab:T314041|Drop old templatelinks columns and indexes (T314041)]] (ladsgroup)
| s3 || [[phab:T314377|Add primary key and drop unique index on revtag on wmf wikis (T314377)]] (marostegui)
|-
| s6 || [[phab:T312972|Rename index su_normalized on table spoofuser on wmf wikis (T312972)]] (marostegui)
|-
| s7 || [[phab:T314377|Add primary key and drop unique index on revtag on wmf wikis (T314377)]] (marostegui)
|-
| s8 || [[phab:T314377|Add primary key and drop unique index on revtag on wmf wikis (T314377)]] (marostegui)
|-
| x1 || [[phab:T314087|Add primary key and drop unique index on cx_translators on wmf wikis (T314087)]] (marostegui)
|-
|-
|}
|}
Line 23: Line 31:
* [[phab:T314140|Add primary key and drop unique index on translate_messageindex on wmf wikis (T314140)]] (marostegui)
* [[phab:T314140|Add primary key and drop unique index on translate_messageindex on wmf wikis (T314140)]] (marostegui)
* [[phab:T314141|Add primary key and drop unique index on translate_tmt wmf wikis (T314141)]] (marostegui)
* [[phab:T314141|Add primary key and drop unique index on translate_tmt wmf wikis (T314141)]] (marostegui)
* [[phab:T314377|Add primary key and drop unique index on revtag on wmf wikis (T314377)]] (marostegui)
|-
|-
| s4 ||  
| s4 ||  
* [[phab:T312990|Add columns geo_tags.gt_lat_int/gt_lon_int to unify schema on wmf wikis (T312990)]] (marostegui)
* [[phab:T314140|Add primary key and drop unique index on translate_messageindex on wmf wikis (T314140)]] (marostegui)
* [[phab:T314140|Add primary key and drop unique index on translate_messageindex on wmf wikis (T314140)]] (marostegui)
* [[phab:T314141|Add primary key and drop unique index on translate_tmt wmf wikis (T314141)]] (marostegui)
* [[phab:T314141|Add primary key and drop unique index on translate_tmt wmf wikis (T314141)]] (marostegui)
|-
|-
| s7 || [[phab:T314140|Add primary key and drop unique index on translate_messageindex on wmf wikis (T314140)]] (marostegui)
| s6 || [[phab:T312972|Rename index su_normalized on table spoofuser on wmf wikis (T312972)]] (marostegui)
|-
|-
| s8 || [[phab:T314140|Add primary key and drop unique index on translate_messageindex on wmf wikis (T314140)]] (marostegui)
| s7 ||
* [[phab:T314140|Add primary key and drop unique index on translate_messageindex on wmf wikis (T314140)]] (marostegui)
* [[phab:T314377|Add primary key and drop unique index on revtag on wmf wikis (T314377)]] (marostegui)
|-
| s8 ||  
* [[phab:T314140|Add primary key and drop unique index on translate_messageindex on wmf wikis (T314140)]] (marostegui)
* [[phab:T314377|Add primary key and drop unique index on revtag on wmf wikis (T314377)]] (marostegui)
|-
| x1 || [[phab:T314087|Add primary key and drop unique index on cx_translators on wmf wikis (T314087)]] (marostegui)
|-
|-
|}
|}
Line 38: Line 54:
|-
|-
! Section !! Work
! Section !! Work
|-
| s8 || [[phab:T313798|Switchover s8 codfw master (T313798)]] (marostegui)
|-
|-
| x2 || [[phab:T313811|Switchover x2 master db2142 -> db2143 (T313811)]] (marostegui)
| x2 || [[phab:T313811|Switchover x2 master db2142 -> db2143 (T313811)]] (marostegui)

Revision as of 00:01, 3 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-03)

Yesterday (2022-08-02)

eqiad
Section Work
s3 Add primary key and drop unique index on revtag on wmf wikis (T314377) (marostegui)
s6 Rename index su_normalized on table spoofuser on wmf wikis (T312972) (marostegui)
s7 Add primary key and drop unique index on revtag on wmf wikis (T314377) (marostegui)
s8 Add primary key and drop unique index on revtag on wmf wikis (T314377) (marostegui)
x1 Add primary key and drop unique index on cx_translators on wmf wikis (T314087) (marostegui)

Last seven days

eqiad
Section Work
s1 Add columns geo_tags.gt_lat_int/gt_lon_int to unify schema on wmf wikis (T312990) (marostegui)
s3
s4
s6 Rename index su_normalized on table spoofuser on wmf wikis (T312972) (marostegui)
s7
s8
x1 Add primary key and drop unique index on cx_translators on wmf wikis (T314087) (marostegui)
codfw
Section Work
x2 Switchover x2 master db2142 -> db2143 (T313811) (marostegui)