Page MenuHomePhabricator

Restart extension1 (x1) database primary master (db1120)
Closed, ResolvedPublic

Description

We need to upgrade and restart extension1 (x1) primary database master as part of T239791: DB: perform rolling restart of mariadb daemons to pick up CA changes
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:
Apart from flowdb database, the tables on the x1 wikis are:

+-------------------+
| Tables_in_enwiki  |
+-------------------+
| aft_feedback      |
| echo_email_batch  |
| echo_event        |
| echo_notification |
| echo_target_page  |
+-------------------+

It also stores wikishared database;

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) 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: Thursday 30th April at 05:00 AM UTC

Event Timeline

Hmm, Cognate should be in the lists in the description?
Or am I confusing something?

Hmm, Cognate should be in the lists in the description?
Or am I confusing something?

It is there on the tag list.
cognate_wiktionary does live in x1, yep.

Mentioned in SAL (#wikimedia-operations) [2020-04-29T07:55:10Z] <marostegui> Upgrade mysql on x1 master (without restarting) in preparation for tomorrow's upgrade - T250701

I have updated the mysql package to 10.1.43-2
Tomorrow I will issue the restart + mysql_upgrade

Mentioned in SAL (#wikimedia-operations) [2020-04-30T05:00:18Z] <marostegui> Restart x1 master (db1120) - T250701

Mentioned in SAL (#wikimedia-operations) [2020-04-30T05:02:21Z] <marostegui> Restart x1 master finished - T250701

This was done.
The server was unaccessible from 05:00:41 to 05:02:02