Searched For: title: switchovertitle: mastertitle: dbtitle: >
AM UTC
** Prerequisites **: https://wikitech.wikimedia.org/wiki/MariaDB/Primary_switchover
[x] Team calen … imedia.org/conf/highlight.php?file=dblists/s7.dblist
**Checklist:**
NEW primary: db1181
OLD primary: db1136
[x] Check configuration diffe … ff --defaults-file /root/.my.cnf h=db1136.eqiad.wmnet h=db1181.eqiad.wmnet
```
**Failover pr … sts.downtime --hours 1 -r "Primary switchover s7 T311033" 'A:db-section-s7'
```
[x] Set NEW primar … groups if it is present).
```
sudo …
AM UTC
** Prerequisites **: https://wikitech.wikimedia.org/wiki/MariaDB/Primary_switchover
[x] Team calen … ```
**Checklist:**
NEW primary: db1120
OLD primary: db1103
[x] Check configuration diffe … ff --defaults-file /root/.my.cnf h=db1103.eqiad.wmnet h=db1120.eqiad.wmnet
```
**Failover pr … sts.downtime --hours 1 -r "Primary switchover x1 T300472" 'A:db-section-x1'
```
[x] Set NEW primar … groups if it is present).
```
sudo …
**Affected wikis:** https://noc.wikimedia.org/conf/highlight.php?file=dblists/s3.dblist
```
NEW primary: db1123
OLD primary: db1157
```
[x] Check configuration di … ff --defaults-file /root/.my.cnf h=db1157.eqiad.wmnet h=db1123.eqiad.wmnet
```
**Failover pr … sts.downtime --hours 1 -r "Primary switchover s3 T301850" 'A:db-section-s3'
```
[x] Set NEW primary with weight 0
```
sudo dbctl instance db1123 set-weight 0
sudo …
**Affected wikis:** https://noc.wikimedia.org/conf/highlight.php?file=dblists/s5.dblist
NEW primary: db1100
OLD primary: db1130
[x] Check configuration diffe … ff --defaults-file /root/.my.cnf h=db1130.eqiad.wmnet h=db1100.eqiad.wmnet
```
**Failover pr … sts.downtime --hours 1 -r "Primary switchover s5 T303798" 'A:db-section-s5'
```
[x] Set NEW primary with weight 0
```
sudo dbctl instance db1100 set-weight 0
sudo dbctl config commit -m "Set …
Databases on m5:
```
labsdbaccounts
mailman3
mailman3web
striker
test_labsdbaccounts
toolhub
```
When: 9th Marc … minute.**
Failover process
OLD MASTER: db1132
NEW MASTER: db1107
[x] Check configuration differences between new and old master
`$ pt-config-diff h=db1107.eqiad.wmnet,F=/root/.my.cnf h=db1132.eqiad.wmnet,F=/root/.my.cnf `
… ogy changes: move everything under db1107
`db-switchover --timeout=15 --only-slave-move …
db1183 needs to be reimaged to Bullseye.
Let's promote db1159 to master
When: Thursday 3rd Feb at 9:00AM … larships
* sockpuppet
* mwaddlink
Switchover steps:
OLD MASTER: db1183
NEW MASTER: db1159
Check configuration differences between new and old master
[x] `$ pt-config-diff h=db1159.eqiad.wmnet,F=/root/.my.cnf h=db1183.eqiad.wmnet,F=/root/.my.cnf `
… ogy changes: move everything under db1159
`db-switchover --timeout=1 --only-slave-move …
db1159 needs to be reimaged to Bullseye.
Let's promote db1128 to master
When: **Thursday 27th at 10AM UTC …
* etherpad
* librenms
* pki
* rt
Switchover steps:
OLD MASTER: db1159
NEW MASTER: db1128
Check configuration differences between new and old master
[x] `$ pt-config-diff h=db1159.eqiad.wmnet,F=/root/.my.cnf h=db1128.eqiad.wmnet,F=/root/.my.cnf `
… ogy changes: move everything under db1128
`db-switchover --timeout=1 --only-slave-move …
At some point we'd need to failover db1109 (row D) to db1104 (row B).
There are some reason … have many masters on row D, being db1109 one of them.
```
wikidatawiki
```
Date: 2020-09-29 08:00 UTC
The current s7 master, db1062 is old and needs to be decommissioned.
We are going to switchover db1062 to db1086 on Tue 26th Nov from 06:00 to … into new wikis, password changes...
The current s6 master, db1061 is old and needs to be decommissioned.
We are going to switchover db1061 to db1131 on Tue 19th Nov from 06:00 to … ndow:
```
frwiki
jawiki
ruwiki
```
The current s1 master, db1067 is old and needs to be decommissioned.
We are going to switchover db1067 to db1083 on Thu 14th Nov from 06:00 to … maintenance window:
```
enwiki
```
The current s5 master, db1070 is old and needs to be decommi … rs on that row.
**We are going to switchover db1070 to db1100 on Tuesday Tuesday 15th Octobe … yage
mgwiktionary
shwiki
srwiki
```
db1081 is on A2, which will be involv … ance {T227138}
We need to failover db1081 to db1138 which is on D8.
Date&Time: 26 … ead-only window will be required.
db1075 is on A2, which will be involv … ance {T227138}
We need to failover db1075 to db1123 which is on D8.
Date&Time: 24 … ead-only window will be required.
db1104 is on B3, which will be involv … ance {T227539}
We need to failover db1104 to db1109 which is on D8.
Date&Time: 10 … ead-only window will be required.
db1066 is on a6, which will be involv … ance {T227142}
We need to failover db1066 to db1122 which is on D6.
db1066 is also an old master that will be decommissioned {T2173 … ead-only window will be required.
We need to switch s1 master to mitigate: T155875
Let's use thi … paring it:
T156004
T156005
T156006