Page MenuHomePhabricator

Upgrade mysql on db1132 (phabricator db master)
Closed, ResolvedPublic

Description

We need to upgrade mysql on db1132 due to an upstream bug see T279281: Upgrade 10.4.13 hosts to a higher version.
This is simply a mysql restart, so I expect it to take around 1 minute
Impact: Writes will not work. Reads will not be affected.

@mmodell If you confirm the way to set up phabricator on RO is this, I can take care of this myself:

ssh phab1001
    sudo /srv/phab/phabricator/bin/config set cluster.read-only true
    # restart database server
    sudo /srv/phab/phabricator/bin/config set cluster.read-only false

Thanks!

Event Timeline

Marostegui triaged this task as Medium priority.Apr 8 2021, 8:14 AM
Marostegui moved this task from Triage to Refine on the DBA board.

@mmodell let me know if the above is enough and I will take care of this myself.
Thanks!

@Marostegui Confirmed, those are the commands to set read-only and then restore read-write.

Thank you! I will get this done early in the UTC morning next week.
Thanks again!

Mentioned in SAL (#wikimedia-operations) [2021-04-27T04:19:18Z] <marostegui> Set phabricator on read only T279625

Marostegui claimed this task.

This was done
RO starts: 04:19:51
RO stops: 04:20:18