Page MenuHomePhabricator

Restart x1 database master (db1103)
Closed, ResolvedPublic

Description

We need to restart extension1 (x1) primary database master, db1103, as part of T266483
There is no way to disable x1 on MW so we'll need to set it to read-only on MySQL and restart it.

x1 currently has:

  • Databases: flowdb, cognate_wiktionary and wikishared database,
  • Tables on the x1 wikis are:
+-------------------+
| Tables_in_enwiki  |
+-------------------+
| aft_feedback      |
| echo_email_batch  |
| echo_event        |
| echo_notification |
| echo_target_page  |
+-------------------+
bounce_records
cx_corpora
cx_lists
cx_suggestions
cx_translations
cx_translators
echo_unread_wikis
reading_list
reading_list_entry
reading_list_project
urlshortcodes
wikimedia_editor_tasks_counts
wikimedia_editor_tasks_edit_streak
wikimedia_editor_tasks_keys
wikimedia_editor_tasks_targets_passed

The last time we did an x1 maintenance (T226358 and T250701) we used a bunch of tags, so I am tagging the same and subscribing the same people.

Impact: x1 will be on read-only for around 1 minute. Writes will not go through but reads will remain unaffected
When: Wednesday 17th Feb at 07:00 AM UTC

Event Timeline

Marostegui triaged this task as Medium priority.Wed, Feb 3, 1:45 PM
Marostegui moved this task from Triage to Ready on the DBA board.
Trizek-WMF added a project: User-notice.

Wow, this will happen soon!

If I read it correctly, it will disturb ContentTranslation, Flow, Echo (all Echo notifications at en.wp and all X-wiki notifications) and some other things. Can you confirm and tell me what will be the impact on front users there?

I guess you need community relation's help. :) Would you please create a separate task for this?

Wow, this will happen soon!

It will happen in 14 days.

If I read it correctly, it will disturb ContentTranslation, Flow, Echo (all Echo notifications at en.wp and all X-wiki notifications) and some other things. Can you confirm and tell me what will be the impact on front users there?

I guess you need community relation's help. :) Would you please create a separate task for this?

Yes, I was already doing it :-)
There you go: T273762

Thank you!

Marostegui renamed this task from Restart x1 database master to Restart x1 database master (db1103).Thu, Feb 4, 6:51 AM
Marostegui updated the task description. (Show Details)

Mentioned in SAL (#wikimedia-operations) [2021-02-17T07:00:04Z] <marostegui> Restart db1103 (x1) primary master - T273758

Mentioned in SAL (#wikimedia-operations) [2021-02-17T07:01:26Z] <marostegui> Restart db1103 (x1) primary master DONE - T273758

This was done:
Master down: 07:00:09
Master up: 07:01:24

Closing this as fixed:

# mysql -e "select @@report_host"
+--------------------+
| @@report_host      |
+--------------------+
| db1103.eqiad.wmnet |
+--------------------+