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-07-24) ==
== Today (2022-07-25) ==
{| class="wikitable"
== Yesterday (2022-07-24) ==
|+ eqiad
|-
! Section !! Work
|-
| s7 || [[phab:T312863|Schema change to change primary key of templatelinks (T312863)]] (ladsgroup)
|-
|}
== Yesterday (2022-07-23) ==
{| class="wikitable"
{| class="wikitable"
|+ eqiad
|+ eqiad
Line 16: Line 8:
|-
|-
| s2 || [[phab:T312863|Schema change to change primary key of templatelinks (T312863)]] (ladsgroup)
| s2 || [[phab:T312863|Schema change to change primary key of templatelinks (T312863)]] (ladsgroup)
|-
| s3 || [[phab:T312863|Schema change to change primary key of templatelinks (T312863)]] (ladsgroup)
|-
| s5 || [[phab:T312863|Schema change to change primary key of templatelinks (T312863)]] (ladsgroup)
|-
|-
| s7 || [[phab:T312863|Schema change to change primary key of templatelinks (T312863)]] (ladsgroup)
| s7 || [[phab:T312863|Schema change to change primary key of templatelinks (T312863)]] (ladsgroup)
Line 29: Line 17:
|-
|-
! Section !! Work
! Section !! Work
|-
| s1 || [[phab:T312984|Adjust the field type of flaggedpages.fp_pending_since to fixed binary on wmf wikis (T312984)]] (ladsgroup)
|-
|-
| s2 ||  
| s2 ||  
Line 53: Line 39:
* [[phab:T313383|Switchover s7 master db1181 -> db1136 (T313383)]] (marostegui)
* [[phab:T313383|Switchover s7 master db1181 -> db1136 (T313383)]] (marostegui)
|-
|-
| s8 ||  
| s8 || [[phab:T312990|Add columns geo_tags.gt_lat_int/gt_lon_int to unify schema on wmf wikis (T312990)]] (marostegui)
* [[phab:T311106|Investigate mariadb 10.6 performance regression during spikes/high load (T311106)]] (marostegui)
* [[phab:T312990|Add columns geo_tags.gt_lat_int/gt_lon_int to unify schema on wmf wikis (T312990)]] (marostegui)
* [[phab:T313070|Adjust the field type of wb_changes.change_time to fixed binary on wmf wikis (T313070)]] (marostegui)
|-
|-
| x1 || [[phab:T313398|Failover x1 master db1120 -> db1103 (T313398)]] (marostegui)
| x1 || [[phab:T313398|Failover x1 master db1120 -> db1103 (T313398)]] (marostegui)
Line 67: Line 50:
|-
|-
| s1 || [[phab:T311493|Productionize db2153.codfw.wmnet - db2174.codfw.wmnet (T311493)]] (marostegui)
| s1 || [[phab:T311493|Productionize db2153.codfw.wmnet - db2174.codfw.wmnet (T311493)]] (marostegui)
|-
| s5 || [[phab:T312863|Schema change to change primary key of templatelinks (T312863)]] (ladsgroup)
|-
|-
|}
|}

Revision as of 00:01, 25 July 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-07-25)

Yesterday (2022-07-24)

eqiad
Section Work
s2 Schema change to change primary key of templatelinks (T312863) (ladsgroup)
s7 Schema change to change primary key of templatelinks (T312863) (ladsgroup)

Last seven days

eqiad
Section Work
s2
s3
s5 Schema change to change primary key of templatelinks (T312863) (ladsgroup)
s6
s7
s8 Add columns geo_tags.gt_lat_int/gt_lon_int to unify schema on wmf wikis (T312990) (marostegui)
x1 Failover x1 master db1120 -> db1103 (T313398) (marostegui)
codfw
Section Work
s1 Productionize db2153.codfw.wmnet - db2174.codfw.wmnet (T311493) (marostegui)