Page MenuHomePhabricator
Create Task
Maniphest T279625

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

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!

Related Objects
Search...

Event Timeline

Marostegui created this task.Apr 8 2021, 8:14 AM
Restricted Application added a subscriber: Aklapper. · View Herald TranscriptApr 8 2021, 8:14 AM
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.
Marostegui updated the task description. (Show Details)Apr 8 2021, 9:08 AM
Marostegui added a comment.Apr 14 2021, 11:05 AM

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

Aklapper moved this task from To Triage to Infrastructure on the Phabricator board.Apr 15 2021, 3:13 PM
• mmodell added a comment.Apr 21 2021, 7:29 AM

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

• mmodell awarded a token.Apr 21 2021, 7:29 AM
Marostegui added a comment.Apr 21 2021, 7:31 AM

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

Marostegui moved this task from Refine to Ready on the DBA board.Apr 21 2021, 7:31 AM
Stashbot added a comment.Apr 27 2021, 4:19 AM

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

Marostegui added a comment.Apr 27 2021, 4:20 AM

test

Marostegui closed this task as Resolved.Apr 27 2021, 4:22 AM
Marostegui claimed this task.

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

Content licensed under Creative Commons Attribution-ShareAlike (CC BY-SA) 4.0 unless otherwise noted; code licensed under GNU General Public License (GPL) 2.0 or later and other open source licenses. By using this site, you agree to the Terms of Use, Privacy Policy, and Code of Conduct. · Wikimedia Foundation · Privacy Policy · Code of Conduct · Terms of Use · Disclaimer · CC-BY-SA · GPL · Credits