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-09) ==
== Today (2022-09-10) ==
== Yesterday (2022-09-08) ==
{| class="wikitable"
|+ codfw
|-
! Section !! Work
|-
| s4 || [[phab:T314041|Drop old templatelinks columns and indexes (T314041)]] (ladsgroup)
|-
|}
== Yesterday (2022-09-09) ==
{| class="wikitable"
{| class="wikitable"
|+ eqiad
|+ eqiad
Line 7: Line 15:
! Section !! Work
! Section !! Work
|-
|-
| s3 || [[phab:T316622|Switchover s3 master (db1157 -> db1123) (T316622)]] (ladsgroup)
| s1 || [[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)
* [[phab:T317349|Add primary key and drop unique index on wb_id_counters on wmf wikis (T317349)]] (marostegui)
|-
| s4 ||
* [[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)
|-
| s8 || [[phab:T317349|Add primary key and drop unique index on wb_id_counters on wmf wikis (T317349)]] (marostegui)
|-
|}
{| class="wikitable"
|+ codfw
|-
! Section !! Work
|-
| s1 || [[phab:T312863|Schema change to change primary key of templatelinks (T312863)]] (ladsgroup)
|-
|-
| s7 || [[phab:T316342|Productionize db1196-db1203 (T316342)]] (marostegui)
| s4 || [[phab:T314041|Drop old templatelinks columns and indexes (T314041)]] (ladsgroup)
|-
|-
|}
|}
Line 26: Line 52:
|-
|-
| s3 ||  
| s3 ||  
* [[phab:T312863|Schema change to change primary key of templatelinks (T312863)]] (ladsgroup)
* [[phab:T316342|Productionize db1196-db1203 (T316342)]] (marostegui)
* [[phab:T316342|Productionize db1196-db1203 (T316342)]] (marostegui)
* [[phab:T316622|Switchover s3 master (db1157 -> db1123) (T316622)]] (ladsgroup)
* [[phab:T316622|Switchover s3 master (db1157 -> db1123) (T316622)]] (ladsgroup)
* [[phab:T317349|Add primary key and drop unique index on wb_id_counters on wmf wikis (T317349)]] (marostegui)
|-
|-
| s4 || [[phab:T316342|Productionize db1196-db1203 (T316342)]] (marostegui)
| s4 ||  
* [[phab:T314041|Drop old templatelinks columns and indexes (T314041)]] (ladsgroup)
* [[phab:T316342|Productionize db1196-db1203 (T316342)]] (marostegui)
* [[phab:T317349|Add primary key and drop unique index on wb_id_counters on wmf wikis (T317349)]] (marostegui)
|-
|-
| s5 || [[phab:T316342|Productionize db1196-db1203 (T316342)]] (marostegui)
| s5 || [[phab:T316342|Productionize db1196-db1203 (T316342)]] (marostegui)
Line 39: Line 70:
| s7 || [[phab:T316342|Productionize db1196-db1203 (T316342)]] (marostegui)
| s7 || [[phab:T316342|Productionize db1196-db1203 (T316342)]] (marostegui)
|-
|-
| s8 || [[phab:T316342|Productionize db1196-db1203 (T316342)]] (marostegui)
| s8 ||  
* [[phab:T316342|Productionize db1196-db1203 (T316342)]] (marostegui)
* [[phab:T317349|Add primary key and drop unique index on wb_id_counters on wmf wikis (T317349)]] (marostegui)
|-
|-
| x1 || [[phab:T316745|Switchover x1 master (db1103 -> db1120) (T316745)]] (marostegui)
| x1 || [[phab:T316745|Switchover x1 master (db1103 -> db1120) (T316745)]] (marostegui)
Line 48: Line 81:
|-
|-
! Section !! Work
! Section !! Work
|-
| s1 || [[phab:T312863|Schema change to change primary key of templatelinks (T312863)]] (ladsgroup)
|-
|-
| s4 || [[phab:T314041|Drop old templatelinks columns and indexes (T314041)]] (ladsgroup)
| s4 || [[phab:T314041|Drop old templatelinks columns and indexes (T314041)]] (ladsgroup)

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

codfw
Section Work
s4 Drop old templatelinks columns and indexes (T314041) (ladsgroup)

Yesterday (2022-09-09)

eqiad
Section Work
s1 Schema change to change primary key of templatelinks (T312863) (ladsgroup)
s3
s4
s8 Add primary key and drop unique index on wb_id_counters on wmf wikis (T317349) (marostegui)
codfw
Section Work
s1 Schema change to change primary key of templatelinks (T312863) (ladsgroup)
s4 Drop old templatelinks columns and indexes (T314041) (ladsgroup)

Last seven days

eqiad
Section Work
s1
s2 Productionize db1196-db1203 (T316342) (marostegui)
s3
s4
s5 Productionize db1196-db1203 (T316342) (marostegui)
s6
s7 Productionize db1196-db1203 (T316342) (marostegui)
s8
x1 Switchover x1 master (db1103 -> db1120) (T316745) (marostegui)
codfw
Section Work
s1 Schema change to change primary key of templatelinks (T312863) (ladsgroup)
s4 Drop old templatelinks columns and indexes (T314041) (ladsgroup)
s6 Drop old templatelinks columns and indexes (T314041) (ladsgroup)