In order to be able to enable report_host variable on db1132 we'd need to issue a mariadb daemon restart for db1132.
We expect this to take around 1 minute.
When: Wed 27th at 06:00 AM UTC
Impact: Phabricator will be on read-only for around 1 minute.
@mmodell if possible, would be around for this? Let me know when would be a good time for you? I start working pretty early in the UTC morning (around 6AM UTC) so any time around that or later (whatever fits best your schedule) would work.
| Status | Subtype | Assigned | Task | ||
|---|---|---|---|---|---|
| Restricted Task | |||||
| Resolved | Legoktm | T281515 June 2021 Datacenter switchover | |||
| Resolved | • Marostegui | T285139 DB maintenance work to do while eqiad is passive (June 2021) | |||
| Resolved | • Marostegui | T266483 Enable report_host for mariadb | |||
| Resolved | • Marostegui | T272568 Add m* and es4/es5 sections to Orchestrator | |||
| Resolved | • Marostegui | T272596 Restart m3 (phabricator) database master db1132 |
@Marostegui I can do 06:00 UTC, I don't usually go to bed until a bit later than that. I guess any day is fine, I think 06:00-07:00 UTC is actually the best time that would overlap both of our awake times.
Procedure:
Pre restart
Restart
Mentioned in SAL (#wikimedia-operations) [2021-01-27T06:00:54Z] <marostegui> m3 master restart, phabricator will go on read only - T272596
This was done. RO time for phabricator was around:
06:01:53 ON
06:03:12 OFF
Thanks @mmodell for the help!
root@db1132.eqiad.wmnet[(none)]> select @@report_host; +--------------------+ | @@report_host | +--------------------+ | db1132.eqiad.wmnet | +--------------------+ 1 row in set (0.001 sec)
Mentioned in SAL (#wikimedia-operations) [2021-01-28T09:00:11Z] <marostegui> m5 master restart, wikitech will be unavailable - T272596