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-15) ==
== Today (2022-09-16) ==
== Yesterday (2022-09-14) ==
== Yesterday (2022-09-15) ==
{| class="wikitable"
{| class="wikitable"
|+ eqiad
|+ eqiad
|-
|-
! Section !! Work
! Section !! Work
|-
| es5 || [[phab:T317739|Switchover es5 master (es1024 -> es1023) (T317739)]] (marostegui)
|-
| s3 || [[phab:T314041|Drop old templatelinks columns and indexes (T314041)]] (ladsgroup)
|-
|-
| s4 || [[phab:T314041|Drop old templatelinks columns and indexes (T314041)]] (ladsgroup)
| s4 || [[phab:T314041|Drop old templatelinks columns and indexes (T314041)]] (ladsgroup)
Line 19: Line 15:
! Section !! Work
! Section !! Work
|-
|-
| s3 || [[phab:T314041|Drop old templatelinks columns and indexes (T314041)]] (ladsgroup)
| s3 || [[phab:T317839|Switchover s3 codfw master (db2105 -> db2127) (T317839)]] (marostegui)
|-
|-
| s5 || [[phab:T317735|Switchover s5 codfw master (db2123 -> db2113) (T317735)]] (marostegui)
| s6 || [[phab:T317850|Switchover s6 codfw master (db2129 -> db2114) (T317850)]] (marostegui)
|-
|-
| s7 || [[phab:T314041|Drop old templatelinks columns and indexes (T314041)]] (ladsgroup)
| x1 || [[phab:T317842|Switchover x1 codfw master (db2115 -> db2096) (T317842)]] (marostegui)
|-
|-
|}
|}
Line 38: Line 34:
| s1 || [[phab:T312863|Schema change to change primary key of templatelinks (T312863)]] (ladsgroup)
| s1 || [[phab:T312863|Schema change to change primary key of templatelinks (T312863)]] (ladsgroup)
|-
|-
| s3 ||  
| s3 || [[phab:T314041|Drop old templatelinks columns and indexes (T314041)]] (ladsgroup)
* [[phab:T312863|Schema change to change primary key of templatelinks (T312863)]] (ladsgroup)
* [[phab:T314041|Drop old templatelinks columns and indexes (T314041)]] (ladsgroup)
* [[phab:T317349|Add primary key and drop unique index on wb_id_counters on wmf wikis (T317349)]] (marostegui)
|-
|-
| s4 ||  
| s4 || [[phab:T314041|Drop old templatelinks columns and indexes (T314041)]] (ladsgroup)
* [[phab:T314041|Drop old templatelinks columns and indexes (T314041)]] (ladsgroup)
* [[phab:T317349|Add primary key and drop unique index on wb_id_counters on wmf wikis (T317349)]] (marostegui)
|-
|-
| s7 || [[phab:T314041|Drop old templatelinks columns and indexes (T314041)]] (ladsgroup)
| s7 || [[phab:T314041|Drop old templatelinks columns and indexes (T314041)]] (ladsgroup)
|-
| s8 || [[phab:T317349|Add primary key and drop unique index on wb_id_counters on wmf wikis (T317349)]] (marostegui)
|-
|-
|}
|}
Line 67: Line 56:
| s2 || [[phab:T317627|Switchover s2 codfw master (db2104 -> db2107) (T317627)]] (marostegui)
| s2 || [[phab:T317627|Switchover s2 codfw master (db2104 -> db2107) (T317627)]] (marostegui)
|-
|-
| s3 || [[phab:T314041|Drop old templatelinks columns and indexes (T314041)]] (ladsgroup)
| s3 ||  
* [[phab:T314041|Drop old templatelinks columns and indexes (T314041)]] (ladsgroup)
* [[phab:T317839|Switchover s3 codfw master (db2105 -> db2127) (T317839)]] (marostegui)
|-
|-
| s4 || [[phab:T314041|Drop old templatelinks columns and indexes (T314041)]] (ladsgroup)
| s4 || [[phab:T314041|Drop old templatelinks columns and indexes (T314041)]] (ladsgroup)
|-
|-
| s5 || [[phab:T317735|Switchover s5 codfw master (db2123 -> db2113) (T317735)]] (marostegui)
| s5 || [[phab:T317735|Switchover s5 codfw master (db2123 -> db2113) (T317735)]] (marostegui)
|-
| s6 || [[phab:T317850|Switchover s6 codfw master (db2129 -> db2114) (T317850)]] (marostegui)
|-
|-
| s7 || [[phab:T314041|Drop old templatelinks columns and indexes (T314041)]] (ladsgroup)
| s7 || [[phab:T314041|Drop old templatelinks columns and indexes (T314041)]] (ladsgroup)
|-
| x1 || [[phab:T317842|Switchover x1 codfw master (db2115 -> db2096) (T317842)]] (marostegui)
|-
|-
|}
|}

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

Yesterday (2022-09-15)

eqiad
Section Work
s4 Drop old templatelinks columns and indexes (T314041) (ladsgroup)
codfw
Section Work
s3 Switchover s3 codfw master (db2105 -> db2127) (T317839) (marostegui)
s6 Switchover s6 codfw master (db2129 -> db2114) (T317850) (marostegui)
x1 Switchover x1 codfw master (db2115 -> db2096) (T317842) (marostegui)

Last seven days

eqiad
Section Work
es4 Switchover es4 master (es1021 -> es1020) (T317522) (marostegui)
es5 Switchover es5 master (es1024 -> es1023) (T317739) (marostegui)
s1 Schema change to change primary key of templatelinks (T312863) (ladsgroup)
s3 Drop old templatelinks columns and indexes (T314041) (ladsgroup)
s4 Drop old templatelinks columns and indexes (T314041) (ladsgroup)
s7 Drop old templatelinks columns and indexes (T314041) (ladsgroup)
codfw
Section Work
es4 Switchover es4 codfw master (es2021 -> es2020) (T317507) (marostegui)
es5 Switchover es5 codfw master (es2023 -> es2024) (T317508) (marostegui)
s1
s2 Switchover s2 codfw master (db2104 -> db2107) (T317627) (marostegui)
s3
s4 Drop old templatelinks columns and indexes (T314041) (ladsgroup)
s5 Switchover s5 codfw master (db2123 -> db2113) (T317735) (marostegui)
s6 Switchover s6 codfw master (db2129 -> db2114) (T317850) (marostegui)
s7 Drop old templatelinks columns and indexes (T314041) (ladsgroup)
x1 Switchover x1 codfw master (db2115 -> db2096) (T317842) (marostegui)