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-05) ==
== Today (2022-07-06) ==
== Yesterday (2022-07-04) ==
== Yesterday (2022-07-05) ==
{| class="wikitable"
{| class="wikitable"
|+ eqiad
|+ eqiad
Line 7: Line 7:
! Section !! Work
! Section !! Work
|-
|-
| s5 ||  
| s1 || [[phab:T311106|Investigate mariadb 10.6 performance regression during spikes/high load (T311106)]] (ladsgroup)
* [[phab:T305300|Add lu_attachment_method column to localuser table (T305300)]] (ladsgroup)
|-
* [[phab:T312027|Fix enwikivoyage drifts on pagelinks (T312027)]] (ladsgroup)
| s6 ||
* [[phab:T298557|Fix mismatching field type of page.page_touched on wmf wikis (T298557)]] (marostegui)
* [[phab:T311522|Switchover s6 master db1131 -> db1173 (T311522)]] (marostegui)
|-
|-
|}
|}
Line 19: Line 21:
|-
|-
| s1 ||  
| s1 ||  
* [[phab:T298560|Fix mismatching field type of revision.rev_timestamp on wmf wikis (T298560)]] (ladsgroup)
* [[phab:T309311|Make user_editcount unsigned in production (T309311)]] (ladsgroup)
* [[phab:T309311|Make user_editcount unsigned in production (T309311)]] (ladsgroup)
* [[phab:T311106|Investigate mariadb 10.6 performance regression during spikes/high load (T311106)]] (ladsgroup)
|-
|-
| s3 ||  
| s3 ||  
* [[phab:T307525|Fix mismatching field type of user table for columns user_newpassword, user_password, user_email on wmf wikis (T307525)]] (ladsgroup)
* [[phab:T307525|Fix mismatching field type of user table for columns user_newpassword, user_password, user_email on wmf wikis (T307525)]] (ladsgroup)
* [[phab:T309311|Make user_editcount unsigned in production (T309311)]] (ladsgroup)
* [[phab:T309311|Make user_editcount unsigned in production (T309311)]] (ladsgroup)
|-
| s4 || [[phab:T309311|Make user_editcount unsigned in production (T309311)]] (ladsgroup)
|-
|-
| s5 ||  
| s5 ||  
Line 32: Line 32:
* [[phab:T312027|Fix enwikivoyage drifts on pagelinks (T312027)]] (ladsgroup)
* [[phab:T312027|Fix enwikivoyage drifts on pagelinks (T312027)]] (ladsgroup)
|-
|-
| s6 || [[phab:T310595|db1173 won't boot up (T310595)]] (marostegui)
| s6 ||  
* [[phab:T298557|Fix mismatching field type of page.page_touched on wmf wikis (T298557)]] (marostegui)
* [[phab:T311522|Switchover s6 master db1131 -> db1173 (T311522)]] (marostegui)
|-
|-
| s8 || [[phab:T309311|Make user_editcount unsigned in production (T309311)]] (ladsgroup)
| s8 || [[phab:T309311|Make user_editcount unsigned in production (T309311)]] (ladsgroup)
|-
|-
| x1 || [[phab:T300472|Switchover x1 master (db1103 -> db1120) (T300472)]] (marostegui)
| x1 || [[phab:T300472|Switchover x1 master (db1103 -> db1120) (T300472)]] (marostegui)
|-
|}
{| class="wikitable"
|+ codfw
|-
! Section !! Work
|-
| s1 ||
* [[phab:T311475|Decommission db[2071-2092] (T311475)]] (marostegui)
* [[phab:T311589|decommission db2071 (T311589)]] (marostegui)
|-
| s5 ||
* [[phab:T311475|Decommission db[2071-2092] (T311475)]] (marostegui)
* [[phab:T311591|decommission db2075 (T311591)]] (marostegui)
|-
|-
|}
|}

Revision as of 00:00, 6 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-06)

Yesterday (2022-07-05)

eqiad
Section Work
s1 Investigate mariadb 10.6 performance regression during spikes/high load (T311106) (ladsgroup)
s6

Last seven days

eqiad
Section Work
s1
s3
s5
s6
s8 Make user_editcount unsigned in production (T309311) (ladsgroup)
x1 Switchover x1 master (db1103 -> db1120) (T300472) (marostegui)