Page MenuHomePhabricator

Switchover codfw primary database masters to new hosts
Open, NormalPublic

Description

All the codfw old masters need to be switched over to the new hosts (512GB+SSDs)
List of shards

  • s1
  • s2 db2035 -> db2107
  • s3 db2043 -> db2105
  • s4 db2051 -> db2090
  • s5 db2052 -> db2123
  • s6
  • s7
  • s8 db2045 -> db2079
  • x1 db2069 -> db2096

Event Timeline

Marostegui renamed this task from Switchover codfw masters to new hosts to Switchover codfw primary database masters to new hosts.Thu, Aug 8, 8:46 AM
Marostegui triaged this task as Normal priority.
Marostegui updated the task description. (Show Details)
Marostegui moved this task from Triage to In progress on the DBA board.

Change 529704 had a related patch set uploaded (by Marostegui; owner: Marostegui):
[operations/puppet@production] mariadb: Promote db2105 to s3 codfw master

https://gerrit.wikimedia.org/r/529704

Mentioned in SAL (#wikimedia-operations) [2019-08-12T07:34:38Z] <marostegui> Switchover s3 codfw master db2043 -> db2105 - T230106

Change 529705 had a related patch set uploaded (by Marostegui; owner: Marostegui):
[operations/mediawiki-config@master] db-codfw.php: Re-organize s3 codfw

https://gerrit.wikimedia.org/r/529705

Change 529704 merged by Marostegui:
[operations/puppet@production] mariadb: Promote db2105 to s3 codfw master

https://gerrit.wikimedia.org/r/529704

Mentioned in SAL (#wikimedia-operations) [2019-08-12T07:43:15Z] <marostegui@cumin1001> dbctl commit (dc=all): 'Promote db2105 to s3 codfw master T230106', diff saved to https://phabricator.wikimedia.org/P8900 and previous config saved to /var/cache/conftool/dbconfig/20190812-074314-marostegui.json

Change 529705 merged by jenkins-bot:
[operations/mediawiki-config@master] db-codfw.php: Re-organize s3 codfw

https://gerrit.wikimedia.org/r/529705

Change 529725 had a related patch set uploaded (by Marostegui; owner: Marostegui):
[operations/puppet@production] db2127: Clarify it is a candidate master

https://gerrit.wikimedia.org/r/529725

Change 529725 merged by Marostegui:
[operations/puppet@production] db2127: Clarify it is a candidate master

https://gerrit.wikimedia.org/r/529725

Marostegui updated the task description. (Show Details)Mon, Aug 12, 9:57 AM

Change 531049 had a related patch set uploaded (by Marostegui; owner: Marostegui):
[operations/mediawiki-config@master] db-codfw.php: Re-organize s5 codfw

https://gerrit.wikimedia.org/r/531049

Change 531049 merged by jenkins-bot:
[operations/mediawiki-config@master] db-codfw.php: Re-organize s5 codfw

https://gerrit.wikimedia.org/r/531049

Mentioned in SAL (#wikimedia-operations) [2019-08-20T07:50:12Z] <marostegui@deploy1001> Synchronized wmf-config/db-codfw.php: Reorganize s5 codfw weights T230106 (duration: 00m 47s)

Change 531050 had a related patch set uploaded (by Marostegui; owner: Marostegui):
[operations/puppet@production] mariadb: Promote db2123 to s5 codfw master

https://gerrit.wikimedia.org/r/531050

Change 531051 had a related patch set uploaded (by Marostegui; owner: Marostegui):
[operations/mediawiki-config@master] db-codfw.php: Promote db2123 to s5 codfw master

https://gerrit.wikimedia.org/r/531051

Mentioned in SAL (#wikimedia-operations) [2019-08-20T08:05:52Z] <marostegui> Switchover s5 codfw master db2052 -> db2123 T230106

Change 531050 merged by Marostegui:
[operations/puppet@production] mariadb: Promote db2123 to s5 codfw master

https://gerrit.wikimedia.org/r/531050

Change 531051 merged by jenkins-bot:
[operations/mediawiki-config@master] db-codfw.php: Promote db2123 to s5 codfw master

https://gerrit.wikimedia.org/r/531051

Mentioned in SAL (#wikimedia-operations) [2019-08-20T08:19:57Z] <marostegui@deploy1001> Synchronized wmf-config/db-codfw.php: Promote db2123 to s5 codfw master T230106 (duration: 00m 48s)

Mentioned in SAL (#wikimedia-operations) [2019-08-20T08:24:12Z] <marostegui@cumin1001> dbctl commit (dc=all): 'Re-organize s5 codfw weights - T230106', diff saved to https://phabricator.wikimedia.org/P8935 and previous config saved to /var/cache/conftool/dbconfig/20190820-082411-marostegui.json

Mentioned in SAL (#wikimedia-operations) [2019-08-20T08:28:03Z] <marostegui@cumin1001> dbctl commit (dc=all): 'Set db2123 as codfw s5 master - T230106', diff saved to https://phabricator.wikimedia.org/P8936 and previous config saved to /var/cache/conftool/dbconfig/20190820-082802-marostegui.json

Marostegui updated the task description. (Show Details)Tue, Aug 20, 8:35 AM

s5 codfw master has been swapped from db2052 to db2123