Searched For: title: switchovertitle: mastertitle: dbtitle: >
**When:** During a pre-defined DBA maintenance windows
**Prerequisi … //wikitech.wikimedia.org/wiki/MariaDB/Primary_switchover
[x] Team calen … imedia.org/conf/highlight.php?file=dblists/s1.dblist
**Checklist:**
NEW primary: db2103
OLD primary: db2112
[x] Check configuration diffe … ff --defaults-file /root/.my.cnf h=db2112.codfw.wmnet h=db2103.codfw.wmnet
```
```
$ sudo … ff --defaults-file /root/.my.cnf h=db2112.codfw.wmnet h=…
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: db1136
OLD primary: db1181
[x] Check configuration diffe … ff --defaults-file /root/.my.cnf h=db1181.eqiad.wmnet h=db1136.eqiad.wmnet
```
**Failover pr … sts.downtime --hours 1 -r "Primary switchover s7 T313383" 'A:db-section-s7'
```
[x] Set NEW primar … groups if it is present).
```
sudo …
**When:** During a pre-defined DBA maintenance windows: Thursday Jun … //wikitech.wikimedia.org/wiki/MariaDB/Primary_switchover
[x] Team calen … imedia.org/conf/highlight.php?file=dblists/s7.dblist
**Checklist:**
NEW primary: db1136
OLD primary: db1181
[x] Check configuration diffe … ff --defaults-file /root/.my.cnf h=db1181.eqiad.wmnet h=db1136.eqiad.wmnet
```
**Failover pr … sts.downtime --hours 1 -r "Primary switchover s7 T309617" 'A:…
**When:** During a pre-defined DBA maintenance windows: Tuesday 31st … //wikitech.wikimedia.org/wiki/MariaDB/Primary_switchover
[x] Team calen … imedia.org/conf/highlight.php?file=dblists/s5.dblist
**Checklist:**
NEW primary: db1130
OLD primary: db1100
[x] Check configuration diffe … ff --defaults-file /root/.my.cnf h=db1100.eqiad.wmnet h=db1130.eqiad.wmnet
```
**Failover pr … sts.downtime --hours 1 -r "Primary switchover s5 T308725" 'A:…
**When:** During a pre-defined DBA maintenance windows: 26th April a … //wikitech.wikimedia.org/wiki/MariaDB/Primary_switchover
[x] Team calen … imedia.org/conf/highlight.php?file=dblists/s2.dblist
**Checklist:**
NEW primary: db1162
OLD primary: db1122
[x] Check configuration diffe … ff --defaults-file /root/.my.cnf h=db1122.eqiad.wmnet h=db1162.eqiad.wmnet
```
**Failover pr … sts.downtime --hours 1 -r "Primary switchover…
**When:** During a pre-defined DBA maintenance windows - Tuesday 19t … //wikitech.wikimedia.org/wiki/MariaDB/Primary_switchover
[x] Team calen … imedia.org/conf/highlight.php?file=dblists/s7.dblist + `centralauth`
**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 …
**When:** During a pre-defined DBA maintenance windows. Tuesday 12th … iki`
**Checklist:**
NEW primary: db1160
OLD primary: db1138
[x] Check configuration diffe … ff --defaults-file /root/.my.cnf h=db1138.eqiad.wmnet h=db1160.eqiad.wmnet
```
**Failover pr … sts.downtime --hours 1 -r "Primary switchover s4 T304933" 'A:db-section-s4'
```
[x] Set NEW primary with weight 0
```
sudo dbctl instance db1160 set-weight 0
sudo dbctl config commit -m "Set …
re-defined window in Thursday 21st 2022
**Checklist:**
NEW primary: db1104
OLD primary: db1109
[x] Check configuration diffe … ff --defaults-file /root/.my.cnf h=db1109.eqiad.wmnet h=db1104.eqiad.wmnet
```
**Failover pr … sts.downtime --hours 1 -r "Primary switchover s8 T303927" 'A:db-section-s8'
```
[x] Set NEW primary with weight 0
```
sudo dbctl instance db1104 set-weight 0
sudo dbctl config commit -m "Set db1104 with weight 0 T303927"
```
[x] … eplicas under NEW primary
```
sudo …
AM UTC
** Prerequisites **: https://wikitech.wikimedia.org/wiki/MariaDB/Primary_switchover
[x] Team calen … imedia.org/conf/highlight.php?file=dblists/s6.dblist
**Checklist:**
NEW primary: db1131
OLD primary: db1173
[x] Check configuration diffe … ff --defaults-file /root/.my.cnf h=db1173.eqiad.wmnet h=db1131.eqiad.wmnet
```
**Failover pr … sts.downtime --hours 1 -r "Primary switchover s6 T300471" 'A:db-section-s6'
```
[x] Set NEW primar … groups if it is present).
```
sudo …
when=2021-08-24 23:00 SF
|length=0.5
|window=Database primary switchover for s7
|who={{ircnick|kormat|S … a.org/T301312
}}
```
NEW primary: db1163
OLD primary: db1118
[x] Check configuration diffe … ff --defaults-file /root/.my.cnf h=db1118.eqiad.wmnet h=db1163.eqiad.wmnet
```
**Failover pr … sts.downtime --hours 1 -r "Primary switchover s1 T301312" 'A:db-section-s1'
```
[x] Set NEW primary with weight 0
```
sudo …
rites will be disabled for around 1 minute.**
Failover process
OLD MASTER: db1107
NEW MASTER: db1183
[x] Check configuration differences between new and old master
`$ pt-config-diff h=db1107.eqiad.wmnet,F=/root/.my.cnf h=db1183.eqiad.wmnet,F=/root/.my.cnf `
… ogy changes: move everything under db1183
`db-switchover --timeout=15 --only-slave-move db1107.eqiad.wmnet db1183.eqiad.wmnet`
[x] Disable puppet db1107 and …