Page MenuHomePhabricator
Search Advanced Search
Searched For: title: switchovertitle: mastertitle: dbtitle: >
    • Task
    • ·Closed
    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 …
    • Task
    • ·Closed
    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 …
    • Task
    • ·Closed
    **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 …
    • Task
    • ·Closed
    **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 …
    • Task
    • ·Closed
    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 …
    • Task
    • ·Closed
    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 …
    • Task
    • ·Closed
    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 …
    • Task
    • ·Closed
    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
    • Task
    • ·Closed
    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...
    • Task
    • ·Closed
    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 ```
    • Task
    • ·Closed
    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 ```
    • Task
    • ·Closed
    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 ```
    • Task
    • ·Closed
    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.
    • Task
    • ·Closed
    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.
    • Task
    • ·Closed
    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.
    • Task
    • ·Closed
    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.
    • Task
    • ·Closed
    We need to switch s1 master to mitigate: T155875 Let's use thi … paring it: T156004 T156005 T156006