Page MenuHomePhabricator

Filter cu_useragent on sanitarium
Closed, ResolvedPublic

Description

cu_useragent is meant to be private, so it needs to be included in the replication filters. This implies restarting mariadb instances on sanitarium hosts in both codfw and eqiad

  • db1154
  • db1155
  • db2186
  • db2187

Related Objects

StatusSubtypeAssignedTask
OpenFeatureNone
OpenFeatureNone
Resolved TBolliger
OpenNone
OpenNone
OpenNone
OpenNone
OpenNone
OpenNone
OpenNone
OpenNone
OpenNone
OpenNone
OpenNone
OpenNone
OpenNone
OpenNone
OpenNone
OpenNone
OpenNone
OpenNone
ResolvedDreamy_Jazz
ResolvedDreamy_Jazz
ResolvedDreamy_Jazz
Resolved Marostegui

Event Timeline

Marostegui created this task.
Marostegui moved this task from Triage to In progress on the DBA board.

Change #1016706 had a related patch set uploaded (by Marostegui; author: Marostegui):

[operations/puppet@production] common.yaml: Add cu_useragent to private tables

https://gerrit.wikimedia.org/r/1016706

Change #1016706 merged by Marostegui:

[operations/puppet@production] common.yaml: Add cu_useragent to private tables

https://gerrit.wikimedia.org/r/1016706

Mentioned in SAL (#wikimedia-operations) [2024-04-03T08:36:18Z] <marostegui> stop sanitarium codfw hosts T361673

Restarted on codfw and the table was correctly caught:

-- Non-public tables that are present:
DROP TABLE IF EXISTS `enwiki`.`cu_useragent`;

Starting to sanitize all the wikis

Mentioned in SAL (#wikimedia-operations) [2024-04-03T09:27:37Z] <marostegui> Restart sanitarium db1155 T361673

Mentioned in SAL (#wikimedia-operations) [2024-04-03T10:10:29Z] <marostegui> Restart sanitarium db1154 T361673

This is done - I am running a quick check on the clouddb* hosts to make sure it is all clean.