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-09-02) ==
== Today (2022-09-03) ==
== Yesterday (2022-09-01) ==
== Yesterday (2022-09-02) ==
{| class="wikitable"
{| class="wikitable"
|+ eqiad
|+ eqiad
Line 7: Line 7:
! Section !! Work
! Section !! Work
|-
|-
| s4 || [[phab:T314041|Drop old templatelinks columns and indexes (T314041)]] (ladsgroup)
| s1 || [[phab:T316870|Move db1107 to s1 (T316870)]] (marostegui)
|-
| s7 || [[phab:T316111|Switchover s7 master (db1136 -> db1181) (T316111)]] (ladsgroup)
|-
|-
|}
|}
Line 17: Line 15:
! Section !! Work
! Section !! Work
|-
|-
| x2 || [[phab:T316482|Update wgLBFactoryConf for x2 to register only the local primary (T316482)]] (cdanis)
| s3 || [[phab:T316494|db2149 broken storage after reboot (T316494)]] (marostegui)
|-
| s4 || [[phab:T314041|Drop old templatelinks columns and indexes (T314041)]] (ladsgroup)
|-
|-
|}
|}
Line 26: Line 26:
! Section !! Work
! Section !! Work
|-
|-
| s1 || [[phab:T316186|Login (T316186)]] (ladsgroup)
| s1 ||  
* [[phab:T316186|Login (T316186)]] (ladsgroup)
* [[phab:T316870|Move db1107 to s1 (T316870)]] (marostegui)
|-
|-
| s2 || [[phab:T316186|Login (T316186)]] (ladsgroup)
| s2 || [[phab:T316186|Login (T316186)]] (ladsgroup)
|-
| s3 || [[phab:T316186|Login (T316186)]] (ladsgroup)
|-
|-
| s4 ||  
| s4 ||  
Line 60: Line 60:
| s2 || [[phab:T316186|Login (T316186)]] (ladsgroup)
| s2 || [[phab:T316186|Login (T316186)]] (ladsgroup)
|-
|-
| s3 || [[phab:T316186|Login (T316186)]] (ladsgroup)
| s3 || [[phab:T316494|db2149 broken storage after reboot (T316494)]] (marostegui)
|-
|-
| s4 || [[phab:T316186|Login (T316186)]] (ladsgroup)
| s4 ||  
* [[phab:T314041|Drop old templatelinks columns and indexes (T314041)]] (ladsgroup)
* [[phab:T316186|Login (T316186)]] (ladsgroup)
|-
|-
| s5 || [[phab:T316186|Login (T316186)]] (ladsgroup)
| s5 || [[phab:T316186|Login (T316186)]] (ladsgroup)
|-
| s7 || [[phab:T316186|Login (T316186)]] (ladsgroup)
|-
|-
| s8 || [[phab:T316186|Login (T316186)]] (ladsgroup)
| s8 || [[phab:T316186|Login (T316186)]] (ladsgroup)

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

Yesterday (2022-09-02)

eqiad
Section Work
s1 Move db1107 to s1 (T316870) (marostegui)
codfw
Section Work
s3 db2149 broken storage after reboot (T316494) (marostegui)
s4 Drop old templatelinks columns and indexes (T314041) (ladsgroup)

Last seven days

eqiad
Section Work
s1
s2 Login (T316186) (ladsgroup)
s4
s5 Login (T316186) (ladsgroup)
s6
s7 Switchover s7 master (db1136 -> db1181) (T316111) (ladsgroup)
s8 Login (T316186) (ladsgroup)
codfw
Section Work
s1
s2 Login (T316186) (ladsgroup)
s3 db2149 broken storage after reboot (T316494) (marostegui)
s4
s5 Login (T316186) (ladsgroup)
s8 Login (T316186) (ladsgroup)
x1 Switchover x1 codfw master (db2096 -> db2115) (T316522) (marostegui)
x2 Update wgLBFactoryConf for x2 to register only the local primary (T316482) (cdanis)